If there are many selects with dirty reads then they dont hold a lock but they do hold a latch (scaled down lock). This can cause the rare and very...

Thanks for that and link to the artical. The memory mapping does seem to be an issue but still sounds ideal for TempDB. Hmm, I wonder.......

Sorry about my post seeming...

Thanks for you comments.

So like any driver they need a small amount of CPU/ram to work. Surely thats going to be measured in a couple of MB and not 100's...

To see if it a truncate table rather than a delete check to see if there is an identity column. If there is, insert a row and if it starts...

I thought that FusionIO cards sat in the PCI slots on the motherboard and were not part of the...

As far as I'm aware (and do please correct me if I'm wrong) SQL server doesnt know anything about the disk layout or the file layout and their respective physical...

If the drives are logical and on the same physical set of disk then makes no real difference.

Ouch!!!!!

You may have a serious issue with this.

Changing the password will in some instances not affect anything because it is the security token being passed around the system and...

You have a good chance of making everything slower, specially if the data is identical in all the 6 copies. You will also be requiring the hardware to do more....

Ouch! Live and Learn

Thanks for that Gail

If you dont mind gaps then

declare @start_date datetime = '2011-08-22 00:00:00'

select DATEADD( ss , Offset , @start_date)

, COUNT(*)

from...

wendy elizabeth (8/25/2011)

---

I have the following sql server data access questions:

1. I would like users to sign on to sql server using group roles by using sql auauthenticationHowever, I would...

My uderstanding is that the only decryptors of stored procedures was based on sql7 and before. When sprocs are encrypted within SQL 2005 & 2008 there is no way of...

Having a quick look at the other comments this does seem to be the best option.....

John Mitchell-245523 (8/12/2011)

---

I'm sure if you really thought about it, you'd be able to answer...

It is worth while showing the vendor why SA rights are plain dangerous. ie add a domain user to the admin group, stop a service, send a rogue email etc...

I...