To really help you we will need DDL (CREATE TABLE statement) for the table(s) involved, sample data (series of INSERT INTO statements) for the table(s), expected results based onthe sample...

Instead of using the 4-part naming directly in your development, why not create synonyms that use the four part naming so that your development efforts look like you are using...

capn.hector (4/6/2012)

---

thats one way but an inefficient way. all the cte's will be compiled into a single query by the optimizer but may not achieve the optimal plan if...

Multiple table joins, sorting are two activities that may create work tables in tempdb.

Here is what I would do, check with Microsoft. If you have purchased the appropriate licenses for the Developer Edition for your development and testing environment and the proper...

Sounds like you are using a linked server. If you provide the query you are currently using we may be able to show you how to improve its performance....

Trick question. If this is the data/time a record is inserted, why not leave it out of the MERGE entirely and set a default constraint value for the current...

Can you verify the settings on the servers that are working. The error message indicates that the mail server is not setup to accept ssl connections and you are...

Try copying the file using Robocopy and see if it verifies okay on the destination server.

Hard to say, you have only given us part of the picture. We need the whole picture. DDL (CREATE TABLE statement), sample data (INSERT INTO statements), expected results,...

PaulB-TheOneAndOnly (4/6/2012)

---

When using four-part naming query uses to transfer whole tables over the network from remote to local server, then apply filtering in local server - that's why it takes...

TravisDBA (4/6/2012)

---

We strictly handle SQL Server support. No Access, no applications, just SQL Server. We have well over 100 instances of SQL Server to administrate spread throughout the state...

That's nice....

Have you run the RESTORE VERIFYONLY on the files on your SQL Server 2005 system?

When was the last time you ran checkdb?

Yes, partitioning can provide performance benefits. The question is, however, will partitioning benefit the queries that are being run? You really need to look at the queries and...