Hi Kathleen,

I think your manager was referring to synonyms, but I don't believe these can be used for database names. I think they're only used for objects within a database....

I'm running SQL Server 2005 SP2 on serveral Windows 2003 servers with SP2 installed, and I haven't had any issues with it so far. I'm not running the R2 version...

SQL Server will write to the transaction log sequentially so it writes to only 1 log file at a time.

Microsoft recommends that you have 1 drive per CPU core...

Hello all,

I recently asked the question on the SQL Server Forum about the difference between the build numbers. Build numbers in the 30xx range are for GDR patches while build...

Brian,

One more question. Say you install SQL Server 2005 Standard Edition on a quad proc dual-core server (8 total procs). Will SQL Server use all 8 in this case or...

Brian,

Thanks for the information-packed article! I have one question about the memory though. Now that Standard Edition supports unlimited RAM, do you have to use the AWE option to tell...

I unfortunately don't have that luxury since our report server will be used during all hours of the day. I've decided just to use transactional replication instead. I've used it...

Ray, thanks for the info. I wonder why BOL says that log shipping provides a way to offload query processing to a read-only database? I guess they assume you would...

David,

Thanks for the URL! That will save on the typing!

Jason

Chris,

Definitely an interesting read. I'll look forward to your future articles on the CLR. In the meantime, I was just curious where you came up with that expression to validate...

Well, after some snooping around on Microsoft's Support site, I found what I was looking for. In case you are interested, here's the link explaining the correct procedures for moving...

Carl,

Did someone clear the application log while SQL Server was running? I have done that before and received similar error messages in the Event Viewer.

Jason

Well, okay, for the first time ever one of these silly questions has gone my way!

I'm one of the (at this time)...

quote:

---

I am amazed with how many people here have associated a clustered index with a primary key...

---

November 21, 2003 at 10:12 am