Go with the 9i client rather than the 8i one, it's far more stable and reliable.

There were registry changes needed to ever get the 8i client to work properly, check...

Fact is that Brain Dump sites might help you get a cert, but they won't help you get a job. You won't actually learn anything from them.

So this is effectively a useless partition, correct?

The data would have been spread throughout the filegroup anyway, this just added complexity. Realistically I should have four different filegroups and push...

I do not believe that the answer is correct.

The question was the fastest way to delete every row in a table.

Delete and truncate are not the same thing.

Should the question...

What is this "degree" think of which you speak?

Never had a day of college, kinda sucks, I think the drinking would have been good for me.

ALZDBA (10/18/2007)

---

We have a 16Gb ram x64 server with a 24Gb pagefile. And we will change that to 4Gb pagefile asap because of this.

During a systems test, the sqlserver instance...

Ping is more than likely blocked through the firewall, which makes complete sense.

Make sure that SQL is listening on 1433 if that's the port that your network guys have opened.

Bapi run

SELECT NAME, FILEID FROM SYSFILES

to get the fileID of the log file, then use that in the DBCC SHRINKFILE script

XPe was what all of my items were based upon.

We are in the middle of a migration to 4.0 and will be looking at reporting functions within that which may...

The datamarts are great, but the data is not realtime, we've actually had to create some funky scenarios using DSQUERY in order to get real time information imported into SQL...

I only have a locally maintained db for the Citrix portion, and run it on my distro cluster. It takes minimal resources and so is an ideal candidate for something...

Presentation Server 4.0 really takes this to the next level with the updated licensing model.

Additionally when you bring blades into the equation and remote deployment software (Altiris for example) which...

If it's a 2650 then you are probably looking at the service warranty expiring sometime in the next 12 months.

Once you reach this point you should purchase some new hardware....

Below is the correct code, looks like a typo in the article, somewhat embarassing, but no more than MS crashing SQL 2k5 and having to reboot in the NY launch...

You only install SQL on the one node. It will apply the changes to all nodes in the cluster.

The same is true of the service packs (older patches are different...