Use Compression to Combine Data Quality and Performance
We’ve been using the wrong data types for all the wrong reasons. DBAs, developers, data architects, etc. have all been...
2015-12-21
977 reads
Simple SQL Server
Indexing Strategy
What do I care about when I’m playing with indexes? That’s easy. I want as few indexes as possible efficiently referenced...
2015-12-28 (first published: 2015-12-16)
3,520 reads
Picking a Clustered Index
A Clustered Index is not another term for Primary Key, and more thought should be put into the key columns...
2015-12-16 (first published: 2015-12-14)
2,486 reads
Data Compression
Data compression is often misunderstood to cost CPU in exchange for smaller size on disk. Somewhat true, but that simple...
2015-12-08
1,119 reads
Querying the Plan Cache
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,003 reads
SQL Server Error Log Reader
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
678 reads
Give More Feedback
I write on my blog and get a couple comments at best. I talk at conferences and a large part of...
2015-11-06 (first published: 2015-11-02)
641 reads
Extended Events Intro
Extended Events is supposed to be taking over for most of Profiler and server-side tracing functionality, but there were people...
2015-10-26
1,398 reads
Technical Interviews – How to Thrive
There’s a trick to technical interviews. Every question is looking for integrity first, and intelligence and energy second. This is...
2014-05-23 (first published: 2014-05-13)
2,764 reads
Optional Parameters Causing Index Scans
Optional parameters in a stored procedure often lead to scans in the execution plan, reading through the entire table, even...
2014-04-15
722 reads
Blogs
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
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...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
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