ChrisM@Work (3/27/2015)

---

Brandie Tarvin (3/27/2015)

---

ChrisM@Work (3/27/2015)

---

Brandie Tarvin (3/27/2015)

---

dwain.c (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional...

ChrisM@Work (3/27/2015)

---

Brandie Tarvin (3/27/2015)

---

dwain.c (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the...

ChrisM@Work (3/27/2015)

---

Brandie Tarvin (3/27/2015)

---

So here's a tale from my workplace that will change up the conversation...

I was having a Really Bad Day last week. I was trying to send an...

ScottPletcher (3/27/2015)

---

Brandie Tarvin (3/27/2015)

---

There isn't one. I don't know why they don't have one, except...

dwain.c (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Where’s a plan showing huge Estimated Operator Costs when you need one? Have a look at the estimated plan for this conditional query i.e. the IF as well...

ChrisM@Work (3/27/2015)

---

TomThomson (3/27/2015)

---

dwain.c (3/26/2015)

---

...

Edit: This query shows the same thing:

IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n))

SELECT * FROM sys.all_columns;

Which means that it has something to do...

My workplace used Bit Locker for a while.

There isn't one. I don't know why they don't have one, except that they really...

So here's a tale from my workplace that will change up the conversation...

I was having a Really Bad Day last week. I was trying to send an email to a...

Luis Cazares (3/26/2015)

---

By the way, about the article that Gail posted where they mention a comic book cover. I found that discussion out of place. Feminists reacted to an image...

GilaMonster (3/25/2015)

---

That's certainly not what I said...

The only two things that changed in the Execution Plan was the complexity of my variable calls (expected) and the CompileMemory went from 256 to 240. Everything else is the...

Sorry. I should have thought about that. Here it is.

DECLARE @YrMo INT,

@YrMoStrg CHAR(6) = (SELECT CONVERT(CHAR(6),DATEADD(m,-1,GETDATE()),...

Oh, will you please stop making sense? I...

Scrubbed table structure and execution plan attached. I have not included sample data yet because it will take a while for me to scrub it. Let me know if this...