Unless you're operating in a development environment, I wouldn't suggest even using STATISTICS IO. I've actually noticed it negatively impacting queries. Instead I capture events using extended events (you can...

When all inserts, updates and deletes return an error and the data being transmitted gets lost, most people consider that pretty dire.

Ummmmm....

No.

NoSQL used to mean, no gol darned Ess Que Ell because we hate the DBAs and we hate the language and we just want to go FAST FAST FAST and...

You absolutely can. Create a backup device and then backup to it. It can be a tape. But, understand, going directly to tape is much slower which could have all...

You should set up domain accounts. That's the preferred mechanism of managing SQL Server anyway.

Deadlocks are always about performance. The faster an update occurs, the less likelihood of deadlocks. So, first things first, make sure that your updates are performing well. Are they doing...

it could be due to index fragmentation from updates or inserts within the cluster. Moving the data all at once leads to less fragmentation, which would explain the differences in...

It is possible to set up an Availability Group with 2008R2, but there are some hotfixes that you'll have to download. I don't have the documentation at hand, but you...

Thanks for the input guys. I guess I'll make this ogr2ogr work. It's kludgy in the extreme, but seems functional.

dan-572483 (5/4/2015)

---

In the scenario you describe, if you shrink your database after deletes it will only grow again during inserts. The time it takes to do the shrink adds...

And second. Right there with you.

Sean Lange (5/4/2015)

---

Lynn Pettis (5/4/2015)

---

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help...

Jack Corbett (5/4/2015)

---

And for back to back posts to the thread. I really can't stand it when an OP says something like:

Please help me fix this poorly...

If you have MSDN access, the download page is here[/url].

MotivateMan1394 (5/3/2015)

---

Hi again

I have 2 Functions in my Query. (then 2 columns in my query's output)

Function 1 : calculate a value on check a state field. (get values from...