One thought to share here, I usually advocate naming stored procedures, functions, etc. by object then action as follows:

usp_Customer_Insert

usp_Customer_Delete

usp_Customer_Update

usp_Customer_Select

usp_Customer_OrderList

fn_Customer_OrderList

etc.

The prefix (other than sp_) is pretty much up for grabs but...

I'll echo a couple of the other responses here with a bit of a twist. Many years ago in boot camp for the U.S. Marines I was taught that...

Steve -

No worries, I just posted this request last night.

I'm open to anything that makes sense.

Joe

If you have to monitor the files/status of a particular disk volumn Tripwire is definitely the way to go.

There are a few ways to skin this cat.

If the client has SQL Server Tools installed, add the alias on the client.

Add an entry for the old host/server name with...

If the words "Integrated Security" appear in your connection string you've got the wrong connection string for your setup.

Try something along this line:

connectionString="Data Source=dbservername;Initial Catalog=databasename;UID=sqlloginname;PWD=sqlpassword"

Write it down, put it in a labeled signed dated envelope (2 sigs required) and put it in the safe. That way when you get hit by a truck...

I saw a presentation by the developer of this tool at the Denver SQL Server Users group a couple of weeks ago and it will show you exactly which objects...

You've got to watch those hints and use them sparingly, in SQL 2005 there are better alternatives than NOLOCK in T-SQL. Have you looked into snapshots?

One gotcha to avoid,...

Correct me if I'm wrong but it sounds like the

are software folks - if I was looking for SAN configuration advice I'd be talking straight...

If your experience with VMWare was a few years ago, things have changed pretty dramatically with the introduction of the hypervisor in the current versions of VMWare (MS will be...

I think Brandie has it nailed - use a seperate database for loading/staging your ETL operations.

I agree with many of the issues raised here and thought I'd throw in a couple of thoughts having telecommuted both full time & part time in a couple of...

Hmm... select into is typically pretty darn fast... how does it compare to create table/insert, anybody have time to test with some real data volume?

Joe

1st thank Paul for the update on his particulars, alway useful to hear back from the original poster.

It looks like it's safe to say that in the end there are...