Deadlocks aren't necessarily due to performance. You can have the fastest performing system in the world and still have deadlocks. Poorly written applications can cause quite a few. See...

You'll have to provide the full xml file since the sample snippet you provided in your initial post works fine once I add the end tags. There's really not...

You'll have to modify the package in BIDS and put an expression into the ExcelFilepath property in your connection to dynamically change the filepath at runtime. The below expression...

Looks like someone got it to work. Here's the link.

I had similar issues trying to link an Access database to the sql server.

http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/MSSQLServer/ace

It looks fine to me. All the elements seem to be there. Not sure what you mean by missing XML format.

If you're referring to not being laid out in neat...

Can you provide scripts for the partition scheme and function.

I think what you're wanting to do is a split and not a switch but I can be wrong here.

I've forgotten...

Is most of the stuff being run SP's or adhoc?

I'd start with a DBCC Freeproccache, that should be the easiest

then do a sp_updatestats

rebuilding indexes might take a while...

examine the exec...

SSIS package? Have a table with list of .sql files to run and have a loop container to run each?

I think the easiest would be to create a new partition function and move the table to that new function. I'm assuming you want to move the whole table which...

Running the upgrade advisor is a start.

Did the same thing 2005 to 2008 cluster. The virtual server names doesn't matter since it's just a DNS change it's the instance name that matters. The only...

Thanks I don't have permission to run that script but I'll see if I can get someone to tell me or run it.

Most of my performance issues where related to Disk I/O. That many DB's on 2 data drives seem excessive. On very busy databases we usually have 2 or 3...

This would be so much easier in VB or C#...

Well it's not pretty and not sure if the parameter you pass in is going to be pretty but here goes...

I...

dilipd006 (11/29/2012)

---

Thanks dave

Is there any performance issue if i create Filterindex for each AlternateCityName column.

I want to load thi city in a text box while typing the characters.If i i...