DBA From The Cold (6/30/2015)

---

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Grant Fritchey (6/30/2015)

---

DBA From The Cold (6/30/2015)

---

Hey guys, going a bit off topic here but would like some advice please...

Sector

Ed Wagner (6/30/2015)

---

Koen Verbeeck (6/30/2015)

---

Solid advice and a great page. If I ever start...

Limoncello

There are few ways of doing this, but can you tell us more about the data, how big are the sets, more details about the structure etc. so we can...

Uveitis

Alan.B (6/29/2015)

---

The posted answers should improve for awhile. A few days ago this happened:

My brand new baby girl! My first baby. I took a month off of work and...

sayedkhalid99 (6/28/2015)

---

how to round the nearest value after round of decimal and return integer. thanks.

declare @data decimal(18,2)

set @data = 5.55

-- output

select '5'

set @data = 5.58

-- output

select...

Jeff Moden (6/28/2015)

---

Ok. I've decided to get to the bottom of this once and for all. I've posted the following on the MVP email site. We'll see...

Jeff Moden (6/28/2015)

---

Even with that fine hypothesis, it's not conclusive proof that the table spool is being read one row at a time for each row or one page at...

ChrisM@home (6/28/2015)

---

Also Assert, unless you've unlimited MAXRECURSION.

So what, in this example, has data organised as 8k pages?

Or to put it another way, why should spools be expected to...

ChrisM@home (6/28/2015)

---

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT n =...

ChrisM@home (6/28/2015)

---

This is about the simplest rCTE that I can think of. No 8k pages anywhere yet Statistics IO reports logical reads:

SET STATISTICS IO ON;

WITH rCTE AS (

SELECT n =...

Done some testing on rCTEs in the passed, couldn't correlate the logical reads to rows/recursions.

😎

Simple test code

USE Test;

GO

SET NOCOUNT ON;

/* Recursions from 1-20,30,40,50,60,70,80,90,100 */

GO

DECLARE @SAMPLE_SIZE INT...

Quick cross-tab suggestion

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @OracleEngData TABLE

( [OMNI_NUMBER] INTEGER

, [TIMESTAMP] INTEGER

, [DATA_TYPE] NVARCHAR(24)

, [DATA_TYPE2] NVARCHAR(24)

, [PARAMETER] NVARCHAR(32)

, [PARAMETER_VALUE] NVARCHAR(132));

INSERT INTO @OracleEngData

(OMNI_NUMBER,TIMESTAMP,DATA_TYPE,DATA_TYPE2,PARAMETER,[PARAMETER_VALUE])

VALUES

(506026,1413240436,'test_data','cnr',211250000,54.8)

,(506026,1413244259,'test_data','cnr',211250000,53.2)

,(506026,1413244679,'test_data','cnr',211250000,53.1)

,(506026,1413309646,'test_data','cnr',211250000,53.4)

,(506026,1413315987,'test_data','cnr',211250000,53 )

...