Thanks for the question.

Here is an article just went live today. I would have posted sooner but the article was scheduled for today 😉

http://jasonbrimhall.info/2012/03/07/physical-or-virtual/

http://msdn.microsoft.com/en-us/library/ms345408.aspx

My bad. I didn't understand that to be the actual view definition since it said "something like this".

I was...

Nope, no need to restart when changing that setting.

sqlfriends (3/7/2012)

---

Thanks, for our case it is not a schema bound view, and if I use select column names, it has to explictily list 40 columns, I just think if...

Leeland (3/7/2012)

---

I am not that familiar with the fuction filtered indexes (I will be reading up on that after...

Lowell (3/7/2012)

---

also, you'd get an error if you try to use * and also schemabind a view:

CREATE VIEW v_YOURTABLE

WITH SCHEMABINDING

AS

SELECT * FROM YOURTABLE

Msg 1054, Level 15, State 6,...

Echo

Some of the SQL binaries and components must be installed on the system drive. You can redirect some of the program install, but not all of it. I...

That's all fine and well that the person running it might know what they are doing. But if they don't let you evaluate the query and tune it how...

Will you update the old style join from this:

FROM PS_PAY_CHECK C,

PS_PAY_DEDUCTION D,

PS_BN_SNAP_JOB J

To the new style where Inner Join blah on something...

I like to use Red Gate SQL Compare.

Another that I have used on occassion is dbdiff ( http://dbdiff.codeplex.com/ ).

Please repost the execution plan as outlined in this article by Gail Shaw:

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

crookj (3/7/2012)

---

Ditto! Indy has lost one of the few superstars that actually has class. Best wishes for him.

His...

The DBA in me says to keep it restricted. Then whenever they have one of these queries run amok you will find out about it.

Is this a dev server...