10 minutes to an average of 45 min. That itself is quiet a variation. backups usually dont wont have that much variation in time taken if taken regularly. It might...

If I am not mistaken, I do not think it is possible to change the default for CDC. It creates the tables in a new schema "CDC". If you are...

Planning to write a book then? If so, and you...

I have a feeling that it takes the data from sys.sysprocesses based on the lastwaittype. Just a guess here.

My two cents.

Inserting Data or updating data into a 5M row table should not cause dead locks. What you might want to do is to look at the execution plan...

Brandie Tarvin (8/12/2011)

---

Hey, all. I don't know much about this subject (Other Wait statistics). Can anyone help this poster? He hasn't had any answers at all since he posted early...

This is the query I usually run to find the wait types. I got this query from Glenn. It gives me a good break down of the wait types I...

When you first checked the sys.dm_os_wait_stats, what all types did you see?

If you look at this link you will see what is part of Wait type Other.

Search for...

Congrats Lynn. Now you are going to work with what you love. That is the best part I think.

Brandie Tarvin (8/11/2011)

---

I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight...

It can be done if set up properly. Here is a link to a white paper that explains the whole set up.

You are talking about transparent data encrustation if I am not mistaken. As far as this encryption is concerned, it is transparent to the application. That means you can write...

Also you could create to roles. One for Admins and the other for the non admins. Then it makes giving granular permission easier.

Giving any user dbadmin rights is not the best way to go about it. Your schema idea is the first step forward. Give the non admin user db_datareader in the...

io_stall_read_ms is the total time the user had to wait for the reads for the file whereas number of reads is the total number of reads on that file.

stall...