The Night Before Upgrade
I originally wrote this in December 2011. It’s been one of my most popular posts, so reposting it has become...
2013-12-23
444 reads
RealSQLGuy - Helping You To Become A SQL Hero
Friday Followup For December 20, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-20
549 reads
I’m Board
No, really, I’m board. It will be officially announced today, but as of December 11th, I’m the new Director of...
2013-12-17
543 reads
Friday Followup For December 13, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-13
457 reads
Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49
A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over...
2013-12-13 (first published: 2013-12-10)
2,334 reads
Don’t Get Slimed By Bad Parameter Sniffing
Listen! Do you smell something? Are you suffering from random, unexplained slowdowns? Users complaining about queries that sometimes run fast,...
2013-12-09
1,230 reads
Friday Followup For December 6, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-12-06
353 reads
So, This Happened Today…
It started like any other Monday following a long holiday weekend. Hundreds of emails to filter through, a new client...
2013-12-03
496 reads
What’s In My Utility Belt? Issue #2
Wow, can you believe it’s been a month already since I posted the first issue of “What’s In My Utility...
2013-11-30
1,090 reads
Friday Followup For November 29, 2013
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2013-11-29
987 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers