Viewing 15 posts - 391 through 405 (of 821 total)
Luis Cazares (1/15/2014)
One more reason for me to avoid index query hints, unless it's completely necessary and throughly tested.
The focus of the question is "How are filtered indexes usefull?".
My answer...
January 16, 2014 at 1:17 am
I was surprised to see that the question instructs people to run the query first. Should that not have been "without running the query, ..."? (That's how I did it...
January 16, 2014 at 1:08 am
jchu 39760 (1/15/2014)
Could you please explain more details about the pass of query 4 and the fail of query 6?
The error 8622 is raised when you are searching a value...
January 15, 2014 at 3:50 am
sqlnaive (12/30/2013)
Thanks Steve and all for making the year wonderful and interactive with QOTD efforts. And a wish you a wonderful...
December 31, 2013 at 9:22 am
Hany Helmy (12/17/2013)
Nice & easy question, can be simply answered by just excluding the non-logic answers.
... or including the only possible!
😀
+1
December 18, 2013 at 1:35 am
Mr. Kapsicum (12/5/2013)
this is one feature that i am eagerly waiting,,, wanna try my hand out on this.😎
+1
December 6, 2013 at 5:48 am
Starting from sqlserver2008, you can declare and set a variable in one statement,
but you can NOT initialize a second variable with another inside the same declaration.
declare @a varchar= 'A'
,@b varchar=...
December 5, 2013 at 7:31 am
Pawel Borkowski (12/3/2013)
According to the explanation - I think that 3rd query shall be about table, not about index:WHERE i.name = 'Tab1'
No, it returns the filegroup for the index.
December 3, 2013 at 6:30 am
Koen Verbeeck (12/2/2013)
Evgeny (12/1/2013)
What is wrong with this answer?CREATE NONCLUSTERED INDEX IDX_A ON #temp1(a)
+1
Why is this answer "incorrect"?
Flawed question today, better luck next time 🙂
It's wrong because the optimizer...
December 2, 2013 at 12:55 am
steve.jacobs (11/30/2013)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/104494/">Order My Data</A>
OhiOhiOhi.
The only right answer is add a "order by clause" to the select statement.
Without the order by...
December 1, 2013 at 3:35 pm
Koen Verbeeck (11/18/2013)
The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed...
November 19, 2013 at 2:04 am
Viewing 15 posts - 391 through 405 (of 821 total)