To the extent it doesn't require additional money, yes. The existing DBA only had time to keep up with things but was able to make sure reindexing was done...

It is possible to back up over the network. I know I've ran into issues doing it but I don't remember what they were and we have a lot...

That article says that it's not rolled back too:

So what's this all mean? In short, page splits are...

It won't make much of a difference which server you back up to and restore from.

It's going to depend on the network and how much space is available. If your network is solid and there's enough space on both server A and server B...

I did some more poking but haven't been able to find an explanation yet. The following post mentions the behavior, and duplicates it slightly differently, but doesn't address why...

According to BOL datetime uses 8 bytes and smalldatetime uses 4 bytes.

Space....

Eric M Russell (6/22/2011)

---

For example, building codes specify how plumbing should be installed and what type of pipe materials are allowed. Thank you. The FDA bans certain medical procedures that...

OCTom (6/22/2011)

---

A simple monetray penalty paid to each customer whose data was breached may help. Say, $100,000 per account? $1,000,000? Money talks and it may take large penalties to make...

Good question. If there was a time with 29.999 seconds as the last bit it would have gotten me.

Did you notice that the explicit transaction immediately gets rolled back? I cleared some irrelevant stuff out of the code and pulled some extra info into the temp table:

CREATE...

Cloud providers probably don't want to hire the best of the best for all positions. In architecture positions you do want the best. In monitoring positions, if you...

jswong05 (6/13/2011)

---

2) Who is responsible for the server/service in cloud? Where you have custom applications and databases in cloud, when there is a failure, is this the provider to resolve...

I see a lot of potential for the cloud but certainly have concerns. Being in the healthcare industry the fact that under HIPPA guidelines we can't store data in...