Viewing 15 posts - 16,666 through 16,680 (of 19,560 total)
Working late comes with the territory.
As far as the editorial, I try to implement as many automated solutions as I can - limits the hours. I couldn't imagine 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
March 9, 2010 at 9:44 pm
Another nice editorial Steve.
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
March 9, 2010 at 9:25 pm
GTR is correct.
One addendum. Avoid using the SA account where possible. You will typically setup an SA account password during installation. Upon completion, I would create an...
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
March 9, 2010 at 9:08 pm
Let's start with user account being used. Make sure it has adequate permissions for the install files folder.
Next, where is the media you are using for the installation? ...
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
March 9, 2010 at 8:45 pm
GTR (3/9/2010)
gupta1282 (3/9/2010)
Our TempDB mdf file size is 32617 MB and Unallocated Space showing 32607 MB
but size of mdf file is not reducing after shrinking.
Why This happening ? ...
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
March 9, 2010 at 8:43 pm
Thanks for that article. That might prove useful in a current project.
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
March 9, 2010 at 5:48 pm
Click the blogs link on the left. Once the page refreshes, you can click control panel on the right hand side of the screen (under the label (My Profile)....
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
March 9, 2010 at 5:45 pm
Tom Schuettke (3/9/2010)
Think Geek has stuff that would make great prizes. I especially like the annoyatron.:cool:
I like how you think. There are plenty of great things on thinkgeek....
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
March 9, 2010 at 5:37 pm
Thanks for the article. Unfortunately there are plenty of 2000 servers still in production (75% of mine are 2000). It was quite a refresher course when coming from...
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
March 9, 2010 at 4:48 pm
Thanks Lowell and Thorv.
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
March 9, 2010 at 4:36 pm
Long days and lots of hours. I think one essential thing to remember is to remember that you can't learn it all at once. Take notes, be organized...
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
March 9, 2010 at 4:32 pm
Lynn Pettis (3/9/2010)
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
March 9, 2010 at 4:23 pm
Alvin Ramard (3/9/2010)
CirquedeSQLeil (3/9/2010)
Maybe change it to Dr. Lynn Pettis. 😎Dr. Lynn Pettis, MVP ?
Maybe Dr. Lynn Pettis, MCP (master control program) :Whistling:
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
March 9, 2010 at 3:50 pm
Maybe change it to Dr. Lynn Pettis. 😎
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
March 9, 2010 at 3:42 pm
Cyberspy (3/9/2010)
Thanks for the pointer. I had a look though the rest of the logs and there was no sign of further attempts, so the delay must have not happened...
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
March 9, 2010 at 3:40 pm
Viewing 15 posts - 16,666 through 16,680 (of 19,560 total)