Use TOP instead of SET ROWCOUNT
Both TOP and SET ROWCOUNT are both valid methods of limiting the result sets from a query. They are however...
2013-10-10 (first published: 2013-10-07)
3,984 reads
Wrapping Up The 2013 PASS Election-Part 3
Today I’ll continue with my notes and thoughts on the 2013 election process and a good place to start is...
2013-10-06
721 reads
Wrapping Up The PASS 2013 Election–Part 2
I watched the election this year with interest and the advantage of having seen PASS elections from a number of different...
2013-10-05
682 reads
One-stop Shopping for Backups
First, let me say that yes, I’m aware of Ola Hallengren’s excellent set of maintenance scripts, including those for doing...
2013-10-05
388 reads
The SQL in the City Tour is Almost Here
Five days. That’s how long I’m in Denver after my last trip before I head back to the airport for...
2013-10-04
724 reads
Reblog: September 27 to October 3
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-04
937 reads
Speaker of the Month, October 2013
This month I saw several good speakers talking on a variety of topics. Making this choice was hard. I’m really...
2013-10-09 (first published: 2013-10-04)
1,147 reads
SQL Server Analysis Services Activity Viewer 2012 1.0.0.1 Beta Released
(Worth noting that there is a more recent version available here!)
Hi all, yesterday morning I created a project based on an old blog post Upgrade Analysis Services Activity Viewer...
2013-10-04
19 reads
DevConnections Slides and Code
I had a great time at DevConnections this week, It was a fairly quick trip for me, with lots of...
2013-10-03
596 reads
Networking at the PASS Summit: First timers
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking...
2013-10-03
671 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