My SQLPASS 2011 event log in photos from Seattle: the skyline, the convention center, the gum wall, the first Starbucks and people on the street.
SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.
Connecting to SQL Server Express failed while obtaining the dedicated administrator connection (DAC) port. Here is why it happens and how to fix it.
Personal Notes – Random Thoughts and Random Ideas
There are days when I keep on wondering about SQL, and even my life overall. Let us see some random thoughts and random ideas.
SQL SERVER – DATEDIFF – Accuracy of Various Dateparts
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.
SQL SERVER – TRACEWRITE – Wait Type – Wait Related to Buffer and Resolution
What does the TRACEWRITE wait type mean, and how do you resolve it? A DBA saw it as the top wait on his system, so here is a quick explanation.
SQL SERVER – A Simple Quiz – T-SQL Brain Trick
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?
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.