Revisit SQL basics that change query results: NULL logic, logical processing order, grouped filters, and the difference between two common counts.
SQL SERVER – Find Last Day of Any Month – Current Previous Next
Find the last day of any month with DATEADD and DATEDIFF. One script returns the last day of the previous, current and next month in SQL Server.
SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
What are online index operations? SQL Server 2005 Enterprise Edition can create, rebuild and drop indexes without locking tables, and I explain how.
Writing Clear Error Messages in Procedures
Clear error messages in procedures identify the failed operation, useful keys, and next action without exposing sensitive data.
The Dynamic Management Views Worth Knowing by Heart
Use dynamic management views to inspect active requests, waits, cached queries, index activity, and file space without guessing at server health.
SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
NEWSEQUENTIALID() and NEWID() both create a uniqueidentifier GUID. NEWID() is random while NEWSEQUENTIALID() is sequential, as my test table shows.
SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
How to copy data from one table to another without a cursor: INSERT INTO SELECT for an existing table, or SELECT INTO to create a new table.