GilaMonster (12/3/2010)

---

I don't recall having written an article on Trace. Grant wrote one that was published earlier this week and should still be on the front page. Make sure you've...

If you do a search of existing threads on this topic, you'll find that 99% of the time you should not be shrinking files because it hurts performance by fragmenting,...

30 hours seems a very long time for a backup !! Using BackupExec to tape, our 1 Tb database takes 6 hours. My 180 Gig backup takes...

Lowell (11/30/2010)

---

sweet ! i was hoping to fiddle with that old thing after...

Lowell, I tweaked that a bit for my situation, and it worked quite nicely ... Thanks !

We had performance issues after upgrading to 2005. Some of them were resolved after closely looking at the joins and finding we needed to modify or add the CONVERT functions...

I use this to script all the objects to files. As I recall, the .exe is not in 2005, so I copied it, and maybe a couple others from my...

A bit impatient ? (You could have done it manually by now)

Create a Windows secirity group through AD, then put the user(s) in that group, then give that group...

GilaMonster (11/21/2010)

---

To anyone still reading (and not running screaming), do not ever do that. The log is not an optional piece of the database, SQL cannot always recreate it if...

When I have a job that I want disabled for...

Here's a query that you can run to check on when each database was last backed up and the recovery model.

I used this when I started at a new job...

Can it be varchar instead of char ?

Look at how much space the table is currently using to get an idea of the impact.

Are the database and log files on...

Replication is a good option. Another option is use a linked server

truncate table ServerB.DatabaseB..TableB

insert into ServerB.DatabaseB..TableB

select * from DatabaseA..tableA

Why is SSIS not recommended at your company ?

One fallback position could be to take backups when they are still on the 2000 server, just before restoring to 2005. I assume you will do this anyway. In an...

It's possible the indexes you want to delete are hard-coded as index hints. I use something like this to look for character strings in stored procedures

exec sp_MSforeachdb_db 'use [?] select...