Viewing 15 posts - 12,571 through 12,585 (of 22,214 total)
To add one thing to what Gail said:
... and you've tested them extensively on the query that you're planning to use them on.
Test, test, test and then test some more....
May 9, 2011 at 6:14 am
rootfixxxer (5/6/2011)
But one thing i don't understand, why there's such difference between 2000 and 2005,...
May 9, 2011 at 6:04 am
The one thing you can do, that Gail was leaning towards, would be to have a table on a filegroup. You can restore a filegroup individually.but, the issue here is...
May 9, 2011 at 5:36 am
Steve Jones - SSC Editor (5/6/2011)
I used to go to a networking conference with my boss. A bit of a boondoggle, but...
May 7, 2011 at 4:51 am
vijayakumarn (5/6/2011)
Using the left join i can achieve only one record... but i want two more record respect to the values 'B' and 'C' in the table-2
Sounds like you're not...
May 6, 2011 at 7:17 am
There is no criterial for a join between those tables. It looks like you want a LEFT JOIN, but without joining criteria (a foreign key), you can't make that happen.
May 6, 2011 at 7:05 am
Brandie Tarvin (5/6/2011)
Editor's Note:
May 6, 2011 at 6:52 am
Yes.
There is no "in general." It really depends on the situation and you should test your situation because different ones will work better under certain circumstances.
May 6, 2011 at 5:10 am
Without using a 3rd party tool, nope. You have to restore the database somewhere and then retrieve the tables that way.
If you want to talk about possible 3rd party solutions,...
May 6, 2011 at 5:09 am
It could be blocking, other processes running on the server causing the restore to slow down. Or, it could be that open transactions on your backup are being rolled forward...
May 6, 2011 at 5:07 am
You should not be shrinking your files as a regular part of your operations. If you are, that's indication of problems somewhere. It does sound like you're in Full Recovery,...
May 6, 2011 at 5:04 am
I'd look to see if there are blocks of some sort going on in production, but other than that, I'd want to see more data gathered. You said the servers...
May 5, 2011 at 12:00 pm
I go with PowerShell and use remoting and then you can thread it and fire it on every server, all at the same time, no issues. Here's a small blog...
May 5, 2011 at 11:54 am
There is no alternative tool. That's the best one.
You will absolutely need to plan for thorough testing. One of the issues we found early on when migrating to 2005, but...
May 5, 2011 at 10:23 am
yes, the problems do occur in the engine, but they're very rare. If you're hitting them all over the place, then I'd suggest one of two things is true. You...
May 5, 2011 at 7:20 am
Viewing 15 posts - 12,571 through 12,585 (of 22,214 total)