Viewing 15 posts - 2,386 through 2,400 (of 4,081 total)
I wonder if this might be related to some internal process within the ONLINE index build that expands the 'permanent' extra byte to a smallint through necessity. A small mismatch...
September 9, 2009 at 8:03 am
So we have several possibilities at least:
(1) The presence of the byte is itself a flag of some sort.
After all it DOES tell you whether an...
September 9, 2009 at 7:35 am
Another alternative is to rewrite your stored procedure as a table-valued function.
select * from dbo.tfn_YourFunction(parm1,parm2,parm3)
September 8, 2009 at 12:11 pm
EXISTS is true whenever any rows would be returned by the query. You should pair it with a subquery that has a where clause.
IF EXISTS (select 1...
September 8, 2009 at 12:02 pm
It can and will do just that when it decides that is the least amount of work. But remember, whenever you use an index and have to get...
September 8, 2009 at 11:14 am
Thanks so much for posting up sample data!! Applause!!
select E1.id,E1.Fname as Fname1, E2.Fname as Fname2, E1.Lname as Lname1, e2.Lname as Lname2
from Employee1 E1
join Employee2 E2 on E2.id =...
September 8, 2009 at 7:07 am
"Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, , >= .... "
You subquery is returning a set of values. ...
September 8, 2009 at 6:52 am
MY thread.. ?!? Just because I don't accept an execution plan for a table with 7 rows of data?
For the luvva small, fluffy bunnies....
September 8, 2009 at 6:40 am
SOM 😛
"For the love of small, fluffy bunnies?"
We're even on coffee for the day, Paul.
September 8, 2009 at 6:36 am
the most amazingly cross-purposed debate ever
Where did this take place?
September 8, 2009 at 6:12 am
Without commenting on the wisdom(?) of your approach, I will say that lists of values are tested using IN, not equals (=). Another method would...
September 8, 2009 at 6:11 am
Paul, does it add a new byte EVERY time? If you rebuild the same index 5 times, does it increase by 5 bytes? Or...
September 8, 2009 at 6:00 am
September 8, 2009 at 5:53 am
Viewing 15 posts - 2,386 through 2,400 (of 4,081 total)