I was reading a blog about how to write procedural code today ( link below) and wanted to take a moment to explore another approach just to provide […]
administration / Database / MSSQL / TSQL
administration / Database / MSSQL / TSQL
Actual vs Estimated plan and the use of Time to arrive at the best plan
I came across a comment on linkedin today about the difference between the actual and estimated execution plan in SQL Server and how it is used to determine […]
administration / Database / MSSQL / TSQL
Plan reuse for conditional statements in MS SQL Server
I was asked this question the other day on linkedin and figured it might be good to write a post on it considering the confusion around the topic. […]
administration / Database / MSSQL / TSQL
The Log buffer – improving performance for write log activity
The log buffer is the space in the memory where transactions are written to before they are committed to disk. The size of the Log buffer pool is […]
administration / Database / MSSQL / TSQL
Script to Enable and use CDC in MS SQL Server
Recently at a training I was asked about CDC and while this script is old and previously published I couldn’t find it within the blog after I migrated […]
administration / Database / MSSQL / TSQL
Improving the performance of functions
Recently I had to employ functions to perform a kind of name resolution on a column within the database. The database had a user table with usr_name and […]
administration / Database / MSSQL / TSQL
What do indexes really look like?
We all have seen the traditional diagram that represents a B-Tree and I am sure we all resort to it when we try and explain how a B-Tree […]
administration / Database / MSSQL / TSQL
Using Openrowset to import data from a CSV file
If you are using a 64 bit edition of Windows then you are most likely using a 64 bit edition of Office and as a result of Access […]
A few more free e books
A few more free e-books for the SQL DBA. This from REDGATE and some of the most prolific writers and SQL Experts in the world. I am sure […]
administration / MSSQL / TSQL
What is a PK?
Recently someone posted a question on one of the popular groups on Linkedin about one of the most fundamental structures in RDBMS the PK. It was followed by […]