The OP's database infrastructure certainly sounds like its an Apcalypse Now, 40GB and no indexes?

Sheesh! :w00t:

qh

Hi,

it depends on what you really are interested in doing? In simplistic terms you can ask yourself: 'Do you want to play with data or look after it?' ...

Thank you for that reply John, for a production box I think I am still too paranoid (is there any other type of DBA? :-D) about using sa, as I...

Having not worked with encrypted data/databases I would have thought that payroll or even personal information systems should have encrytped data and aren't viewable by anyone but in senior management.

But...

Hi,

thanks for the reply. I agree, this is definitely not a preferred production setup, however part of my remit is blanket installing SP3 onto our research boxes and see...

Dell Studio 1555. Owned since Feb, no problems with it so far. Runs very fast, not used it for SQL Server though. 🙂

qh

I've always found that the main issue of IT Departments (whatever sphere you work in) is that techy/geeky guys like to be just that. They're happy to be at...

Hi,

thanks for all the replies, they are very much appreciated. I am based in UK and will contact Quest UK for more info/prices.

qh

Does anyone know the cost of owning LiteSpeed? I noticed on their website they have developer edition for $200, however initially we would need LS on a Prod server...

Hi,

thanks for all your replies, some really good ideas here. I think the main issue with the dog slowness of the box is because of the Virtual server AND a...

There are quite a few other (non work intensive I've been told) Virtual servers (also they aren't using VMWare but Virtual Iron) on that server also. Found out last...

I have a VMWare SQL 2000 Standard SP4 on Windows 2003 Server SP2 test box and I am looking for ways to speed it up. It has 4 cpu's and...

Echoing Jeff Moden's post on page 5, this is by far the best SQL Server resource out there, I used to use google groups for sql research but now I...

Found this out in the end.

DTS data copy with transformations bombed out after and hour so went with BCP file out from source db - which created a 4GB .dat...

Great article, lots of good discussion as well.

As a contractor I've been hired to basically "firefight" the company's sql server problems and you do sometimes become the "Hero...