SQL Server 2000 SP4 support goes on until 2013.

Since you are running over a VPN I would talk to you're network folks. If your users are at different sites it probably has to do with network bandwidth at...

Before you can say 'faster' you have to quantify what is slow.

In my opinion the difference between a programmer and a 'good programmer is the same as the difference between a DBA and a 'good' DBA. It boils down to the...

Lanny Irwan (11/20/2007)

---

The problem is we are 2 seperate body. SA is belong to infra and DBA is below to dev team. Believe it or not. It's very difficult to...

Locks only keep honest people out.

I also opted to choose FOR ATTACH.

What undocumented DBCC command are we referring to majorbloodnock

?

Blackbird was so memorable that it took me 10 minutes of googling, not live searching, to find out what it was once proposed to be. Okay, it took 10 minutes...

Such a seemingly simple question has open up an avalanche of new knowledge. A great choice for an educational question - even though I answered NTFS only !

The criteria outlined is excellent in my opinion. However I would charge vendors more for a sponsored article than for an advertisement. My reasoning is that most of us consciously...

Huh ?

here's a boot.ini file without the /3GB as an example to start with:

[boot loader]

timeout=30

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE /NoExecute=OptOut

As it was stated eariler, add it to the end...

I really dunno about " the DBA role being 'redefined' " ...

Call me a generalist in production support.

The only 'redefinition' that is taking place is in Microsoft-eese. Oracle is still...

I have been using Veritas for about the last 7 years. We always use the 'native' SQL BACKUP commands to get the files to disk. Then Veritas can pick them...

... by far the worst 'pay me later' is:

"What are my chances of getting a SQL server instance and a license in the next 30 minutes?"

This...