GilaMonster (10/3/2014)

---

SQL logs an entry in suspect pages when it finds a corrupt page. In your case, that happened on the 11th of last month and SQL only found an...

This seems to be a popular subject, and you're really knowledgeable about it, it seems....

Added a variable to limit time.

SET NOCOUNT ON

SET XACT_ABORT ON

CREATE TABLE #SizeLoop

(

id INT IDENTITY(1, 1)

...

Let's just put it all on flash!

R1 and R10 (mirror with stripe) have the same 2x write penalty. In my experience they're the most popular configurations for TempDB and .ldf LUNs.

R5 (stripe with parity) has a...

I picked up this technique from a Kalen Delaney article that I can't seem to find now. Might not help if it was not a recent transaction.

DECLARE @a NVARCHAR(MAX) =...

The problem I run into with .ini files is that I can't figure out how to pass a service account password to them. SQL Spade gets good reviews[/url], though it...

The only product I can recommend against is CommVault. It is labrynthian, sensitive, expensive, and unforgiving. Sort of like divorce, except there's no freedom at the end of the tunnel;...

How big is your TempDB LUN? Is it separate from your other databases/files? If it is (and it should be), why not just fill it out with these TempDB files...

My company uses EMC 15k VMAX SAN with tiering as well. I run into this frequently, where the SQL DMVs are reporting way out of line figures vs. what the...

Noticed this today:

http://code.iamcal.com/php/rfc822/full_regexp.txt

If you let your vision go blurry and scroll up and down the page it kind of looks like relaxing ASCII waves on on a happy little ASCII...

I do monthly VLF maintenance, so I'm aware of possible issues. These databases belong to a 3rd party vendor and are just kind of nightmares in general. If I could...

Yeah, I'm re-working the VLFs now. Doesn't help me with the current restore in process. Curse these SATA drives.

Grant Fritchey (2/11/2014)

---

No, there's no formatting of any kind built into SQL Server Management Studio. It does have syntax coloring, but that's it. Any formatting has to be done through...

Ah. Because this being NULL in the first row would give you a nine row chunk.

WHERE CompletedLastMinute is not null;

Thanks, makes sense