Did you look in the Windows Event Log and SQL Server Error log? They should tell you why it won't start.

You need to figure out what is chewing up your plan cache. Looking for single use plans, etc. What did the plan cache look like on the old...

Write your query both ways and look at the execution plan.

It is best to use articles and/or advice on forums as guidance to figure things out and confirm stuff for...

Can you telnet to the SQL Server port over the router? Don't assume it is 1433. Check using SQL Server Configuration Manager. Beyond this, I would use...

The SQL Browser Service uses UDP 1434. This is commonly blocked at firewalls. Why do you need to discover the server using Browser? Can you connect directly...

There is not really enough information here. What type of activation? You say the transmission_queue is empty so I assume that means the destination queue is what is...

You can do everthing you want to in the data flow. Conditional split to separate the inserts and updates, and if you truly do need to do your updates...

Are you seeing difference in I/O or CPU Time? Duration is notoriously unreliable in these kinds of comparisons.

There is no downgrade path once your databases have been upgraded. If you want to do this, however you do it, you will need to "copy" the transactions from...

This should get you started. If you want to know the column to script it out you can use the parent_column_id and join to sys.columns.

SELECT OBJECT_NAME(parent_object_id) AS TableName, name...

rhythm.varshney (11/13/2012)

---

Yes, actually if you see my comments I mentioned that I am performing UPINSERT logic on the basis of staging table which hold around 50 K records daily basis.So...

Evil Kraig F (11/12/2012)

---

Right up until you need to sort data for aggregations or the like, I agree with you. When you need to do that, T-SQL tends to...

I agree with Jeff. Or for that matter since this is just in the select list, that scalar function can be turned into a case statement very easily.

rhythm.varshney (11/12/2012)

---

yes.I am importing the data to staging table as it is and there I am applying split on a column say name into first name and last name on...

So you are importing the column to your staging table in it's native format and then splitting it from there? On what basis are you splitting it (i.e. at...