Viewing 15 posts - 10,951 through 10,965 (of 19,560 total)
I played with it some more. Using combo from what lutz and I did already.
; WITH cte AS
(
SELECT
...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 5:10 pm
LutzM (2/25/2011)
I'd apply a fast split string function to the shredded data. It might help performance to insert the shredded data into a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 4:07 pm
Peter Trast (2/25/2011)
Peter Trast (2/25/2011)
John Rowan (2/25/2011)
CirquedeSQLeil (2/25/2011)
Brandie Tarvin (2/25/2011)
pea soupSplit
Banana
Top
Mountain
Crest
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 4:06 pm
I think This will get you closer
SELECT X.Y.value('(../@name)[1]','varchar(20)') as TableName
,x.y.value('(../@columns)[1]','varchar(128)') as ColumnList
,x.y.value('(@values)[1]','varchar(128)') as ColumnValues
FROM @XML.nodes('//relation/row') X(Y);
I'm still working through it, but my thought was to use the pivot and a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 4:05 pm
Peter Trast (2/25/2011)
John Rowan (2/25/2011)
CirquedeSQLeil (2/25/2011)
Brandie Tarvin (2/25/2011)
pea soupSplit
Banana
Top
Cherry
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:34 pm
WayneS (2/25/2011)
Jeff Moden (2/17/2011)
The Dixie Flatline (2/17/2011)
Jeff Moden (2/16/2011)
WayneS (2/15/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:32 pm
Roy Ernest (2/25/2011)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:31 pm
SQLkiwi (2/24/2011)
Ian Scarlett (2/24/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
OMG, that makes me...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:27 pm
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
Hmm - high school for me
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:26 pm
Happy...............................................................................
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:17 pm
Brandie Tarvin (2/25/2011)
pea soup
Split
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:15 pm
sing4you (2/25/2011)
ham hocks
goldilocks
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:11 pm
Daniel Bowlin (2/23/2011)
Focus
Sorry it's a bit fuzzy
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:10 pm
Peter Trast (2/22/2011)
Tom.Thomson (2/22/2011)
crookj (2/22/2011)
Peter Trast (2/18/2011)
Brandie Tarvin (2/18/2011)
WOTD: JeansDjinn
Efreeti
Joe
zephyr
(Because I love my Ifrit with the light brown hair....)
sprite
nymph
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:02 pm
Ray K (2/22/2011)
Tom.Thomson (2/21/2011)
Brandie Tarvin (2/21/2011)
flossmill
grist
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 25, 2011 at 3:01 pm
Viewing 15 posts - 10,951 through 10,965 (of 19,560 total)