There seems to be quite a flurry of talk these days about certification. There is evidence of it in the forums and editorials at SSC, as well as in several personal blogs of various SQL […]
Tag: SQL
Security Audit
This article demonstrates a script that will generate a nice html report of your database security suitable for the auditors.
Worst Thing to Do to your DBA
Recently Andy Warren Blogged about things that could drive your DBA mad. There was a lot of feedback on SQLServerCentral about various things that could be done to drive the DBA nuts. Well, I have […]
Why All The Fuzz?
I really must thank Steve for his editorial on FizzBuzz. It seemed like a really good topic to do some testing and comparison. Then the comments started rolling in on the topic. This provided more […]
I’m givin’ ‘er all she’s got!
Or am I? As I proceed down the path on a consolidation project, I have taken time to pause and ponder the approach. One driving goal is to shrink our footprint. Another goal is to […]
In Vs. Inner Join
This is tightly related to another of my forays into tuning some slowly/poorly performing processes.
Log is Filling Up
Paul Randal transaction script.
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
Indexes Out the Window II
In Part I, I discussed some of the peculiarities and troubleshooting done in relation to a peculiar execution plan. In this post, I will discuss some of what I did to further tune the query. […]
Indexes Out the Window
I ran into a peculiarly puzzling situation with a query I have been tuning of late. The query runs some aggregations and performs a range scan based on a date value passed to the query. […]