Temp tables will be automatically dropped when the connection that created them is closed. You don't have to (and in fact can't) manage the tables in TempDB directly.

2005 does cache...

There's no direct equivalent. SQL doesn't have the concept of a row's position in the table.

You can use row_number(), but you need to specify the ordering for the allocation of...

This one's pretty good. Read the comments on the blog post too, as the function needs a table creating.

http://philcart.blogspot.com/2007/06/split-function.html

I would imagine so. It's a cached plan with parameters, not much different from a stored proc.

Fixes would be the same as for a stored proc, use variables instead of...

Just bear in mind that SQL 2005 is not fully supported in any virtual environment. If you encounter a problems and call Customer Support, they will probably ask you to...

binaryspiral (10/3/2008)

---

Thank you for the detailed explination, although I'll appologize up front for still being a bit confused on where to start. My MS SQL skills are limited to the...

Depends how fast the table...

Does that username match the account that SQL agent runs as?

Most of the replication jobs run continually, rather than frequently starting and stopping.

First, run DBCC OPENTRAN and see if there's any reference to replicated and non-replicated transactions. If not, skip to the 3rd paragraph.

Drop any publication that may exist, and make sure...

Have you considered using the full-text search? It's one of the easier ways to do rating of matches.

You can read the transaction log raw if you like. It's not easy to understand though. Also it will only have up to the last log backup (in full recovery)...

There's no syntax errors with the function. The problem is how you're calling it.

... FROM [InfraDesk_ASP_3].[dbo].[RPT_nSLA_REPORT] ( 'All Priorities',1222799400,1225391399,null,null,('Software'),

('Client/Server Application',' Intel Engineering',' INTERNET'), ('Appliance',' Application'), ('')...

A history table that isn't mostly queried by date?

DNA (10/3/2008)

---

With mirroring the servers can be physically located near each other but they can also be at different sites. If they are at different sites this will protect...

I think part of that got cut off. (The forum software doesn't like triangular brackets)

From what I can see, all you need to do is change the definition of the...