Viewing 15 posts - 961 through 975 (of 2,647 total)
Putts (5/9/2012)
SQLKnowItAll (5/9/2012)
We want to create a virtualization within our database to reflect the makeup of a class in code ... what is better for this? A View or...
May 9, 2012 at 1:48 pm
Putts (5/9/2012)
SQLKnowItAll (5/9/2012)
May 9, 2012 at 1:46 pm
We want to create a virtualization within our database to reflect the makeup of a class in code ... what is better for this? A View or a Table-valued...
May 9, 2012 at 1:41 pm
GilaMonster (5/9/2012)
SQLKnowItAll (5/9/2012)
Maybe you missed the post in which Gail said that using a table-valued UDF causes a table scan every time.
I have never said such a thing because...
May 9, 2012 at 1:34 pm
Putts (5/9/2012)
SQLKnowItAll (5/9/2012)
May 9, 2012 at 1:33 pm
Putts (5/9/2012)
What is the point of a table-valued UDF if not to return a resultset? Is that not the same...
May 9, 2012 at 1:24 pm
I think the "real" problem here, that you are avoiding, is that the database schema keeps changing. If it was designed properly to begin with, you would only have...
May 9, 2012 at 1:17 pm
Putts (5/9/2012)
GilaMonster (5/9/2012)
Putts (5/9/2012)
Any change to the table then forces you to refresh all your SPs.
Not at all. The only time that a procedure will need refreshing if...
May 9, 2012 at 1:13 pm
There's really no justification for hitting the table directly.
That makes no sense. There's really no justification for hitting the table indirectly.
Any change to the table then forces you to refresh...
May 9, 2012 at 12:52 pm
No matter if you reference all the fields explicitly from ViewX in your SP or just simply do a SELECT * FROM ViewX, you will be forced to refresh those...
May 9, 2012 at 12:05 pm
You could set up replication from server a to server b, move application to point to server b, verify no more traffic to server a, take server a offline. That's...
May 1, 2012 at 2:54 pm
Yes it is possible.
May 1, 2012 at 12:05 pm
Pam Brisjar (4/26/2012)
SQLKnowItAll (4/26/2012)
Pam Brisjar (4/26/2012)
April 26, 2012 at 5:17 pm
Pam Brisjar (4/26/2012)
I have a side by side install (2005 and 2008) as noted above. But yeah, I suspect it felt it was "helping" me as I had 2005 installed.
Just...
April 26, 2012 at 5:09 pm
Pam Brisjar (4/26/2012)
Yup, that did it.Now why in the world would they do something like that...
Oy.
Maybe you upgraded instead of a fresh install?Just shooting in the dark...
April 26, 2012 at 2:15 pm
Viewing 15 posts - 961 through 975 (of 2,647 total)