Viewing 15 posts - 4,546 through 4,560 (of 19,560 total)
Revenant (5/28/2013)
SQLRNNR (5/26/2013)
Moron MountainGruyère
I believe I can fly
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
May 28, 2013 at 4:44 pm
Steve Jones - SSC Editor (5/28/2013)
Brandie Tarvin (5/28/2013)
Cadavre (5/28/2013)
Why can't you just do an IPConfig?
Because until Greg gave me the keystrokes I needed, I couldn't get to a command line.
Greg,...
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
May 28, 2013 at 9:34 am
Not sure what you mean by SQL download, can you elaborate?
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
May 27, 2013 at 10:58 am
GilaMonster (5/27/2013)
Lorenzo Mota (5/27/2013)
So, besides the DTS, is there anything automatic or internal of SQL Server that could be doing this?
No. SQL will never automatically change database settings. If recovery...
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
May 27, 2013 at 10:56 am
You can try this as a shortcut
SELECT *
FROM msdb.dbo.sysjobsteps
WHERE command LIKE 'alter 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
May 27, 2013 at 10:22 am
Materialized views are not stored in the buffer cached (unless records are needed by a query) and are not materialized in the tempdb.
When you create an index on a view...
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
May 26, 2013 at 8:29 pm
Easy enough - I have done this in the past.
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
May 26, 2013 at 8:06 pm
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
May 26, 2013 at 7:58 pm
Moron Mountain
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
May 26, 2013 at 7:55 pm
Evil Kraig F (5/24/2013)
A number of folks (myself included) would be happy to help you nail down your requirements and the like and help with the presentation. 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
May 26, 2013 at 7:29 pm
Evil Kraig F (5/24/2013)
A number of folks (myself included) would be happy to help you nail down your requirements and the like and help with the presentation. 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
May 26, 2013 at 7:20 pm
Steven Willis (5/24/2013)
Chrissy321 (5/24/2013)
I need help in writing a job description for a senior administrative DBA. Can someone suggest an appropriate forum on SSC.com where I can do this?
How about...
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
May 26, 2013 at 7:18 pm
Lynn Pettis (5/24/2013)
Brandie Tarvin (5/24/2013)
SQLRNNR (5/24/2013)
Caught up on the thread now.And FTR - 90 posts to go for 40000 - a new milestone
Just goes to prove that none of us...
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
May 24, 2013 at 10:31 am
Uwe Ricken (5/24/2013)
I'VE GOT IT!!!!!
A few minutes ago i got the mail from Bob - passed...
OMG - can't describe what I feel currently...
What a journey - it took me...
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
May 24, 2013 at 10:26 am
Straight forward question - thanks
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
May 24, 2013 at 10:01 am
Viewing 15 posts - 4,546 through 4,560 (of 19,560 total)