Adi Cohn-120898 (9/12/2011)

---

The maximum number of connections is 32,767 (you can check it out at http://msdn.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms143432(v=SQL.90).aspx). Of course this is a theoretical issue. I’ve never...

The MMORPG EVE-Online uses SQL Server.

Actually, 1 TB size flash drives are not quite a few years away. Texas memory systems currently sell a product called RamSan 500, that is up to 2 TB of...

This lists database objects are in what filegroup:

select af.name, o.name, i.name, i.dpages, i.reserved, i.used, i.rowcnt, i.rows, i.rowmodctr, i.OrigFillFactor, o.crdate, o.refdate

from sysindexes i

inner join sysobjects...

I've noticed that my indexes fragment alot faster in SQL Server 2005. Couldn't this just be caused by very fragmented indexes?

MCDBA is not for SQL Server 2005. Look into MCTS: SQL Server 2005 to get a DBA certification for SQL Server 2005.

I have a 32-bit development enviroment and a 64-bit test and production ones. I can restore backups from the 32-bit developement enviroments on the 64-bit platforms. I haven't tried it...

I'm not sure but you might be able to use DDL triggers in SQL Server 2005... recommend that you read up about them. If you can't use 'em to prevent...

You need to edit where it says "DBNAME" to the name of the database you want to see the data for. Also if you collation is set to case sensitivity...

I'm starting to evaluate Litespeed for my main production db server.

It has one big production database, with fullbackups around 280gb.

I guess I'll find out how Litespeed works as soon as...