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 […]
Getting all values when input parameter is NULL and still get IX seek behavior!!
Recently while working on a requirement for a client we came across this scenario. It’s fairly widely used although I would not recommend it. The example is in […]
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 […]
Loading Resumes and searching them using SQL Server – Part 2/2 (PDF+ FileTable + Full Text Search)
In this post we continue after creating our file table and posting some pdf documents into it. For the previous post please click here. Apparently there is very […]
Loading Resumes and searching them using SQL Server
Recently I came across a requirement where we needed to load Resumes into SQL server and then search these documents for specific keywords. Important things to keep in […]
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 […]