TheSQLGuru (5/11/2016)

---

Alan.B: You have escaped the primary performance problem of chewing through unnecessary rows of each month on the date dim table with the filtered index. Well done. That was...

Good stuff (literally) and thanks for the heads up Steve

😎

Jeff Moden (5/13/2016)

---

jasona.work (5/13/2016)

---

So at the Detroit SQL PASS meeting last night, got to put faces to the names of those shining beacons of SQL knowledge and all things pork...

I realize this is an old conversation but still valid, my thought is that in today's media marketing, freebies are considered a must, no carrot no catch in a way....

Discrimination in any...

Neeraj Pal (5/13/2016)

---

This Query will Return current and Previous 12 month Start Date..

==========================================

DECLARE @month int=0

DECLARE @table TABLE (LastYearDate DATETIME)

WHILE @month<12

BEGIN

INSERT @table

( LastYearDate...

Quick suggestion

😎

DECLARE @cap2 TABLE

(

id int primary key,

ten varchar(100) not null,

SoCV varchar(100) not null

)

INSERT @cap2

VALUES (1,'user 1|user 2|user...

Suggest you add first...

etirem (5/11/2016)

---

Hello All...need your help ,

I have 2 db's(@DName1 and @DName2). Need to change the logical names of @DName1 to @DName2 names.

Executing --Stmt_1 gives --Stmt_2 and then executing --Stmt_2 will...

Alan.B (5/11/2016)

---

I think my performance test proves that a calendar table is a viable high-performing alternative. In the end I would go with a tally table solution because of the...

Eric M Russell (5/11/2016)

---

TheSQLGuru (5/11/2016)

---

Eric M Russell (5/11/2016)

---

drew.allen (5/11/2016)

---

Eric M Russell (5/11/2016)

---

For what it's worth, this one can be paramaterized in terms of the number of dates returned, and it...

Grant Fritchey (5/11/2016)

---

Eirikur Eiriksson (5/11/2016)

---

Grant Fritchey (5/11/2016)

---

Without seeing the execution plans, I'd just be guessing.

My guess is, you may have hit some bad parameter sniffing on the query that was...

GilaMonster (5/11/2016)

---

Since key lookups are only ever done to the...

Grant Fritchey (5/11/2016)

---

Without seeing the execution plans, I'd just be guessing.

My guess is, you may have hit some bad parameter sniffing on the query that was running fast previous to...

Phil Parkin (5/11/2016)

---

Eirikur Eiriksson (5/11/2016)

---

Sean Lange (5/11/2016)

---

WHY OH WHY can we not get the spam under control on this site? Every morning it is about 2 spams for every actual...