Viewing 15 posts - 16 through 30 (of 148 total)
June 14, 2017 at 9:30 am
June 13, 2017 at 3:09 pm
June 13, 2017 at 2:42 pm
I would question the need to make the indexed view unique. Is a regular indexed view not enough?
My biggest concern is when you attempt to insert a record...
May 26, 2017 at 3:26 pm
May 26, 2017 at 3:18 pm
The first and second result sets are likely to always be different. Changing your UNION to a UNION ALL will save you some server resources. If you are trying to...
May 26, 2017 at 3:09 pm
Ex. User "RB" logs into database and lands on schema "Sales", as configured by...
April 18, 2017 at 8:08 am
2) Is there any concept of Collections...
April 11, 2017 at 2:51 pm
DECLARE @Col1...
April 11, 2017 at 2:17 pm
I don't see any need to move description into a separate table just because of a columnstore index.
I agree that the description should not be in the fact;...
April 11, 2017 at 1:59 pm
March 28, 2017 at 3:16 pm
Tbl3 is a...
March 28, 2017 at 3:11 pm
March 8, 2017 at 3:00 pm
Jeff Moden - Wednesday, March 8, 2017 2:20 PMMy biggest PO is when someone tries to make a column name like "IsNotActive".
and...
March 8, 2017 at 2:42 pm
OLTP to me implies insert, update and deletes. Updates and Deletes kill a columnstore pretty quickly, requiring the index to be rebuilt. With a clustered columnstore (CCI), your table is...
March 8, 2017 at 12:41 pm
Viewing 15 posts - 16 through 30 (of 148 total)