Viewing 15 posts - 15,316 through 15,330 (of 19,560 total)
Yes you could do 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
April 5, 2010 at 5:23 pm
Unless these packages are interdependent, then each package only overwrites it's respective package in MSDB.
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 5, 2010 at 5:22 pm
Start by posting the table definitions for the tables involved with Keys on those tables.
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 5, 2010 at 5:20 pm
bitbucket-25253 (4/5/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 5, 2010 at 5:08 pm
Steve Jones - Editor (4/5/2010)
If that's the case, you might be surprised what compression does for you.
I think I might be considerably surprised as well.
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 5, 2010 at 5:06 pm
That will be the day. Carry your OS around on a flashdrive, plug into any computer and immediately have all of your settings and apps. Would be extremely...
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 5, 2010 at 5:04 pm
I would go with the DDL triggers and audit the database in that regard. This would help ensure that the pertinent action is recorded.
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 5, 2010 at 5:02 pm
Here is some info that may be of use.
I have never done it before, but it looks like you can do it with the built in SQL 2005 stuff. ...
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 5, 2010 at 4:59 pm
I agree with Paul. Start with breaking out the DB backups to separate jobs.
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 5, 2010 at 4:52 pm
It appears that you are going the wrong direction with that. You have a SQL 2005 database trying to restore to a SQL 2000 Instance - not possible.
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 5, 2010 at 4:49 pm
Please provide your table definitions, and what queries you have tried so far.
This will be more helpful and more consumable by the community trying to help 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
April 5, 2010 at 4:41 pm
Jeff Moden (4/5/2010)
CirquedeSQLeil (4/5/2010)
I have started a new thread on this topic.http://www.sqlservercentral.com/Forums/Topic897076-10-1.aspx
Nah.... I'd rather see this discussion continue here instead of essentially double posting. Sorry Jason.
I can continue 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 5, 2010 at 4:38 pm
Jeff Moden (4/5/2010)
I'd rather see the discussion continue on the thread which started it all rather than essentially double posting. Sorry Jason.
I know. There are reasons to move...
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 5, 2010 at 4:36 pm
Jeff Moden (4/5/2010)
Heh... everyone forgot how to eliminate all contention for the table immediately... rename the table. 😛
That is too friendly - drop it altogether 😛
Then again, the contention would...
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 5, 2010 at 4:34 pm
Jeff Moden (4/5/2010)
if 234 is 02:34 then why on Earth would 1 be anything but 00:01???? :blink:
Nice catch there Jeff.
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 5, 2010 at 4:33 pm
Viewing 15 posts - 15,316 through 15,330 (of 19,560 total)