Viewing 15 posts - 13,966 through 13,980 (of 49,552 total)
ratheesh4sql (3/9/2013)
here the problem is i can schedule copy only full backup and log backup on secondary server...Using this is it possible....?
Have you tried? If so, does it not work?...
March 9, 2013 at 10:24 am
Personally I don't think there's anything there that requires distinct, I suspect that distinct is there out of habit, probably the same for the nolocks.
March 9, 2013 at 9:58 am
Suggestions for what?
How you recover with the backup strategy you listed is pretty easy, restore latest full backup, restore all log backups.
March 9, 2013 at 9:56 am
Just an additional comment, any form of HA/DR between SQL instances of different versions (log shipping, mirroring, etc) is generally not a good idea. The only way it can work...
March 9, 2013 at 8:29 am
Just worth noting, a while loop is just as much a cursor as an explicitly defined cursor. It just doesn't have the keyword. It's still a loop, it's still processing...
March 9, 2013 at 5:51 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
You can start fixing the query by removing the nolock, unless you don't mind the query returning incorrect data...
March 9, 2013 at 5:33 am
Is the SSIS service installed on that machine?
March 9, 2013 at 3:47 am
Lynn Pettis (3/8/2013)
GilaMonster (3/8/2013)
opc.three (3/8/2013)
GilaMonster (3/3/2013)
They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.
You know I am curious...
March 8, 2013 at 9:33 am
MyDoggieJessie (3/8/2013)
SELECT
'All' [OpID],
'All Ops' [Op Name],
1 [Number],
1 AS Cnt
UNION ALL
SELECT
LEFT(Oprid, 4) [OpID],
Name + ' (' + LEFT(Oprid, 4)...
March 8, 2013 at 8:59 am
Using Task Manager to monitor SQL's memory usage?
32 bit SQL?
March 8, 2013 at 8:51 am
opc.three (3/8/2013)
GilaMonster (3/3/2013)
They were added as separate columns to support a feature that was planned, partially added to SQL 2005 and later scrapped.
You know I am curious about these kinds...
March 8, 2013 at 8:46 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Also note that you need to tune your workload, not your individual queries.
March 8, 2013 at 5:45 am
allmhuran (3/8/2013)
GilaMonster (3/8/2013)
allmhuran (3/8/2013)
GilaMonster (3/8/2013)
sys.dm_os_wait_stats
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
Yep, that's kinda the point I'm...
March 8, 2013 at 5:32 am
allmhuran (3/8/2013)
GilaMonster (3/8/2013)
sys.dm_os_wait_stats
Most of those are meaningless waits, background processes that are supposed to be waiting. That list says nothing of any value.
Yep, that's kinda the point I'm making by...
March 8, 2013 at 5:20 am
Viewing 15 posts - 13,966 through 13,980 (of 49,552 total)