Tag: sql server

Community

Statistically Speaking

(Joshua Jones) As DBAs, we quite often find the need to take a look at new databases (or old databases we haven’t seen in awhile), and figure out what shape the indexes are in. For those of us who do consulting work, you probably find this work is particularly familiar territory. Fortunately, when S

Community

Getting Dynamic in SSIS Queries

(Eric Johnson) When you start working with SQL Server and SSIS, it isn’t long before you find yourself wishing you could change bits of SQL queries dynamically. Most commonly, I see people that want to change the date portion of a query so that you can limit your query to the last 30 days, for examp

Community

Try Catching These Errors

(Eric Johnson) Transact-SQL is a great language for data manipulation, but it has its weaknesses. Unlike real programming languages, T-SQL is confined to procedural code. Sure, you can build modules by using stored procedures and functions, but for the most part, all of the work will be procedural.