GilaMonster (9/9/2010)

---

No one mentioned defragging the drive. Log fragmentation is internal in the log file - lots and lots of very small VLFs within the transaction log. A very large...

If the DB was on a USB Flash drive (which sounds like a dodgy idea to me....) then you don't need to defragment it. Fragmentation is an issue for...

Its management studio that ran out of memory, not SQL server. After all, you ARE asking it to display 82 _million_ rows. Thats a lot of rows. ...

kevlray (1/12/2009)

---

I got the blue screen of death on a local machine running Win XP SP2, I had skipped SP2. I was able to install SP2 and it...

If you are designing a DB that will have 5 or even 2.5 million concurrent users, you NEED to hire some serious consultants that charge a lot of money and...

I used to work somewhere where SQL2k would occasionally do this...

No open transactions, truncate log & shrinkdb would do nothing. In the end all we could do was keep...

I've had nothing but trouble with parallel queries. At a past job when we moved to SQL2k sp4 suddenly it was much more agressive about parallelising our queries, and...

I used to look after a moderately busy server (50-100 trans/sec most of the day) that had issues after moving to SP4. We did some experiments with MAXDOP, and...

Quite a while back I had to write some trivial .Net code to pull some data out of oracle. It turned out to be quite a mission, I had...

Hi Hugo,

I guess it all depends on the purpose of your blog. If you are trying to generate money from adwords on your blog then you won't be happy...

Well Steve I'm going to put my neck out a bit here and say sites like SoftLogger are not *all* bad. I checked out that site, they say on...

Ahh... now you mention it, I'm not sure I have actually tried this with sql2005/SSMS. At my last job I used this method... but it was sql2k.

So sorry Ian,...

Hi Ian,

If you are trying to connect to SQL server on your virtual machine which isn't on the domain then you should connect using an account from the virtual machine,...

You can map a drive to the virtual pc using one of the accounts on the vitual pc and specify the machine name instead of the domain name -for example,...

If you connect to the server or map a drive with the credentials you want to use first then those are the credentials that will be used for windows authentication...