A T-SQL brain trick: three SELECT statements are separated by lines of underscores, and running one of those lines alone gives Msg 2812. Can you explain why?
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
POC Index: Supporting Window Functions Without a Sort
Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.
Lost Updates: Optimistic Concurrency With a rowversion Column
Prevent lost updates with optimistic concurrency and a rowversion token, detect zero-row conflicts, and compare short locking transactions.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.
SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
Three new DMVs in SQL Server Denali: sys.dm_server_memory_dumps, sys.dm_server_services and sys.dm_server_registry. What they return, and a question for you.
Scheduling Patch Windows Without Surprises
Scheduling Patch Windows requires realistic restart time, failover steps, job coordination, backup checks, and clear stop rules.
SQL SERVER – SQLPASS Memory Lane of 2009 and 2010
My SQLPASS memory lane: links to my notes and experiences from SQLPASS 2009 and 2010 in Seattle, shared on the last day of SQLPASS 2011.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.