Indexing for ORs
All of the indexing strategy posts I’ve written in the past have been concerned with predicates combined with ANDs. That’s...
2011-05-03
1,025 reads
How often do you check email?
If you read the experts, most folks check their emails too many times during the day. Today, while giving a...
2011-05-03
796 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
20 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that would read all columns for each row passed through...
2011-05-03
152 reads
Calling all UK Bloggers…
Amazingly It’s been just over 4 months since I started my list of UK based SQL Server bloggers, and I...
2011-05-03
595 reads
My Partitioning And Compression Quest!
So I have a pretty big database (around 1 TB) that’s getting a bit out of
hand. I inherited it...
2011-05-03
664 reads
Iterating Over Columns in the SSIS Script Component
Just recently a question was posed in the MSDN SSIS Forums about how to create a "generic" script component that...
2011-05-03
13,276 reads
Meme Monday – “I got 99 problems but a disk ain’t one”
G’day,
Apparently “Meme Monday” was started by Thomas Larock (Blog | Twitter) , as a way for getting people writing. I haven’t been...
2011-05-02
743 reads
Meme Monday: I Got 99 SQL Problems And the Disk Ain’t One
From Tom LaRock’s latest idea…
For a change I’m not going to mention performance (well, not more than once anyway)...
2011-05-02
1,319 reads
PASS SQLRally is Next Week!
It’s hard to believe, but after months of planning and hard work, PASS SQLRally is next week! I admit that, as one of the planners, I may be biased,...
2011-05-02
10 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers