Viewing 15 posts - 17,731 through 17,745 (of 19,560 total)
Could you provide the error message? There are a few different issues with Express and SP3 not installing properly that I have come across.
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
January 29, 2010 at 12:10 pm
For what it's worth, I agree with Steve. Even if you query AD multiple times throughout the day using this process to update the table, it would be better...
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
January 29, 2010 at 12:07 pm
Could you describe your situation a little more please? What is it that you are trying to accomplish?
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
January 29, 2010 at 12:05 pm
Good points. It is only 16 games and 1 game a week. I am thinking more from the perspective of having the season last just a little bit...
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
January 29, 2010 at 11:34 am
It will never complete if you leave SQL Server running (past experience) and you would end up cancelling the defrag.
For best results, defrag while SQL Server is offline. Secondly,...
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
January 29, 2010 at 11:28 am
Lynn Pettis (1/29/2010)
CirquedeSQLeil (1/29/2010)
Pro-bowl should be in the middle of the season.Good idea, midway in the season, and everyone has the same bye week.
I was thinking that it could 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
January 29, 2010 at 11:21 am
Pro-bowl should be in the middle of the season.
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
January 29, 2010 at 11:05 am
I would start by removing the login and the user from the database (make sure it is gone). Even so far as to remove all the new users 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
January 29, 2010 at 11:03 am
A good interval is sometimes dictated by compliance to some outside authority. For us, it was made clear that we must rotate the keys every 90 days at minimum....
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
January 29, 2010 at 10:59 am
Lynn Pettis (1/29/2010)
I was surprised that...
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
January 29, 2010 at 10:48 am
bitbucket-25253 (1/29/2010)
malleswarareddy_m The question is improper
Rick-153145 Another rubbish QoTD.
bluesbiker I agree with user "malleswarareddy_m", this question is improper
To malleswarareddy_m, Rick-153145 and bluesbiker let me issue you a...
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
January 29, 2010 at 10:46 am
I agree with George. Test your move plan in a sandbox first. Detach, attach or backup restore both should work fine. I would also test the restore...
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
January 29, 2010 at 10:42 am
fast turnaround.
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
January 29, 2010 at 10:25 am
when you granted permissions to the user, what were the exact commands you issued? Or, in the case that you did it through the GUI, what was your process?
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
January 29, 2010 at 2:26 am
Your best bet would be to use a third party log app to try and match your transactions and data.
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
January 29, 2010 at 2:18 am
Viewing 15 posts - 17,731 through 17,745 (of 19,560 total)