Viewing 15 posts - 14,791 through 14,805 (of 19,560 total)
Thanks for posting that resource.
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
April 15, 2010 at 11:25 pm
You're welcome.
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
April 15, 2010 at 11:23 pm
Awesome question Ron. This information is extremely useful.
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
April 15, 2010 at 9:28 pm
In this scenario you do not want to use sp_help_revlogin. That would recreate the the prod user with the prod password if the login did not exist on 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
April 15, 2010 at 9:20 pm
Check these articles:
http://msdn.microsoft.com/en-us/library/ms174398(v=SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms189491(SQL.90).aspx
http://www.sqlservercentral.com/Forums/Topic541612-149-1.aspx
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
April 15, 2010 at 5:36 pm
Steve Jones - Editor (4/15/2010)
So much for "ignore this"
Put up a sign and say " DO NOT ENTER" and more than likely we will go in - inquiring minds. 😀
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
April 15, 2010 at 5:03 pm
Steve Jones - Editor (4/15/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
April 15, 2010 at 5:02 pm
Notice that the time stamp is different for each request. Each of these requests is a new request from the same connection. The CPU would be specific to...
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
April 15, 2010 at 4:53 pm
Hmmm interesting.
http://www.dba-oracle.com/oracle_tips_intelligent_10g_DBA_maintenance.htm
Oracle provides maintenance tools to help do that, but they also say that you must do regular maintenance anyway.
Essentially the way it works is the management tools will do...
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
April 15, 2010 at 4:38 pm
After you restore the database, you need to fix the orphaned users. The test server will have different SIDs than the prod 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
April 15, 2010 at 4:32 pm
It is possible (Small Business Server does the same sort of thing), but I would never do it.
Why? Same reasons as already listed.
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
April 15, 2010 at 4:27 pm
lmu92 (4/15/2010)
Alvin Ramard (4/15/2010)
Roy Ernest (4/15/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
April 15, 2010 at 3:57 pm
Roy Ernest (4/15/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
April 15, 2010 at 3:21 pm
If you must re-enter the data, then load the data into the application and have the application do a checksum on each field and immediately alert to differences or not...
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
April 15, 2010 at 3:19 pm
WayneS (4/15/2010)
Roy Ernest (4/15/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
April 15, 2010 at 3:15 pm
Viewing 15 posts - 14,791 through 14,805 (of 19,560 total)