Hi. I recently had to rebuild the master db on a SQL Server 2000 Enterprise Edition 64-bit. This was new too me and as I found out you no longer use...
Hi. I am testing the exact same queries in identical databases on two different servers. One with old hardware and one with new. The old one is...
I have a strange issue on a SQL 2000 SP3a running on Windows 2003 SP1 with 2 GB RAM. Lets call it Server A. I have two IIS/ASP websites running...
I'm doing some test on applying SP4 on MSDE. I've installed a clean Win 2003 Server Standard Edition. On that I installed a default instance of MSDE...
Before I go set up some test machines I thought I would ask a few questions here. We're going to replicate data over the internet (transactional...
Title: 11/30/2004 Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster Begin:...
Many high quality scripts can be found at Bill Wunder's site: http://home.comcast.net/~b.wunder/
<Begin rant> Ok, honestly how many servers do you have running that do not have issues with parallelism. To me it seems like we have issues with 7...
Funny (or sad) code... http://thedailywtf.com
During my years working with SQL Server I have done very little work with Analysis Services. Now we soon have it running in a cluster and need to...
Just wanted to say that I really liked the manual log shipping article by Edwar Bishara in the last newsletter email (26th July). Good layout,...
I think it would be a good idea (if possible) not to archive the posts in the following forums: Contribute Your SQL Server Scripts Contribute Your...
Found this nice script lying around. Estimate the size of your tables based on all the details described in BOL on how to do it. Written for SQL 7...
Ok, this is the 5th SQL 2000 cluster in a row I install where I can't change the MSDTC log size. Even if I go into Administrative Tools -> Component...
Just thought I should post the following article: HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003...
Hi. I got a new server to install (been a while since we had new hardware here...). Compaq DL380 G3. Smart Array 5i Controller with 48 MB battery...
Some Dilbert's to lighten up the day: http://www.dilbert.com/comics/dilbert/archive/images/dilbert2003166341120.gif...
Would it be possible to add some kind of comment and/or rating features to the articles published? Like creating an article comment thread in the...
I have problems with CPU spikes on a server. http://sql.nova.nu/images/cpu.jpg 2 databases, both in simple recovery mode. Intense search queries...
If you have 4 disks available (on a controller with 2 channels) and you know you will host databases that are in Simple Recovey mode only on the...
Separate names with a comma.
