Hugo, Great question that realy made me think.

However part of your explination seems incomplete or missleading.

If statements and other control flow language create new batches, and that is...

Nice QotD, thank you. I think that one method for making sure pages are deallocated on record deletes was not mentioned. Don't create HEAP tables for storing record...

A spatial index is the only right one for this task.

Since Elves do not exist on this Planet/Reality it was...

Vila Restal (12/21/2012)

---

Perhaps not stats worth mentioning but it's important to have it known that not all databases are enterprisey multi-billion-row, multi-hundred-thousand-user monsters (and it's not a competition and even...

I has been at least 10 years since I have had a Production SQL server that averaged 1000tps or less during regualr business process cycles. Currently our main Database...

Hugo Kornelis (12/14/2012) -

The reason for this limitation? (Puts on speculative hat) Many settings are discouraged anyway, and I guess that MS decided not to put in extra engineering effort...

Eric M Russell (12/14/2012)

---

Database deployments have unique challenges like: altering or dropping/recreating schemas while preserving existing data, object dependencies, schema variations between development, QA, UAT, and production.

However, the most...

Good question Ron.

Clear answer and the SQL statements did not distract from the truth you where creating.

😎

O_o If only this were true. 😎

Nice easy question. Good to note this about log shipping:

"To monitor a log shipping configuration, you must add the monitor server when you enable log shipping. If you add...

So hard...

It...

L' Eomot Inversé (11/16/2012)

---

Carlo Romagnano (11/16/2012)

---

Best practise: save @@error and @@rowcount to test them later

declare @err int

,@rows int

select 1

SELECT @err = @@error, @rows = @@rowcount

if @err <> 0 or...

L' Eomot Inversé (7/25/2012)

---

vk-kirov (7/19/2012)

---

Weird logic. I don't understand how the answer could be "No", while in fact the database can be restored from any of the snapshots (although not...

Without even know what version or product of Crystal reports you are using you most likely will need to checkt he Crystal Reports web site or knowledge base on how...