Although not something you should be doing a lot this can come in handy:

http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

I for one, have seen Joe *bashing* all over the place and I do believe he deserve a bit of this article I...

Why do you want to built all that logic in the Job itself. You should maintain the Job function fixed and code either on a stored procedure or on a...

Like SQL Noob recommended, if they went all the trouble to delete/disable the foreign keys they may as well should use TRUNCATE TABLE instead of delete. DELETE does generates *a...

Don't you have to agregate across all types ?

If your database happens to have more than one Data/log file your query does *not* work

Also Tempdb has some other data structures...

>>I do run many SQL servers in VMs and I have not yet had a problem. <<

How much load are those servers taking ?

The main issue is *in my opinion* if you need to interact with the redundant servers. Mirroring will *not* let you, unless you create db snapshots. Replication will. On the...

Another Blunder on the "answers". Definitely wrong and not too hard to confirm that the BULK option *requires* a data file!!!

And by the way you don't *need* SSIS. You could...

If you are using SQL Server 2005. Replication monitor does that for you.

Because I don't think that query is using "any" index you can create a udf and make it that "bit" more efficient.

Cheers,

When using windos authentication You will either have to have your server enabled for account delegation through kerberos or use a linked server with account mappings. SQL Authentication is less...

True you will use it on case sensitive serches but the question is

How *not* to .. ... Mine is why would you...

Or doit at client side!

Actually if you are hard-coding the collation on your stored procedure you must be doing something *very* interesting. What is it? I have only come accross such things in MS...

You need to grant SELECT/UPDATE/DELETE permissions to the role you just created on the tables you are going to read/write and if that includes "All" then use the shortcut that...