quote:

---

This link might also help you

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=16321

Frank

http://www.insidesql.de

---

That method has a...

If Table B is to start out empty, then you could truncate it, drop it and then use a SELECT statement rather than INSERT:

SELECT Field1, Field2,...

If there isn't one, put a nonclustered index on just Site_Id. I don't think you'll find a faster way to do this than what you're already using, unless you...

quote:

---

I have 2 highly transactional DBs, 1 reporting DB, and 2 not so big DBs. They are used by a web application...

That's what UNION (as opposed to UNION ALL) is for.

--Jonathan

quote:

---

Thank you guys for your input.

One more question, for the web hosting purposes ONLY, do I need Processor Licensing & Internet Connector...

http://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_dwdesign.asp

--Jonathan

quote:

---

These are the bits I use in either sp or udf, I did have a calculate bit I built but cannot find...

quote:

---

quote:

---

(HP Master ASE-SQL Server)

---

as for acronyms, what...

Hiring a consultant knowledgeable in SQL Server design can be a very good idea.

--Jonathan (HP Master ASE-SQL Server )

quote:

---

<*grin*>I know!

Excel is bread and butter to my daily work.

No need to do some VBA in Excel. Functionality is already there when...

quote:

---

With 20 CAL's, you can only have 20 concurrent users. For a webserver, one user can be compared to a single session...

The duration (and i/o count) for a disconnect event is for the entire time the connection was alive. You're probably using connection pooling (the default), so the connections are...

quote:

---

AFAIK table variables are 'real' tables in tempdb.

Frank

http://www.insidesql.de

---

They're not subject to transaction logging to disk,...