Ya, the other solution is to create a little function in the code section. That way you have something reusable.

usually code makes things slower, but for sanity's sake... 😉

Martin Schoombee (9/21/2011)

---

I found the following: http://blog.summitcloud.com/2010/05/disable-reporting-services-data-cache-in-development/

Seems like Visual Studio has a config file for the Report Designer. I've made the change on my side, and it seems to be...

Raymond van Laake (9/21/2011)

---

The only thing I can think of is making the synonym name different per user (so if your employeenumber is "23", your synonym will be "T23").... meaning...

The real short answer here is :

Why = Pourquoi

What for = Pour <space> quoi.

In the case of your sig, it's definitely 1 word.

The problem with ssrs is that all 3 parts of the IIF are calculated BEFORE the iif actually starts.

What do you need to do exactly?

Raymond van Laake (9/21/2011)

---

Boooh!!

One thing I see now is that the synonym is database-wide. Meaning, if I am running a query using synonym T, my colleague can't do a thing...

So true, tho weirdly it's almost a synonym in...

--Before changing the query, there was this missing index in the plan

--I'm not 100% sure it would be the best after the change,

--I would try both version, #1...

I don't see how it avoids anything.

You still have to know which object to call. Which you'll still know exactly at the same time.

You'll still have to use a...

So after you finally hit F5 you can try finding to other 2-3 possible outputs

http://www.sqlservercentral.com/Forums/Topic908285-1198-1.aspx

GilaMonster (9/21/2011)

---

Ninja's_RGR'us (9/21/2011)

---

senfriends2008 (9/21/2011)

---

i have one exprience in my office!

Daily five or six time deadlock accurse on production server. We optimize program coding also still getting deadlock. so...

You want to setup an sql alert for a window error???

See the dis-connect here???

Log the errors in the front end, in the sql logs and go from there.

If...

senfriends2008 (9/21/2011)

---

i have one exprience in my office!

Daily five or six time deadlock accurse on production server. We optimize program coding also still getting deadlock. so resarch morethen...

hint #3, aside from hitting F5 is what can stop this from running correctly or at all.

It adds some overhead but nothing majorly noticable.

I use this to death in my reports and there's no real difference (onec I can have a seek and / or at...