SQL Galaxy (10/7/2015)

---

HI.

I have verified at DB level for Index farg and statistics are normal but still execution take long time to completed.

Actual Execution plan does not suggested any missing...

tindog (10/6/2015)

---

ChrisM@Work (10/6/2015)

---

Perhaps the data which the SSIS package interacts with is not in cache the first time it's run.

I'm surprised it takes so long for so few rows. What...

DROP TABLE #Hierarchy

CREATE TABLE #Hierarchy (ID VARCHAR(20), [Description] VARCHAR(20), ParentID VARCHAR(20), [Level] CHAR(1))

INSERT INTO #Hierarchy (ID, [Description], ParentID, [Level])

SELECT 'B.01','Parent 1',NULL,'H' UNION ALL

SELECT 'B.01.01','Parent 1.1','B.01','H' UNION ALL

SELECT 'B.01.01.01','Parent 1.1.1', 'B.01.01','H'...

Perhaps the data which the SSIS package interacts with is not in cache the first time it's run.

I'm surprised it takes so long for so few rows. What exactly does...

sushil_dwid (10/6/2015)

---

Hi ,

I have query on grouping data on weekly basis..

1. Week should start from Monday to Sunday

2. It should not consider current week data(suppose user clicks on...

This only makes sense if the entire column is NULL. Think about it. What...

Here's another method which begins with Ben's logic but returns 22 rows, same as the last solution I posted:

;WITH Matrix AS (

SELECT

x,

y,

s = x + y,

p =...

Hi Ben

I don't get a single value for this puzzle, but about 22 possible values. Here's the query:

;WITH Matrix AS (

SELECT

x,

y,

s = x + y,

p = x...

Begin by reading these:

David Durant; Stairway to Indexes. A series of well-written articles to take...

TomThomson (10/3/2015)

---

I...

Hi Sharon

To help us to help you, can you please set up a data script? You will want to include a minimum of two patients and a minimum of three...

A third possible solution:

SELECT

ta.cola1,

ta.cola2,

ta.cola3,

colb1 = COALESCE(tb1.colb1, tb2.colb1, tb3.colb1),

colb2 = COALESCE(tb1.colb2, tb2.colb2, tb3.colb2),

colb3 = COALESCE(tb1.colb3, tb2.colb3, tb3.colb3),

colb4 = COALESCE(tb1.colb4, tb2.colb4, tb3.colb4)

FROM dbo.tabA ta

LEFT JOIN dbo.tabB tb1 ON tb1.colb1 = ta.cola1

LEFT JOIN...

mw112009 (10/2/2015)

---

Let me start fresh here....BTW-- I commented out the first query

Lets forget the first query.. That takes only taking 90 milliseconds.. Ignore that for now.

This is what is taking...

mw112009 (10/2/2015)

---

Time taken by first query = Anywhere from 13 to 52 milli seconds. ( I hit the execute button a several times )

Also the hinstp has only 479...

mw112009 (10/2/2015)

---

Need some help here... I am new to the finetuning business..

I have attached the stored proc code...

The entire stored proc gets run under 3 seconds.. I am in...