Viewing 15 posts - 38,926 through 38,940 (of 49,571 total)
There's no predicate (filter) on that scan, so alone there's no way to see what index would be useful there. The cluster is being scanned and the entire thing returned....
May 26, 2009 at 7:03 am
george sibbald (5/26/2009)
May 26, 2009 at 6:56 am
kladibeeto (5/25/2009)
I am using sql server 2000.
Please post SQL 2000-related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, you're very likely to...
May 26, 2009 at 5:20 am
Leo (5/26/2009)
Is that better to change it up to 16GB for Max Memory?
Absolutely not. If you do that, SQL will try and take all 16 GB and it may...
May 26, 2009 at 5:20 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic723118-338-1.aspx
May 26, 2009 at 3:58 am
Looks like you have traceflag 1205 on. It gives lots of info on deadlock searches, most of which is not overly useful. Switch that traceflag off, and, if you know...
May 26, 2009 at 3:57 am
Have you considered merge replication? Since there's a central 'master' server, that's probably one of the better ways.
May 26, 2009 at 2:56 am
Run DBCC CheckCatalog or, if you're on SQL 2005, just run CheckDB as it includes CheckCatalog from 2005 onwards.
If you drop a table the constraints will be dropped as well....
May 26, 2009 at 2:55 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic723093-149-1.aspx
May 26, 2009 at 2:53 am
shnex (5/26/2009)
If you have any questions about the logic...I can help you this time 🙂
I wasn't exactly planning on rewriting it for you. I was more suggesting that you look...
May 26, 2009 at 2:39 am
shnex (5/26/2009)
I'm using profiler to dig into this and I used OPTION (KEEP PLAN) to "eliminate" the temporary table recompile but no success.
Keep plan does not eliminate temp...
May 26, 2009 at 2:21 am
San (5/26/2009)
Anyways now I uninstalled and reinstalled SQL server 2005.I added ;-T1400 in both Principal & mirror server start parameters.
If both are SP1 or higher, take it out. If not,...
May 26, 2009 at 2:13 am
george sibbald (5/25/2009)
May 25, 2009 at 11:05 am
There aren't that many. Fundamentals are the same.
Backup and restore gained the CHECKSUM and CONTINUE_AFTER_ERROR options
On the restore side there's fast recovery (enterprise only), online restores (Enterprise only)
Can't think of...
May 25, 2009 at 11:04 am
Are you using SQL 2000 or SQL 2008? (seeing as you posted in both forums)
What's the error that you're getting?
What is the data type of @FingerPrintNumber?
May 25, 2009 at 7:51 am
Viewing 15 posts - 38,926 through 38,940 (of 49,571 total)