Fill factor is also important when it comes to inserts.  Using your PatientID as an example, if your application numbers patients by 10s (so 10, 20, 30...) and "child accounts"...

Time for something completely unrelated to SQL, although if anyone is in Atlanta, GA next year the weekend before Labor Day, we could always arrange to meet up for a...

Most likely, SQL is currently working on creating the actual files on disk and zeroing out the disk sectors that's using.
Depending on several things, the size of the database...

When you come down to it, the difference between a digital "bookstore" such as Amazon, Barnes & Noble, etc, and a physical book store, is nothing more than sales vs...

Ugh.  Our network today has decided it's a good day to be wonky.
Segments seem to be going up and down willy-nilly, and of course other than calling back and...

So the wife nearly had a heart attack this weekend, Saturday night...
We were in Toronto for a convention, FanExpo, and the star of the show "Arrow," Stephen Amell, was...