Viewing 15 posts - 35,776 through 35,790 (of 39,903 total)
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
It cannot find the SQL server. Are you sure you have the name correct and it is running?
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 12:24 pm
correct, it appears the identity is not part of the transaction. The main reason is that if someone else were to run this with you, you wouldn't want them to...
December 6, 2003 at 12:22 pm
that's what it says, a network error. That being said, can you parse (not excute) the statement?
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 12:20 pm
Viewing 15 posts - 35,776 through 35,790 (of 39,903 total)