Why worry about CXPACKET
Many people see CXPACKET at the top of their waits and start trying to fix it. I know this topic’s...
2014-03-11
1,609 reads
Simple SQL Server
Free SQL Server Training (not a sales pitch)
My company cut the training budget this year, and it’s not that uncommon for that to happen anymore. However, I’m...
2014-03-04
1,074 reads
The Approachable DBA
DBAs are the gatekeepers, but if we make it an unpleasant process then people will find a way around the...
2014-02-13
470 reads
Cleaning up the Buffer Pool to Increase PLE
Chances are you have extra information in the buffer pool for a bad query and it’s dragging down your PLE,...
2014-01-08
1,967 reads
Indexing Fundamentals
First, lets understand what the types of indexes are. If you take a reference book, you have the two types...
2013-11-20
1,673 reads
New Job Checklist
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
833 reads
Disaster Recovery and Business Continuity
Fires, SAN failures, tornados, and car accidents all came up today, yet it was a very good day at work. ...
2013-10-04 (first published: 2013-09-30)
2,152 reads
Monitoring and Baselines Presentation
Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...
2013-09-20
944 reads
Monitoring Database and Table Sizes
Trending database and table sizes helps give you an idea of what to expect, and, sometimes, points out problems and...
2013-09-11 (first published: 2013-09-10)
4,076 reads
Why Blog?
The main reason I started blogging was a community thing. I leeched from the community to get me to where...
2013-09-04
1,002 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