Microsoft SQL Server Administration

Hello Everybody I have the question about the SQL Server Performance and design considerations. I am developing code that is going to deal with a lot of records (specific detail in the attachment). I am writing code right now that is working fine ...

I need to change the password off the SQL Server service on about 70 servers, and I'm trying to automate this process.  After changing the Service account password SQL books online states that I should change it for the service ...

I recently installed the SA versions of several MELL 2.5 collections. I can access the start page and the training with no issues; everything appears to work perfectly. The problem is, I also installed the SQL database and Reporting to monitor users and usage, but there appears to be nothing being ...

SQL Server 2000, sp3a, running on Windows 2003 server sp1: I have 2 jobs based on maintenance plans which have been running fine for over two years. They are both maintenance for a database: one updates statistics, and the other rebuilds indexes. ...

Hi all, I have a database on SQL Server 2000, and I back it up from time to time. At one point, I moved the location of the backup file. Since then, every time I want to do a backup, I get the old location; ...

I recently purchased a Universal Subscription.  Trying to avoid waiting 2 weeks for the discs to arrive I downloaded SQL Server and install it on a server running Windows Server 2003.  It wouldn't allow it because I hadn't ...