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
Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,522 reads
July Monthly SQL Server Checklist
It’s a new month, and time to check out your SQL Servers to make sure everything is configured and working...
2011-07-05
1,052 reads
How my SQL Server trainings helped Hannes and his company to improve their SQL Server based software
In the last months I have done a lot of SQL Server consulting engagements where I
have seen the craziest performance...
2011-07-05
848 reads
Converting OR to Union
When I looked at indexing for queries containing predicates combined with OR, it became clear that the are some restrictive...
2011-07-05
1,690 reads
SQL Server “Denali”: Project Crescent
Project “Crescent” is a new interactive data exploration and visual presentation experience coming in the next version of SQL Server, code-named “Denali”. It will...
2011-07-05
1,394 reads
SQLDIY: Statistics Information Including Last Update
One of the most important aspects of keeping your system running well is updating and managing your statistics. Since the...
2011-07-05
1,012 reads
Deleting Accounts from Websites
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
927 reads
PASS SQL Rally 2011 Evaluations
In keeping with the all my other major speaking engagements, I’m posting the results of my pre-con and session evals...
2011-07-05
944 reads
T-SQL Enhancement: EXECUTE WITH RESULT SETS
All developers know, that it is very important to encapsulate code in classes and methods to be able to reuse...
2011-07-05
809 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...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
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