Viewing 15 posts - 35,686 through 35,700 (of 39,804 total)
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
You cannot update multiple tables in one statement. You'd need 3 statements to update all 3. You can update one table that is joined to 2 others, but the updates...
December 6, 2003 at 2:00 am
I don't think this much matters from the server perspective. It isn't checked anywhere. It's more a legal item that you purchase the licenses in case you are audited.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
December 6, 2003 at 1:59 am
Thanks for the complement!!!!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 6:57 pm
You will be able to code a VB.NET procedure, using .NET constructs inside SQL Server. These are compiled and execute. However, for many query type statements, this won't make sense...
December 5, 2003 at 1:38 pm
Congrats!!!! and thanks for being a part of the community.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 1:35 pm
Wow, is that from v6.5? It's been awhile, but I thought you couldn't shrink those files.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 5, 2003 at 1:34 pm
Viewing 15 posts - 35,686 through 35,700 (of 39,804 total)