Viewing 15 posts - 35,641 through 35,655 (of 39,771 total)
Does this happen everytime? I'd run profiler in the background and see what is actually completing. This runs a number of commands.
You can also just run sp_who2 from QA and...
December 8, 2003 at 2:11 pm
Monitor the service for up and down. I wouldn't monitor other items (CPU, disk wait, etc) unless you can set a limit of of like 3 failures over 15 or...
December 8, 2003 at 12:38 pm
no. Data is not "archived". You'd have to build your own process for this.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 8, 2003 at 11:55 am
also http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 8, 2003 at 11:51 am
Have you run a dbcc checkdb? I'd be curious to see if this shows up there. The latch issue might be fixed with a clustered reindex rebuild of the tables...
December 8, 2003 at 11:44 am
There is a minimum size to which you can shrink files, AFAIK, it's about the base level at which it was created. I'm sure you've run the shrink script a...
December 8, 2003 at 11:42 am
There is also a script here that can help
http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 8, 2003 at 11:29 am
Definitely some network item. The VPNs can be implemented differently and they don't always pass all ports through the tunnel. Are you connecting by IP or name?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
December 7, 2003 at 2:52 pm
Not sure about the plus sign, might be protection against SQL Injection.
Anyway, you need to self join back to the existing table to get the previous row. Now the previous...
December 7, 2003 at 2:51 pm
AFAIK, There is no limit on SQL Server 2K Enterprise for Memory, limited by the OS. This ref (http://www.microsoft.com/sql/techinfo/administration/2000/scalabilityfaq.asp) shows that it can take up to 64GB of RAM in...
December 6, 2003 at 7:52 pm
It appears that W2K3, Enterprise has a 32GB RAM limit. Also an 8CPU limit.
W2K, Advanced Server allowed up to an 8 way x 8GB RAM.
References:
http://www.microsoft.com/windows2000/advancedserver/howtobuy/choosing/default.asp
http://www.microsoft.com/windowsserver2003/evaluation/features/compareeditions.mspx
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
December 6, 2003 at 6:52 pm
We run it on here, but haven't really tested it turned off. Haven't had any issues though.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 6, 2003 at 6:42 pm
I agree with Andy. Any issues with performance are not completely issues with the design, but the administration and implementation also play a part. In the case mentioned, the lack...
December 6, 2003 at 6:41 pm
Some good techniques if you really need to do this in SQL, but my argument often for this process is to have the client do it. VB, Crystal, ASP, etc....
December 6, 2003 at 3:25 pm
while loop because SQL Server is optimized to run set based operations. Even running them many times will often be better than a cursor. Of course, you'd have to benchmark...
December 6, 2003 at 12:27 pm
Viewing 15 posts - 35,641 through 35,655 (of 39,771 total)