Viewing 15 posts - 3,631 through 3,645 (of 18,926 total)
I wish I had a good link detailing all of this.
Bottom line is that they are not the same and each have better use depending on the case.
My bottom line...
August 8, 2011 at 6:26 am
I'm with you Grant, but if you don't know what's maintaining that server, then how do you stop it?
August 8, 2011 at 6:19 am
As I said, I really think you're better off doing that reorg while on site. If people start complaining you can always stop within 5 secs of the call...
August 8, 2011 at 6:17 am
So let's assume 50 M dev jobs that use sql.
20% of that is 10 M jobs.
Not trying to sound over optimistic here but if you're really looking for job and...
August 8, 2011 at 6:14 am
Oracle_91 (8/8/2011)
He Thanks.
HTH. If it were me and since I have never done a downgrade before I'd set aside 3-4 hours to give this a go. Copy the...
August 8, 2011 at 6:11 am
I think he's reffering to the code specifically.
If this is the case and that the new sp has erased the old sp you could restore an old backup to a...
August 8, 2011 at 6:03 am
I've done this in 2 ways.
1 - Script out every job and then do a windows file search.
2 -
SELECT * FROM msdb.dbo.sysjobsteps WHERE command LIKE '%dbname%' OR database_name...
August 8, 2011 at 6:01 am
Changing the sequense...
As I can understand (I don't have those years experience...):
- Put your code in a job (T-SQL job)
- Stop our transaction log backup job
- Start reorganize index
- Start...
August 8, 2011 at 5:33 am
And by databases he also includes the system DBs.
Make sure you backup those as well (excluding tempdb of course).
August 8, 2011 at 5:00 am
@SQLFRNDZ (8/8/2011)
Yes I still love you, jsut think this is funny as h3ll. 😛
jsutJust..:-D
tanhks 😛
August 8, 2011 at 4:55 am
Very interesting topic Steve.
Could it be possible that there's a missing link in this part of the editorial?
This piece talks about the problems with the
August 7, 2011 at 9:21 pm
Ninja's_RGR'us (8/7/2011)
Jeff Moden (8/7/2011)
Ninja's_RGR'us (8/7/2011)
August 7, 2011 at 9:16 pm
Jeff Moden (8/7/2011)
Ninja's_RGR'us (8/7/2011)
7 straights posts Jeff.The man's on fire :-D.
Heh... I can't wait for someone to pass me for the number of posts so you'll stop riding...
August 7, 2011 at 8:51 pm
Jeff Moden (8/7/2011)
Ninja's_RGR'us (8/7/2011)
August 7, 2011 at 8:42 pm
Can you do a quick select from the table and post what the value is?
Can you post the rest of the code so we can all see what's going on?
August 7, 2011 at 8:34 pm
Viewing 15 posts - 3,631 through 3,645 (of 18,926 total)