Here's a list of a few more I'd add:

Choose your RAID carefully. RAID-5 is okay for OLAP, but RAID-1/10/01 is better for OLTP.

Do backups to a different drive than...

Another one that's oft forgotten is splitting tempdb into multiple files if you have multiple CPUs and can split it across multiple drives.

On the unrestricted growth thing, I'd say it's more important to predict the size the database should be in 6 month (or some other reasonably long interval), and set it...

@@version = Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1...

It looks to me like someone was trying to build some sort of procedural many-to-many system, without understanding how to do that the right way in a relational database.

With some...

If you actually need it to add up to exactly 100%, you need to have something go through, add it up, find the error amount, spread that over as many...

I don't, but I also haven't looked for one. Hasn't come up for me.

You could go with what you've got, and use the input parameter as the group name each time. The recursive CTE that I had in my first post, with...

I just tried this in my ProofOfConcept database, and it seemed to work as expected:

create table #T (

Org int,

[User] int,

Last_Name nvarchar(1000))

insert into #T

select 463, 476, N'????????????' union all

select 1, 1,...

This article has data on splitting into multiple columns:

http://www.sqlservercentral.com/articles/T-SQL/63003/

Check the Services section of the server's management consol. Make sure the service is being started by a valid account, and is running.

Have you checked that the regular login you're using exists at both the server and database level in the 2k5 server?

I must be missing something. All your code does is create some variables and assign some basic values to them. I tried it in Management Studio and it...

I don't believe there is an option like that. Either create one file that you name, or multiple files that are named based on what they are.

The reason to avoid the Like operator in that is because it is immensely slower than splitting the list (use a Numbers table for that), and joining to that. ...