Cursors to Increase Performance?
I recently had the chance to look over a friends shoulder at a query that needed some tuning work. In...
2007-07-06
735 reads
Blogs
One of the suggestions I saw today was to add blogs to the user profile on the site and not...
2007-07-05
660 reads
70-444 Exam Prep Book
I just got my author copies of the Sybex book for exam 70-444 and have to say the book looks...
2007-07-05
746 reads
The Journey to Katmai
I wrote an article recently on the Journey To Katmai, looking at some of the new features that are coming...
2007-07-04
692 reads
Who said that breaking up is hard to do?
Some of you younger DBA’s out there may not know who Neil Sedaka is or remember his poignant words "Breaking...
2007-07-03
622 reads
Working Remotely
Most people I know tend to work in one of two places consistently: work or home. So they've built a...
2007-07-03
572 reads
Breaking Up is Easy to Do
Breaking Up is Easy to DoHardIt's nice to be able to package a process into a single, tidy, elegant query,...
2007-07-03
632 reads
Earthquake
This is pretty cool, a, earthquake test for Project Black Box from Sun. They take one of their systems to...
2007-07-01
636 reads
The War Begins :: Reporting for duty
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we...
2007-06-29
1,347 reads
SQL Server Error Logs
The active SQL Server error log is one of the first places people look when there is a problem. For...
2007-06-29
1,600 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers