Viewing 15 posts - 1,756 through 1,770 (of 19,560 total)
Sean Lange (12/1/2014)
Steve Jones - SSC Editor (12/1/2014)
WorkAvoidance
No play
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 1, 2014 at 2:15 pm
Sean Lange (12/1/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
December 1, 2014 at 2:14 pm
Divine Flame (12/1/2014)
Nice article Ed.You can add "distribution" database also to the list when excluding the system databases.
It depends on the case as to whether to skip or include...
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 1, 2014 at 9:58 am
Another great solution is the set based solution by Gianluca Sartori.
http://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/
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 1, 2014 at 9:56 am
Stuart Davies (12/1/2014)
Ed Wagner (12/1/2014)
crookj (12/1/2014)
Ed Wagner (12/1/2014)
SQLRNNR (12/1/2014)
Ed Wagner (12/1/2014)
Stuart Davies (12/1/2014)
Ed Wagner (12/1/2014)
SQLRNNR (11/30/2014)
Jeff Moden (11/30/2014)
Ed Wagner (11/30/2014)
SQLRNNR (11/29/2014)
Junk (ship)Scuttle
Being a former submarine sailor, my word would be...
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 1, 2014 at 9:09 am
Ed Wagner (12/1/2014)
Stuart Davies (12/1/2014)
Ed Wagner (12/1/2014)
SQLRNNR (11/30/2014)
Jeff Moden (11/30/2014)
Ed Wagner (11/30/2014)
SQLRNNR (11/29/2014)
Junk (ship)Scuttle
Being a former submarine sailor, my word would be "target". 😛
LOL
Fire
Wood
Water
Wind
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 1, 2014 at 8:17 am
Jeff Moden (11/30/2014)
Ed Wagner (11/30/2014)
SQLRNNR (11/29/2014)
Junk (ship)Scuttle
Being a former submarine sailor, my word would be "target". 😛
LOL
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 30, 2014 at 8:28 pm
Luis Cazares (11/28/2014)
SQLRNNR (11/28/2014)
Koen Verbeeck (11/28/2014)
Luis Cazares (11/27/2014)
Koen Verbeeck (11/27/2014)
kaspencer (11/27/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
November 29, 2014 at 12:16 pm
Junk (ship)
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 29, 2014 at 12:15 pm
Koen Verbeeck (11/28/2014)
Luis Cazares (11/27/2014)
Koen Verbeeck (11/27/2014)
kaspencer (11/27/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
November 28, 2014 at 9:39 am
TomThomson (11/28/2014)
Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database...
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 28, 2014 at 9:33 am
If you are a member of sysadmins then there is nothing further in sql server for permissions.
This sounds like the job is doing something outside of sql server, perhaps on...
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 27, 2014 at 9:31 am
Koen Verbeeck (11/27/2014)
And don't kill each other tomorrow...
You know it's bound to happen. Especially now with all of the stores doing million dollar giveaways.
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 27, 2014 at 8:44 am
Jeff Moden (11/26/2014)
Jeff Moden (11/26/2014)
SQLRNNR (11/26/2014)
I decided to down vote this one. Everybody should just go to Oracle where they already have the functionality. (devil)😛
BWAAAA-HAAAAA-HAAAA!!!! I thought...
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 26, 2014 at 10:49 am
Gazareth (11/26/2014)
Ed Wagner (11/26/2014)
jcrawf02 (11/26/2014)
Stuart Davies (11/26/2014)
Eirikur Eiriksson (11/26/2014)
WayneS (11/26/2014)
..what the vote count was..If I remember correctly it was 135 after my vote
😎
Mine made it 143
it's showing 147 right now,...
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 26, 2014 at 7:35 am
Viewing 15 posts - 1,756 through 1,770 (of 19,560 total)