Do you use T-SQL debugging?
T-SQL debugging is not 100% in SQL Server. It has few bad drawbacks starting from difficulties when setting it up...
2011-07-13
1,210 reads
SQL Treeo
Copying parent-child rows and SQL Dependency Tracker
I was facing quite well-known issue today – I had to develop logic of duplicating (versioning) parent-child records. Because I was...
2011-07-12
2,059 reads
Select random records using TABLESAMPLE clause
While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...
2011-07-11
1,385 reads
Denali’s Skeletons in the closet (and workaround), Part II
I continued to check SQL Server 2011 “Denali” for few things I dislike on 2008 R2 and tried to find...
2011-07-11
609 reads
How to merge (combine) date intervals in T-SQL
On my current project, I am dealing with date intervals in T-SQL very heavily. I’ve hit interesting issue recently – how...
2011-07-08
2,144 reads
Showing slowest parts of SQL query
I’ve received interesting question/requirement few days ago:
“… When viewing a query plan graphically, we usually have to hunt for the...
2011-07-08
1,663 reads
Wife and kids are leaving for holiday (it’s not off-topic)
My wife and kids are leaving for holiday (without me). Bad thing is that I will miss them, good thing...
2011-07-07
1,288 reads
Less code with rethrowing “exception” in SQL Server 2011
I wrote about some skeletons in the Denali’s closet here. Let’s also put some good on the table. Very handy...
2011-07-06
1,199 reads
Denali’s Skeletons in the closet, Part I
I’ve started to play little bit with SQL Server 2011 CTP Denali to find out whether some open wounds were...
2011-07-06
458 reads
SQL Server on steroids with RAM disk
I’ve faced pretty common situation recently – you need to work with huge data during development/testing. It’s good if you have...
2011-07-05
2,534 reads
Blogs
T-SQL Tuesday #188: Growing the Community
By Steve Jones
This month we have a great T-SQL Tuesday, hosted by John Sterrett. He has...
Unveiling the Legacy: POSTGRES to Modern Open-Source Powerhouse
By Rohit Garg
PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...
Capturing errors and auditing in Azure SQL DB
Logging is a necessity in the database world, well, the entire tech world. You...
Forums
The Mindset of a Database Administrator: A Love Letter to Risk Aversion
Comments posted to this topic are about the item The Mindset of a Database...
Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You
Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...
how to move all SP from one db to another db?
Hi everyone I have two db - one is test and other is archive. ...
Question of the Day
Independence Day
The film independence day was released in 1996. Which of these queries returns that year is run today?
See possible answers