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 post on each and then summarize the differences. Today we...
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 corruption. If your transaction log is continually growing there are...
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 ago, and much of it will not come as any...
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 Agent Processing Job. Here are a few notes to make...