My current shop gets a lot of data from the mainframe, using a variety of methods to load the data into SQL Server. As such, we have many table without...

Now that I have two large monitors at the office, it's a necessity rather than a luxury to use one of them for an open reference. I always have Books...

This query will give you failed job steps. Just change the date to go back as far as you need.

select sj.name, sjh.* from msdb.dbo.sysjobhistory sjh

join msdb.dbo.sysjobs sj on sj.job_id =...

Adding Windows administration skills to your skill set will definitely increase your value in a small to medium size shop, where people wear multiple hats. But you'll also need to...

This can be done with an SSIS package, as documented in the article:

Looping through multiple servers in SSIS[/url]

Ask your network people to see if they can find anything big going across at that time.

In one of my favorite Dilbert cartoons, Dogbert says to the boss: 'Before you bought my overpriced, under-performing software, you had all of the power. Now, it's the opposite'. The...

For some more advanced topics:

sqlcat.com

and

http://sqlblog.com/blogs/linchi_shea/

Try this:

http://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Very useful article. Especially for those who don't spend a lot of time dealing with SSIS, and need to debug something a couple of times a year.

While I don't have any experience in martial arts, I can definitely concur that physical fitness is a great help when dealing with a stressful work situation. A previous employer...

Can't wait for some junior programmer to come to me with this query and claim that SQL Server is 'broken' because the it returns the wrong data for the 'Name'...

Looks like we need to get introduce deduplication to the DBMS world. In the virtual world, VMWare and Hyper V only keep one copy of the same block in memory,...

American Airlines is not likely to suffer very much from said outage. They may be the best or only choice for certain destinations. People are not going to give up...

Here is a link which will allow you to find out what's using tempdb.

http://msdn.microsoft.com/en-us/library/ms176029(v=sql.105).aspx