Viewing 15 posts - 38,671 through 38,685 (of 39,456 total)
December 11, 2001 at 10:18 am
An interesting explanation. And not without merit. Part of my hesitation is that over the years I have seen more bugs (obscure) with views and temp tables than with normal...
December 11, 2001 at 10:17 am
Also, please feel free to post questions here for specific "how does SQL work" questions. We also have lots of beginning articles that should help you get up to speed.
Steve...
December 11, 2001 at 10:12 am
A quick search on Technet for "sql 823" gives these articles. Any apply?
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q274310
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q281809
Steve Jones
December 11, 2001 at 10:10 am
The long and short is that I place everything in a separate script and it get's shared (to an "InFlight" folder) or branched (To a specific release).
Each script is short...
December 11, 2001 at 10:06 am
Is this NT or 2K, also what version of SQL.
In working with SQL 7 for 2 years (3 servers) and SQL 2000 for a year (7 servers), never had an...
December 11, 2001 at 9:54 am
SQL Server does not provide a way to throttle queries, so once a query is begun, it will use all the resources it needs to complete. This can cause problems...
December 11, 2001 at 8:56 am
yes they are released together (along with MsDE). Not sure about how to apply here. Brian?
Steve Jones
December 10, 2001 at 3:23 pm
I also hate Globals. Cause problems and make bad solutions. What about doing the loops on the client and calculating there?
Steve Jones
December 10, 2001 at 3:22 pm
Sorry I don't have a spare server to "install" replication on. You might try installing another SQL copy, starting a complete trace, and then installing replication. You might snag a...
December 10, 2001 at 3:21 pm
Pesonally I hate temp tables, but I don't REFUSE them. I think peformance suffers. If he will not allow temp tables, then you could build a perm table and use...
December 10, 2001 at 3:16 pm
Not that I know of. Aliasing is the only way (other than changing the owner).
Steve Jones
December 10, 2001 at 3:13 pm
December 10, 2001 at 3:08 pm
December 10, 2001 at 3:06 pm
Not really. Most of the time will be building and tearing down the connection. If you can, use the same connection over and over.
We call a few dozen on some...
December 10, 2001 at 3:01 pm
Viewing 15 posts - 38,671 through 38,685 (of 39,456 total)