rarara (3/27/2015)

---

Hi, am trying to get to grips with the syntax needed for this...here is one set of example values...

StartDate(this is numeric): 20150305

EndDate(this is numeric): 20150905

MonthlyPaymentDay: 1

PaymentAmount: 125

How do...

Question of the day: what datatype is the Estimated Number of Rows (or Estimated Subtree Cost) displayed in the property sheet of the SELECT operator in the estimated plan of...

Brandie Tarvin (3/27/2015)

---

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...

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 query...

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 email...

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 IF...

Brandie Tarvin (3/27/2015)

---

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...

I'd be tempted to work on each table in turn, logging the duplicated reference numbers. There are loads of ways of detecting dupes. Here's one of them which works nicely...

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 with...

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...

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 as the...

mister.magoo (3/26/2015)

---

ChrisM@Work (3/26/2015)

---

Phil Parkin (3/26/2015)

---

dwain.c (3/26/2015)

---

Gary Varga (3/26/2015)

---

dwain.c (3/25/2015)

---

...I beginning to think that when I wrote this article (based on a quotation from Jeff):

Make it Work, Make it Fast, Make...

Phil Parkin (3/26/2015)

---

dwain.c (3/26/2015)

---

Gary Varga (3/26/2015)

---

dwain.c (3/25/2015)

---

...I beginning to think that when I wrote this article (based on a quotation from Jeff):

Make it Work, Make it Fast, Make it Pretty[/url]

Maybe...

Jeff Moden (3/24/2015)

---

Eirikur Eiriksson (3/24/2015)

---

Wayne West (3/23/2015)

---

Jeff Moden (3/22/2015)

---

Steve Jones - SSC Editor (3/16/2015)

---

Eirikur Eiriksson (3/13/2015)

---

Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of...

-- Note that the filter on r.dbStatusDesc in the WHERE clause

-- turns the left join on vw_ReferralKPIs into an inner join

-- because it excludes NULL values of r.dbStatusDesc in...