Lynn Pettis (10/19/2015)

---

Here is the update query initially post in a slightly more readable format:

UPDATE SERVICE_REQUEST

SET SERVICE_REQUEST_STATUS = 'PrintedOnPullReport'

,LAST_PRINTED_ON_REPORT_DATE = '2015-10-15 00:00:00'

,LAST_MOD_DATE_TIME = '2015-10-15 06:10:03.223'

,LAST_MODIFIER = 60417

,PRINT_REQUEST_ID = 69432

FROM SERVICE_REQUEST...

Ed Wagner (10/20/2015)

---

Luis Cazares (10/20/2015)

---

Brandie Tarvin (10/20/2015)

---

Ed Wagner (10/20/2015)

---

Alvin Ramard (10/19/2015)

---

From: http://www.sqlservercentral.com/Forums/Topic1720717-1292-4.aspx#bm1729123

ITU_dk2012 (10/19/2015)

---

... I think I should post this into another SSC forum because I am not getting any...

sreeya (10/20/2015)

---

Thanks all for your suggestions. Here is more information on the table design etc:

I will need to create a report on below tables.

Order Facts Table has below columns:

ID bigint...

How would you scale this up to a million rows?

Here's another way, a million random-ish datetimes between 1947 and today:

-- A million datetimes between 1947 and today:

;WITH

t1 (x) AS (SELECT * FROM (VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) d (x)),

t2 (x)...

Martin Stephenson (10/19/2015)

---

There is a mismatch in estimated count of 17 vs actual of 13k, this becomes visible after the join to the table with the suggested missing index. Not...

DECLARE @StartTime DATETIME

DECLARE @Item VARCHAR(20) = ''

SET @StartTime = GETDATE()

SELECT @Item = @Item + ','+d2.Item

FROM dbo.DelimitedSplit8K_LEAD ('Param1=3;param2=4;param4=testval;param6=11',';') d1

CROSS APPLY dbo.DelimitedSplit8K_LEAD (d1.Item, '=') d2

WHERE d2.ItemNumber = 2

ORDER BY d1.ItemNumber

SELECT...

Martin Stephenson (10/19/2015)

---

I have a query where a sort operation is flagging a spill into tempdb in the execution plan. There are no Order by sort operations in the query....

Alvin Ramard (10/19/2015)

---

Jeff Moden (10/18/2015)

---

I realize this post should probably be under "Jobs" but I thought I'd give the dedicated denizens of the thread first crack at it.

Any "hybrid" DBAs...

mister.magoo (10/16/2015)

---

Isn't it also the case that using LIKE allows the QO to use statistics to estimate the selectivity of the query.

According to this White Paper: https://msdn.microsoft.com/en-us/library/dd535534(v=sql.100).aspx

String Summary Statistics

SQL Server...

Thanks. Your tables are heaps. Clustered indexes are strongly recommended.

Does the query really return 60 odd million rows? It can't,...

So you have some improvement. Can you post the actual execution plan please (not a picture of it, a .sqlplan file attachment)? Cheers.

USE [Global_Storage]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[stg].[Report_Global_Storage_Capacity]') AND type in (N'U'))

DROP TABLE [stg].[Report_Global_Storage_Capacity]

GO

with DatesPresent as (

SELECT

dp_year = YEAR(Date_),

dp_Month = MONTH(Date_),

FirstOfThisMonth = CAST(YEAR(Date_) AS VARCHAR(4))...

sharonsql2013 (10/16/2015)

---

Hi

I need to split the amount equally into 12 months from Jan 2015 through Dec 2015.

There is no date column in the table and the total amount has...

rs80 (10/16/2015)

---

Does the original code that I posted with the while loop and the CROSS JOIN/APPLY have the same performance? I would think that the CROSS JOIN has better...