Category: sqlserverpedia-syndication

T-SQL for the Absentminded DBA

Post author By Jen McCown
Post date September 22, 2009
Categories In sql server, sqlserverpedia-syndication, TSQL
4 Comments on T-SQL for the Absentminded DBA

Edit: Now with working links! I was inspired a couple of days ago by Pinal Dave on SQL Server Central; he put up a TSQL Cheat Sheet that’s lovely and convenient. But my thing is, I’m a bit past the basic datatypes and aggregate functions. Okay, I’m not past ALL of them, but still… What […]

SSIS: Deploy Packages, Part 1

Post author By Jen McCown
Post date September 9, 2009
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, SSIS, Tips

This is the companion text to the video SSIS: Deploy Packages. This will be a two- or three-part series, I think. There are two ways to deploy SIS packages, and the difference becomes important when you have a lot of packages. The first way is just to individually deploy a package directly to SQL (or […]

Case Study: Rebuilding Indexes

Post author By Jen McCown
Post date August 22, 2009
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC

It's not all that uncommon to start a new job, or inherit a project, and find out that index maintenance hasn't exactly been a priority. One of the first things you want to do is look at fragmentation. This query will pull back all the indexes for My_Database ordered by the average fragmentation in percent. […]