I wonder if Plan Guides would be useful here. Theoretically you could override the plan the Optimizer would use for that specific query text and that plan could be one...

sqlnaive (8/11/2011)

---

Thanks opc. I was going through Policy based management and found it pretty interesting. To solve this default schema issue, is it fine to create a condition with field...

Sounds like a good starting point to me. Some things to evaluate:

- Consider fully-qualifying all object references from your application. It is a best practice from a readability standpoint and...

sqlnaive (8/10/2011)

---

Then how can i manage to enforce dbo schema across my environment where hundreds of users are going to hit database sooner or later, each having created their default...

From Remarks section http://technet.microsoft.com/en-us/library/ms173463.aspx:

Steve.Cornelius (8/9/2011)

---

Please don't assign such petty motivations to me. I'm not one of these shallow idiots...

Eureka! Thanks for posting back. That sounds a little like black magic 🙂 Have you been able to validate that the ID does not change through saving/importing/exporting the package? I...

SQL_Developer (8/4/2011)

---

Thank you so much for your sample code and looking into it.

What I am looking to do is not to change the Table Valued Parameter every time. With your...

I would have to disagree Ninja's. This article explains...

Option 1: Change to a columnar structure in the database.

Reporting will be a pain but the data can always be flattened later. Weigh the effort required to flatten data in...

Impedance Mismatch! Can you change to an EAV data model in the database, or some other type of columnar model?

If you're stuck with the data model I may have something...

stewartc-708166 (8/3/2011)

---

There are more efficient ways of transferring data between 2 SQL servers than using BCP out and in.

One option is to create a linked server on serverB that...

MuraliKrishnan1980 (8/3/2011)

---

Hello Friends,

Thanks for your response. Yeah, i know that we can achieve this using other options as well. However, i would like to know if there is an option...

Million dollar question: Is there a requirement to avoid application code changes when you add column #401 to your table?

Per this article a stored procedure can have up to 2,100...

Yeah, too little info to say on the whole system so I made some leaps. But it's OK...I only jumped in to steer this one away from using Dynamic SQL...