Viewing 15 posts - 7,876 through 7,890 (of 19,560 total)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and...
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
November 14, 2011 at 8:09 am
Ninja's_RGR'us (11/14/2011)
crookj (11/14/2011)
Ninja's_RGR'us (11/11/2011)
SQLRNNR (11/11/2011)
Ninja's_RGR'us (11/11/2011)
Confusing with Britney?Well they did kiss. I could see how that mistake could be made.
Good point! 😀
Adds a whole new meaning to lip sync...
Ya...
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
November 14, 2011 at 8:08 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/14/2011)
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find...
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
November 14, 2011 at 8:06 am
Ninja's_RGR'us (11/14/2011)
SQLRNNR (11/13/2011)
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that script....
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
November 14, 2011 at 7:20 am
Gianluca Sartori (11/14/2011)
Congrats Jason for winning T-SQL challenge 63!
Thanks - you were quick on that. I just got the email this morning.
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
November 14, 2011 at 7:02 am
So on this other system which did you do?
dbcc dbreindex (deprecated way to rebuild indexes)
alter index rebuild
alter index reorganize
and which did you attempt on the prod?
Just curious.
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
November 13, 2011 at 8:59 pm
Ninja's_RGR'us (10/19/2011)
I know I did. Just not sure if it was this exact version :-D.
So, i checked my email and the blog and didn't find that script. But...
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
November 13, 2011 at 8:53 pm
Alan Naylor (11/13/2011)
The primary keys are fragmented too and can't drop them without dropping constraints and that's not a good idea to do on live production.
You don't need to drop...
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
November 13, 2011 at 8:46 pm
What is preventing you from doing this maintenance on the actual prod server?
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
November 13, 2011 at 8:24 pm
michael.french 172 (11/9/2011)
Apparently I am a Pediatric Dentist. My kids will be thrilled to find that out.
Oh the money I could save if I were a Pediatric Dentist.:-D:-D:-D
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
November 13, 2011 at 5:40 pm
I find the practice of prefixing with tbl_ just a waste of 4 chars in a table name. It would be funny if a proc were prefixed with tbl_...
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
November 13, 2011 at 5:13 pm
I agree with Gail. I really hate the vw_ or tbl_ or variations of such prefixes. I have inherited databases like that and the re-factoring problem is coming...
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
November 13, 2011 at 5:10 pm
It was good chatting Steve. Also good to see some of the other people like Tom, Robert, Andy, Mike and Mike, Brian and Matt.
It was also fun to run...
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
November 13, 2011 at 3:57 pm
Thanks Tom for continuing to educate us on NF
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
November 13, 2011 at 2:35 pm
btio_3000 (11/12/2011)
Dev (11/12/2011)
If you have start with Node 8 as Child, it has 2 parents (6&7)
6 has 2 parents -> 2...
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
November 13, 2011 at 2:20 pm
Viewing 15 posts - 7,876 through 7,890 (of 19,560 total)