Something which may seem basic, but in many SQL statements I analyse for performance optimisation, the same mistakes are recurring. When a WHERE cl...

Recently, I had the following problem to consider. Two similar SELECT statements, the one difference being the WHERE clause. If you notice the...

Recently , I had to use osql for some remote auditing which I found useful. For those who don't know ,osql is a standard app that comes with SQL Se...

select 
    c_c_u.table_name sr_c_table, 
    c_c_u.constraint_name sr_c_constraint, 
    c_c_u.column_name sr_c_col, 
    ...
                        

SQL Server database and file size is returned in this script, compared to total and free disk space. It also displays the number of Kb that each ...

Returns records form the error log based on search terms

DECLARE @SERVER NVARCHAR(50)
SET @SERVER = 'SERVER1\INSTANCE'...
                        

An excellent script to deal with XML documents that are greater than 8000 characters

Use it like:

DECLARE @hDoc...
                        

I read and used an excellent tip on: http://www.sql-server-performance.c...

Pagination is a regular technique used for developing web applications. There are numerous methods of implementing pagination. Below, I'm creating ...