Will this be development or production is the first question to ask. If development, then use th defaults. If production then you'll need to rethink things a bit starting with...

What does the SQL Server errorlog have to say ? If the service is not startingis should only be 5-8 lines so you post the full text. The default location...

Charles, your quote is a keeper !

Redundant power grid feeds, dual balanced UPSs, redundant generators, SAN and NAS storage, etc. and still 2 total blackouts this weekend. No matter how prepared you are you cannot expect...

Colin has offered the best advice available.

Here is a quick'n' dirty one. Data and log on separate drives that are not for the OS, page file or application executables and such.

---

--- create_xxx.sql - 08-24-2006 Rudyx

---

 use...

I concur. It's more of a load based thing as opposed to function based on the small resutls set. It was definitely a fun thing to do since the script...

I used the scripts supplied and ran 3 iterations on a number of servers. It seems that server load and hardware also have something to do with the results.

The first...

Its not the licensing of QA or client utilities its the usage of SQL Server.

• By client - one license per server you access from you workstation.
• By Seat - as many servers as...

After lunch I'll have some time and give things a whirl with 250,000 iterations on the same servers ... after all its Friday and I need to relax and have...

I used the scripts supplied and ran 3 iterations on a number of servers. It seems that server load and hardware also have something to do with the results.

 hp ml-370,...

This depends on your licensing and usage. For example (assuming your are licensing compliant) if you have a SQL Server application that User1 has on his client PC that connects to...

We have an application in Cache as well. The vendor supports it all and will not even give us access to the DB so we just maintain the hardware and...

had this problen quite frequently lately (ughh...)

First thing you need to do is download the setspn utility (link below):

http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/setspn-o.asp

Install it on your computer (or server). Next you'll need a...

A number of years back I did some benchmarking on the use of RAM DISK (back then it was called 'solid state' disk). I tried a number of configurations with...