SQL Scripts Archives - Page 221 of 366 - SQL Authority with Pinal Dave

A small flashlight beside a closed notebook and plain ceramic mug on a dim wooden desk.

What to Check When You Are Woken at Three in the Morning

October 26, 2011

Best Practices, Database, SQL Scripts, SQL Server

Use a DBA on call checklist to establish impact, inspect blocking and disk space, review failed jobs, and choose a safe next step during incidents.

SQL SERVER – DATEDIFF – Accuracy of Various Dateparts

October 21, 2011

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Scripts

Why does DATEDIFF say 1 minute between two times only 3 seconds apart? It is not a bug. Here is how DATEDIFF counts datepart boundaries.

Results window in sql server management studio.

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

October 19, 2011

Pinal Dave

SQL Puzzle

SQL Scripts

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?

A spokeshave follows a straight spindle, leaving neatly aligned wood shavings

POC Index: Supporting Window Functions Without a Sort

October 18, 2011

Pinal Dave

SQL Performance

SQL Performance, SQL Scripts, SQL Server

Is a Sort slowing down your running totals? Build an index in partition, order, covering order and watch the Sort disappear from the plan.

SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry

October 16, 2011

Pinal Dave

SQL Tips and Tricks

SQL DMV, SQL Scripts, SQL Server

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.