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,229 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,145 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,401 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
629 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,186 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,683 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,310 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,234 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
473 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,625 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Kantor Batik Air Yogyakarta | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Laksda Adi Sutjipto Km. 7, Flyover, Janti,...
Kantor Batik Air Semarang | Telp.08557033334
Hub Admin Batik Air Telp/wa 08557033334 Jl. Bandara Jendral Ahmad Yani, Kalibanteng Kulon, Kec....
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers