Have you been working with compression? Have you inherited a database that may or may not have some tables compressed? On occasion you may want to know what the compression type being used on a […]
Tag: Scripts
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA’s automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Wait Stats resources
Today I was out and about looking for past roundups on TSQLTuesday. While doing that, I came across a post from Paul Randal (Blog | Twitter) about wait stats. The thing that strikes me about this […]
SSIS Job Execution
While working on a process to refresh the QA environment (data purge, reload data and reapply changes made over time as parts of release cycles), I ran into self-imposed requirement. I was attempting to create […]
TSQL Tuesday Indexes and Blobs
How does one find what columns were LOB columns in the database. I knew I had some past blog posts about various aspects of LOBs, but I had never broken it down to find the columns in the LOB. Even better was that I wanted to know what columns were in what index that were also a BLOB.
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred? Recently I have been working on a project to backfill a development and QA environment. These environments are essential […]
Declare Scalar Variable
Lately I have been going through a bunch of maintenance style scripts and fixing them. Along with fixing them, I have also been updating them to work more efficiently and to work in SQL 2008. […]
Space Used
At long last I am bringing the next installment in this mini-series. You can find the rest of the articles by perusing the last article I wrote on the topic. That article was a correction […]
TableSpace Update
The last post in the series on finding the sizes of your tables showed us how we could find that size via a set-based method similar to using sp_MStablespace. In that post I showed you […]
T-SQL Tuesday #006: A Blobbing We Will Go
In the DMVs for SQL 2005 and SQL 2008 there is more than one place you can find the information about the size of your LOB data? And it goes without saying that there is more than one way to find information about LOBs in your database.