Viewing 15 posts - 751 through 765 (of 19,560 total)
Luis Cazares (10/27/2015)
Grant Fritchey (10/27/2015)
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
October 31, 2015 at 6:21 pm
yb751 (10/29/2015)
I was thinking about unleashing it but then I thought maybe 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
October 31, 2015 at 6:18 pm
Eirikur Eiriksson (10/30/2015)
😎
(mis) Quoting William Edward Hickson
Tis a lesson you should heed:
Try, try, try again.
If at first you don't succeed,
Try, try, try...
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
October 31, 2015 at 3:35 pm
Toreador (10/30/2015)
edwardwill (10/30/2015)
Toreador (10/30/2015)
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
October 31, 2015 at 3:24 pm
Toreador (10/30/2015)
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
October 31, 2015 at 3:22 pm
Steve Jones - SSC Editor (10/28/2015)
Apologies. 5 Rows are returned. The wrong box got checked.Awarding back points to everyone.
Ah shucks.
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
October 31, 2015 at 3:17 pm
below86 (10/28/2015)
Sean Lange (10/28/2015)
Roshan Oozeer (10/28/2015)
Correct answer is 5 not 4 ... I want my 2 points.... Thank youRoshan
You just got one of them. If you want points that badly...
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
October 31, 2015 at 3:16 pm
I think this is a great question. It is really easy in sqlcmd mode to forget the GO statements after each block for each connection.
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
October 31, 2015 at 3:09 pm
Stewart "Arturius" Campbell (10/22/2015)
martin.whitton (10/22/2015)
Of course, if you have more than 2^21 columns in your database, it will return an error ... 😀
if one has that many columns, they will...
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
October 31, 2015 at 3:03 pm
Bob JH Cullen (10/15/2015)
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
October 31, 2015 at 2:56 pm
Aaron N. Cutshall (10/13/2015)
Good demonstration.
+1
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
October 31, 2015 at 2:53 pm
Interesting interpretation on drift. I imagine racecar drifting when I think of database drift.
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
October 31, 2015 at 2:44 pm
TomThomson (10/5/2015)
sknox (10/5/2015)
This question is almost more about TRUNCATE than IDENTITY. All of the inserts before the TRUNCATE are just red herrings.
To some extent I agree, but I would...
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
October 31, 2015 at 2:38 pm
Steve Jones - SSC Editor (10/14/2015)
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
October 14, 2015 at 12:59 pm
Ed Wagner (10/11/2015)
I see the sports spam has returned. Sigh.
News clip spam, sports spam, ad spam.
My inbox is littered with SSC forum posts that are just spam (e.g. the...
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
October 12, 2015 at 4:54 pm
Viewing 15 posts - 751 through 765 (of 19,560 total)