Viewing 15 posts - 3,751 through 3,765 (of 19,560 total)
JAZZ Master (2/11/2014)
The Dixie Flatline (2/11/2014)
L' Eomot Inversé (2/11/2014)
Revenant (2/11/2014)
Ed Wagner (2/11/2014)
Kurt W. Zimmerman (2/11/2014)
jcrawf02 (2/11/2014)
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
SQLRNNR (2/11/2014)
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
Ed Wagner (2/11/2014)
SQLRNNR (2/10/2014)
Ed Wagner (2/10/2014)
SQLRNNR (2/10/2014)
Stuart Davies...
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 11, 2014 at 4:28 pm
Gary Varga (2/11/2014)
Craig-315134 (2/11/2014)
Gary Varga (2/11/2014)
Craig-315134 (2/10/2014)
...but the Darwinistic nature of capitalism sooner or later weeds out the bad ones.Oh, I wish I found that to be the case!!!
But it...
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 11, 2014 at 1:00 pm
Evil Kraig F (2/11/2014)
An article I wrote... gods, was it really 3 years ago?http://www.sqlservercentral.com/articles/Career/73400/
Still a valid approach.
Time flies doesn't it.
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 11, 2014 at 12:58 pm
Please provide sample data and what the desired results should look like.
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 11, 2014 at 12:57 pm
Next best thing is to start building a network. You could have him start by attending sql saturdays
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 11, 2014 at 12:53 pm
ChrisM@home (2/11/2014)
Groundhog Day, Keith. He's seen this once or twice before 😉
Yeah something like that.
If memory serves, we had this same discussion with this OP just last week.:Whistling:
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 11, 2014 at 12:50 pm
Keith Tate (2/11/2014)
Jason was too quick for me. Guess that's what I get for typing out my code instead of having a blog post ready to go. 😀
Hahaha
I still had...
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 11, 2014 at 12:49 pm
Take a look at this post
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
You could easily set this up to batch through your table at 10,000 records at a time. I'd probably just set it up in...
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 11, 2014 at 12:24 pm
Ed Wagner (2/11/2014)
As an example, what if I were to look at...
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 11, 2014 at 12:10 pm
Grant Fritchey (2/11/2014)
Sean Lange (2/11/2014)
jcrawf02 (2/11/2014)
wolfkillj (2/7/2014)
ChrisM@Work (2/7/2014)
Anybody else seeing a kinky image of Koen, Gail and Grant wondering around without their tshirts?
Word is that there are photos of 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 11, 2014 at 10:58 am
I disagree there are two possible answers here.
It started raining as soon as I read the answer options. :hehe:
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 11, 2014 at 8:40 am
Ed Wagner (2/11/2014)
BWFC (2/11/2014)
Ed Wagner (2/11/2014)
SQLRNNR (2/10/2014)
Ed Wagner (2/10/2014)
SQLRNNR (2/10/2014)
Stuart Davies (2/10/2014)
Ed Wagner (2/10/2014)
crookj (2/10/2014)
Stuart Davies (2/10/2014)
BWFC (2/10/2014)
SQLRNNR (2/7/2014)
L' Eomot Inversé (2/7/2014)
SQLRNNR (2/7/2014)
ConfidenceTrickster
TURN
Rotate
Twist
Ferris
Bueller (anyone...anyone)
Day off
Eye disease
Pink
Panther
Leopard
Tiger
Liger
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 11, 2014 at 8:08 am
David1425 (2/8/2014)
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 11, 2014 at 8:05 am
Is it accurate to say that this field could have multiple date values based on the sample data provided?
If so, how does one know which date to use?
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 11, 2014 at 7:46 am
So you have a single column that could store several different types of data?
Please provide a sample dataset and table structure so a better response could be posted for you.
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 10, 2014 at 9:36 pm
Viewing 15 posts - 3,751 through 3,765 (of 19,560 total)