Viewing 15 posts - 19,426 through 19,440 (of 19,560 total)
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic779918-146-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
August 31, 2009 at 11:27 am
chuckle
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
August 31, 2009 at 11:23 am
After you restore the Full back to your subscriber, you can then restore the diff on the subscriber.
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
August 31, 2009 at 11:18 am
WhiteHouse Window Washer?
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
August 31, 2009 at 10:25 am
this HR guy sounds like a real winner - did he ever find a job:alien:? Couldn't imagine he would keep his job anywhere with the bashing of protected groups...
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
August 31, 2009 at 10:20 am
Clive Strong (8/29/2009)
What Version of SQL?
1. Depends - table and index. It would be best to do it during maintenance in many cases.
3. There is downside 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
August 31, 2009 at 10:04 am
Typically installing multiple instances on the same server is not related to performance increase but moreso to business policy, politics, or something of that nature.
Though this article is for BizTalk...
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
August 28, 2009 at 10:53 pm
Most Excellent start Roy. Congrats
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
August 28, 2009 at 10:40 pm
Here is an article that may also be of use:
Fixing Orphaned Users - Recreate Scenario
User Owns Schema and is Orphaned
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
August 28, 2009 at 10:28 pm
meichner (8/28/2009)
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
August 28, 2009 at 10:05 pm
You have sparked my interest.
To be able to work on some of these databases could be fun in a morbid way. It would be a fantastic challenge.
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
August 27, 2009 at 10:30 pm
Again that would depend. Read Gails blog that she posted earlier on this topic.
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
August 27, 2009 at 10:12 pm
Good point on the behavior pattern adjustment.
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
August 27, 2009 at 4:11 pm
Lynn Pettis (8/27/2009)
GSquared (8/27/2009)
Lynn Pettis (8/27/2009)
Asking this:
i need the query(dbname,size,recoverymodel) for all databases in a server.
tells me you haven't even tried to find an answer...
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
August 27, 2009 at 3:35 pm
A possible reason for the redgate question stems from the users existing in a database. It seems that the users it sees might be orphaned and so it is...
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
August 27, 2009 at 3:19 pm
Viewing 15 posts - 19,426 through 19,440 (of 19,560 total)