Viewing 15 posts - 1,381 through 1,395 (of 3,348 total)
From the explanation:
(there isn't any good reason for this, as the target of the foreign key isn't in a temp table, but for some reason temp tables are not allowed...
March 17, 2015 at 5:20 am
bill-kline (2/25/2015)
Has the Database Tuning Advisor been updated to potentially recommend columstore indexes?
No.
February 25, 2015 at 4:34 pm
Sean Woehrle (2/25/2015)
This is a great article. Just FYI we skipped over 2012 for column store indexes since we didn't want to drop and rebuild the indexes...
February 25, 2015 at 8:53 am
mwpowellhtx (2/20/2015)
So in the instance of execution plans, its not truly columnless table, but rather rowless table (view, etc). i.e. for outer joins...
No, no, you misunderstand. A rowless table is...
February 20, 2015 at 5:48 am
Raghavendra Mudugal (2/13/2015)
(so, 63 people thought that they can create a table with no cols; if this becomes real, I am not sure...
February 20, 2015 at 3:48 am
Charles Kincaid (2/4/2015)
February 4, 2015 at 1:39 pm
Based on how database snapshots work, it was obvious that this had to be one of the restrictions. That immediately narrowed my options down to just one choice.
February 3, 2015 at 10:24 am
To all the people who responded that they are happy to have learned the SOME operator ... please unlearn it, as soon as possilble.
Every expression with SOME (and its companions...
February 1, 2015 at 3:58 am
Sean Lange (1/27/2015)
Luis Cazares (1/27/2015)
Carlo Romagnano (1/27/2015)
Raghavendra Mudugal (1/27/2015)
Carlo Romagnano (1/27/2015)
Strange, but the version with PIVOT is a bit slower than that with GROUP BY. See execution plan!...
actually I...
January 28, 2015 at 11:48 am
Raghavendra Mudugal (1/26/2015)
Row filters in transactional publications can add significant overhead because the article filter clause is evaluated for each log row...
January 26, 2015 at 12:30 pm
DTML (1/25/2015)
January 25, 2015 at 1:54 pm
DTML (1/23/2015)
a) I ran the CREATE TABLE script as it is in the QoD and...
January 23, 2015 at 3:19 pm
g.britton (1/23/2015)
So, long story short:
1. Looking at an execution plan is not a good way to draw conclusions on the meaning of SQL language elements. They are defined in the...
January 23, 2015 at 7:53 am
g.britton (1/23/2015)
You're guessing and hoping you are right, but you are wrong. The execution plan proves it.
In SQL, you need to make a distinction between the definition of the language,...
January 23, 2015 at 6:33 am
pmadhavapeddi22 (1/23/2015)
The statement could have given the result like (count of all...
January 23, 2015 at 6:09 am
Viewing 15 posts - 1,381 through 1,395 (of 3,348 total)