Viewing 15 posts - 35,596 through 35,610 (of 39,720 total)
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
Did it install with no errors?
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:16 pm
Lightspeed also has encryption in their product if you are really worried. Most of the data in the backup file is ASCII text. While it can't be "restored" without the...
December 6, 2003 at 2:02 am
I do it like Dinesh suggested.
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 2:01 am
Viewing 15 posts - 35,596 through 35,610 (of 39,720 total)