No Shrink-y Tempdb
I caught the end of a Twitter conversation the other day between Wes Brown (Blog | @WesBrownSQL), Paul Randal (blog | @PaulRandal),...
2011-05-26
1,609 reads
Blog Posts
Random Ordering of Results using NEWID
A discussion of how NEWID can be used to help randomize the results returned from a SQL query.
A scenario I...
2011-05-26
1,148 reads
SQL Server, Storage and You Part 2!
I saw 500 faces an rocked them all!
To those who attended my webinar today THANK YOU! If you didn’t…. There...
2011-05-26
652 reads
SQL University Troubleshooting Week: Keeping an Open Mind
Office politics during a major event can be dangerous. It pays to be seen as contributing to solving the problem...
2011-05-26
761 reads
SQLRally 2011 Women in Technology Luncheon
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our...
2011-05-26
1,023 reads
SSRS Error: Unable to connect to remote server error
One fine day when I tried to connect to one of my staging report server I got the
“Unable to connect...
2011-05-26
5,344 reads
Survival Mode & Dodging Burn Out
One of the benefits of experience is that you can see problems coming, that doesn’t mean you have enough experience...
2011-05-26
736 reads
ABL: Always Be Learning
If you have been in the IT field for any length of time, I’m sure you have heard the phrase...
2011-05-25
1,533 reads
devLINK Technical Conference to be Held in Chattanooga, TN, August 17-19
This year’s devLINK Technical Conference will be held at the Chattanooga Convention Center, Chattanooga, TN this upcoming August 17-19, 2011....
2011-05-25
642 reads
Efficiency of Subqueries and OR conditions in SQL
A discussion of how joins significantly outperform subqueries and how this is more evident when OR conditions are involved.
SQL queries...
2011-05-25
955 reads
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
A Quick Second Opinion
Comments posted to this topic are about the item A Quick Second Opinion
Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload
Comments posted to this topic are about the item Five Intelligent Query Processing Features...
Checking the Error Log I
Comments posted to this topic are about the item Checking the Error Log I
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers