SQL Server Archives - Page 388 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX

April 8, 2007

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Server Security, SQL Utility

We can use either CHARINDEX or PATINDEX to search in TEXT field in SQL SERVER. The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. Both functions take two arguments. With PATINDEX, you must include percent signs before and after the pattern, unless you are looking…

SQL SERVER – DBCC Commands Introduced in SQL Server 2005

April 7, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server DBCC

SQL Server 2005 has introduced following two documented and five undocumented DBCC Commands. I was able to find documentation for only first one online. If you find any documentation of any other DBCC Commands please add comments. It will be helpful to all of us. Documented: freesessioncache () — no…

SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1

April 6, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

DBA, SQL Download, SQL Error Messages, SQL Server DBCC, SQL Server Security

I have received this error many times on different servers in my careers. There is no single fix for this Error. Server: Msg 7391, Level 16, State 1, Line 1 can happen due to many reasons. I have used various of this reasons with few of my servers. Please refer…

SQL SERVER – Performance Optimization of SQL Query and FileGroups

April 5, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Download, SQL Index

It is suggested to place transaction logs on separate physical hard drives. In this manner, data can be recovered up to the second in the event of a media failure. In SQL 2005 When database is created without specifying a transaction log size, the transaction log will be re-sized to…

SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005

April 3, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Download, SQL Scripts, SQL Stored Procedure

I was doing paging in SQL Server 2000 using Temp Table or Derived Tables. I decided to checkout new function ROW_NUMBER() in SQL Server 2005. ROW_NUMBER() returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.…

SQL SERVER – 2005 – Performance Dashboard Reports

April 2, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Download

The Microsoft SQL Server 2005 Performance Dashboard Reports are used to monitor and resolve performance problems on your SQL Server 2005 database server. The SQL Server instance being monitored and the Management Studio client used to run the reports must both be running SP2 or later. Common performance problems that…

SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)

March 31, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, Software Development, SQL Download

Microsoft has released a tool called the Microsoft SQL Server Best Practices Analyzer. With this tool, you can test and implement a combination of SQL Server best practices and then implement them on your SQL Server. The SQL Server 2005 Best Practices Analyzer gathers data from Microsoft Windows and SQL…