#169 in Denver was great this past weekend. I might be done with SQL Sat for 2012. DC is tempting and I'll try to decide soon, but timing doesn't work...

I hate wide receivers.

Jeff Moden (9/23/2012)

By the same token, there are also many myths that need...

If you central server is down, where is the data on backups? If your package has a bug, or can't connect to an instance, what happens to the data?

GilaMonster (9/21/2012)

Stefan Krzywicki (9/21/2012)

Wow, I frequently disagree...

First, do your best.

Second, you'll make mistakes and your solution won't be perfect. Get over that. Work the best you can and fix things as you find issues, but don't...

First, I'd make sure you are copying those full backups around to other places. If you lose one of them, you don't want to be going back a month or...

I like your second idea, personally. If you need all phones, use a UNION.

One side note: please allow people to change/alter the phone types. I hate on the iPhone that...

Sean has a good solution, but I'm wondering, do you need to search on end date, and if that's not there, then search on the number?

Objects in tempdb should clear when the connections drop or they are dropped by the connection that created them. There are some objects created by the system to satisfy queries,...

You are using "same" a few times and it's not clear what you are referring to.

If there is a conflict of resources between the jobs, it could be blocking. It...

sp_help_revlogin is what I'd recommend.

Saw another note that it's .NET Framework 2.0, so where you can run that you can probably make Powershell work.

It should work with 2005.

From here: http://technet.microsoft.com/en-US/library/ee177003.aspx

I believe XP/Win2K3 are the earliest you can use.

With SQL Server, I'd guess SQL Server 2005, but it might be 2008.

Have you created a full text index on the table? I don't believe you can do this on a temporary table, so it might be on a permanent one.

If...