No problem, Jeff.

Note that it's not as much about guessing the next value as it is about some output patterns being more likely than others. Perhaps every third bit...

Read Gail Shaw's Managing Transactions logs[/url].

Check out Ola Hallengren's[/url] maintenance procedures.

Are they? Right now? How do you know?

Run a quick...

william.sisson (2/19/2013)

---

For example for hotel room bookings you need to ensure that the same room cannot be booked for overlapping time periods. You need a constraint to do this that...

Jeff Moden (2/18/2013)

---

Seems to me like going to a CLR for a simple, relatively flat random number is overkill. Not sure what the performance of the CLR will be,...

Interesting!

First, Jeff is right - trying to get a 4 byte value out of 1 byte of randomness is... flawed.

Second, I'd expand that - I would really suggest adding an...

lptech (2/7/2013)

---

Nadrek (1/18/2013)

---

That's a very disturbing question. I'd be torn between two responses:

I honor the contractual agreement with the social media sites I use not to divulge those credentials,...

First, you're doing a great job choosing a well known and respected set of scripts, and actually taking the time to plan things out.

So, you have a maintenance window of...

As an alternate, could you have the user use one or more batch files (more if you need to account for the 'couple bits of information') to load the data...

kpwimberger (1/28/2013)

---

Thanks e4d4:

What confuses me is - how likely is it that someone can get all the way into the server to create or steal a backup and NOT have...

Steve Jones - SSC Editor (1/24/2013)

---

rharderwijk (1/24/2013)

---

I partially agree.

Yes, developers should be develop software that can scale up and down as needed, but they still have to worry about the...

Very interesting - though I would have to note that this has the very common limitation that it won't function when trying to restore specific databases to Server B after...

Steve Jones - SSC Editor (1/22/2013)

---

Tara-1044200 (1/22/2013)

---

but i am planning to put them on a single SSD drive which i asusme would be 8 files each of 100gb. so i...

If you're going to capture per-file data in the first place, I'd highly recommend also capturing sys.dm_io_virtual_file_stats() data - then you can see which files/databases/disks are most "used" by a...

Jim P. (1/21/2013)

---

I've gotten in the habit with my manager of occasionally dropping this on her desk:

You have a choice:

Good

Fast

...