Viewing 15 posts - 38,686 through 38,700 (of 39,466 total)
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
Haven't seen it, but it looks like replication is looking for that account. Can you create it on the remote system? It's setup on my system as a system admin.
Steve...
December 10, 2001 at 2:56 pm
December 10, 2001 at 12:17 pm
I scripted out the indexes and did a Search and replace in QA to get down to
"INDEX [Addr_NDX1] ON [dbo].[Addr]([CityID], [StateID])"
I then Loaded this into a table and cleared...
December 10, 2001 at 12:16 pm
December 10, 2001 at 11:59 am
Not sure what a "Function Index" is.
No real idea. Don't find anything on MSDN or Technet. Perhaps Oracle has some ideas?
Steve Jones
December 10, 2001 at 11:58 am
Viewing 15 posts - 38,686 through 38,700 (of 39,466 total)