Use dynamic management views to inspect active requests, waits, cached queries, index activity, and file space without guessing at server health.
GROUP BY Done Right
GROUP BY Done Right separates row filters from group filters, handles NULL groups, and avoids totals inflated by careless joins.
SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
A simple script on sys.objects that shows the stored procedure create date and modified date, handy for audits and for watching changes to your objects.
SQL SERVER – Fix: Error 2596 The repair statement was not processed. The database cannot be in read-only mode
Error 2596 stops a DBCC repair because the database is read only. Here is the safe order: back up, single user, read write, repair and check again.
Which Sample Database to Use for Which Demo
Which sample database fits your lesson? Compare AdventureWorks, WideWorldImporters, and Stack Overflow data before choosing a demo.
Fast Bulk Inserts From Python
Bulk inserts from Python work best with parameterized executemany, measured batch sizes, a tested fast_executemany path, and clear restart rules.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.