Posts filed under: sql server
T-Shirt Series: What is so special about “TEMP” Tables
I have been asked what is the difference between Temp Tables, Table Variables, CTEs, and Derived tables. So I thought I would take this opportunity to do a short blog......
Troubleshooting a Full Transaction Log
Transaction logs are one of the most critical parts of a database and should be managed as such. Running out of disk space can cause application errors and even database......
Defensive Database Programming
There I was minding my own business having breakfast and reading SQL Server Central‘s editorial when I saw a link to Alex Kuznetsov’s Defensive Database Programming book. I read the book a year or so......
Linked Server Setup with Alias and SQL Server Agent support
It is not always intuitive on how to setup a linked server with an alias, or setup security for the linked server when it will be used via a SQL......