Viewing 15 posts - 1,441 through 1,455 (of 3,348 total)
doug.davidson (11/18/2014)
Still trying figure out what the point of this feature is suppose to help with.
The "ascending key problem" is a well-known problem related to stale statistics on dynamic data.
Consider...
November 18, 2014 at 1:53 pm
navneet.agarwal19 (11/17/2014)
F1 full backup
T1 Log Backup
D1 Differential Backup
T2 Log Backup
D2 Differential Backup
T3 Log Backup
F2 full backup
T4 Log Backup
D3 Differential Backup
T5 Log Backup
D4 Differential Backup
T6 Log...
November 17, 2014 at 12:53 pm
Rune Bivrin (11/14/2014)
Minimum:
Express Editions: 512 MB
All other editions: 1 GB
Recommended:
Express Editions: 1 GB
All other editions: At least 4 GB and should be increased as database size increases to ensure optimal...
November 16, 2014 at 4:02 pm
Luis Cazares (11/12/2014)
It's all fun and games until we find an employee with a NULL value in its name.
A NULL in the QOTD table would in this case not be...
November 13, 2014 at 3:31 pm
chgn01 (11/12/2014)
http://use-the-index-luke.com/sql/partial-results/top-n-queries
I think "Order By" just do for "Top (n)" rows not...
November 13, 2014 at 3:24 pm
Sean Lange (11/11/2014)
chgn01 (11/11/2014)
November 11, 2014 at 5:18 pm
jdauphine (11/4/2014)
Interesting. will 0 in ('foo','bar') use indexes?
Since 0, 'foo' and 'bar' are all constant values, it will not. I didn't run it, but I expect an error because of...
November 11, 2014 at 5:04 pm
Koen Verbeeck (10/28/2014)
serg-52 (10/28/2014)
"only one null " is someway misleading. Precisley it's a "only one null value per column".If the unique index is not a filtered index 😉
The question was...
October 28, 2014 at 1:58 am
rfreiberg001 (10/27/2014)
I'm getting the same results when using your code to insert the data. I'm returning 9 rows.
Nine rows sounds right, since there is no GROUP BY. But those nine...
October 27, 2014 at 4:26 pm
Nice reminder. I had actually completely forgotten that this function exists. (Perhaps for good reasons?)
If "syntax error, no such function exists" had been included in the answer options, I might...
October 27, 2014 at 12:19 pm
tom.w.brannon (10/24/2014)
October 24, 2014 at 11:31 am
SQL-DBA-01 (10/5/2014)Can you explain why the correct answer choice is 2??
The way this site works is that you need to give an ansnwer to get access to the explanation and...
October 5, 2014 at 7:10 am
Meow Now (10/3/2014)
Interesting...I have never used SET ROWCOUNT or seen it used anywhere before. G.I. JOE!!
That's actually a good thing; please don't get into the habit of using it...
October 3, 2014 at 3:01 pm
TomThomson (10/1/2014)
Toreador (10/1/2014)
October 1, 2014 at 4:55 pm
Toreador (9/30/2014)
Hugo Kornelis (9/30/2014)
Me,...
September 30, 2014 at 10:27 am
Viewing 15 posts - 1,441 through 1,455 (of 3,348 total)