Could be just a timing issue with the log backups. It could be a single large transaction that had to wait for the buffers to clear in order to keep...

Yes, it's going to compile based on the parameters you first pass in and whatever is in the temporary tables when the procedure gets compiled.

However, if anything modifies the data...

DuncEduardo (9/1/2015)

---

Hi Grant,

Many thanks for replying. Yes, I had noticed Mike on LinkedIn already but was unable to mail with the account level I currently have; I'd have to upgrade.

Basically,...

He was just presenting at SQL Saturday Oklahoma City this last weekend. We're acquainted, but I don't have a direct contact for him. Here's his LinkedIn page. You should be...

Whisper9999 (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

That's one of those questions where you have to ask, how do you define your job?

If, as a DBA, you see your job around setting up servers,...

ZZartin (8/31/2015)

---

Just out of curiosity, it seems like a lot of people are putting a lot of faith in foreign key constraints I'm wondering why? Compared to a primary...

That's one of those questions where you have to ask, how do you define your job?

If, as a DBA, you see your job around setting up servers, handling security, and...

debby_browne (8/31/2015)

---

This is nuts. Am I the only one who read to the end to notice the footnote by the author ("Low Teck Loy")

* if you hadn’t caught on, just...

GilaMonster (8/31/2015)

---

A question for those who have upgraded to Windows 10 and have SQL and Visual Studio installed:

What the total size of the Windows and 2 Program Files directories?

I'm trying...

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From the Microsoft forums, quite a few others are as well. Seems...

briankwartler (8/31/2015)

---

Grant, Jeff, and Wayne:

Which ORMs do you have experience with? I would think that the designers of these ORMs would very much like to hear of your experiences with...

In addition to changing the Maxdop, make darned sure you change the cost threshold for parallelism. The default of 5 is insanely low.

I have seen this occur. It's usually in queries that were problematic, but barely adequate, in the older version of SQL Server. The newer optimizer in 2012 just isn't always...

Without the code and the deadlock graphs all I can do is make some vague suggestions.

Make sure that the queries you're writing access the tables in question in the same...

My understanding (frequently wrong) is that it's both explicit and implicit transactions whether called by the user or within the server itself. I generally don't use it since it's something...