Viewing 15 posts - 5,416 through 5,430 (of 19,560 total)
Ho Ho Ho - Happy Holidays everybody.
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
December 24, 2012 at 11:10 pm
Merry Christmas Everybody
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
December 24, 2012 at 11:04 pm
Thanks to Hugo and Tom for the discussion.
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
December 24, 2012 at 9:15 am
Lynn is correct. If you need to remove the table, you need to use DROP. If you are only trying to remove records, then DELETE is what 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
December 23, 2012 at 10:54 pm
L' Eomot Inversé (12/23/2012)
Lynn Pettis (12/22/2012)
Constantly amazed by the number of people who think that full backups truncate the transaction log. Where do they get such ideas?
That's a clear...
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
December 23, 2012 at 7:02 am
Mind sharing what you did to get it working?
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
December 22, 2012 at 8:38 pm
Jeff Moden (12/21/2012)
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
December 21, 2012 at 9:39 pm
The Dixie Flatline (12/21/2012)
GilaMonster (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
WayneS (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups....And do proper restores.
And they don't restart their servers...
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
December 21, 2012 at 9:35 am
The Dixie Flatline (12/21/2012)
WayneS (12/21/2012)
SQLRNNR (12/21/2012)
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups....And do proper restores.
And they don't restart their servers to fix data corruption issues.
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
December 21, 2012 at 9:11 am
The Dixie Flatline (12/21/2012)
In SSC Heaven, all the OPs do proper backups.
...And do proper restores.
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
December 21, 2012 at 8:52 am
There is a script here to help you with that.
http://jasonbrimhall.info/2012/07/17/a-trio-of-eachdb/
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
December 21, 2012 at 1:26 am
The use of temp tables is a common practice even in production. There are many uses for a temp table some of which being to help with coding or...
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
December 21, 2012 at 1:24 am
What has likely been done is to setup the additional data files for recover-ability and not performance. The separation you have described is done often times when doing filegroup...
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
December 21, 2012 at 1:21 am
Your databases have been upgraded but it does not appear that the cluster upgrade has been completed. Check the link provided and verify your setup.
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
December 21, 2012 at 1:04 am
Thanks for the question.
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
December 21, 2012 at 12:57 am
Viewing 15 posts - 5,416 through 5,430 (of 19,560 total)