Viewing 15 posts - 391 through 405 (of 825 total)
Andy Warren (1/22/2014)
Comments posted to this topic are about the item <A HREF="/questions/Security/105935/">I No Longer Have Access to My DB and I'm a DBCreator!</A>
Easy one! Thanks!
😀
January 23, 2014 at 2:13 am
sneumersky (1/17/2014)
January 17, 2014 at 9:50 am
Sean Pearce (1/17/2014)
Hugo Kornelis (1/16/2014)
Carlo Romagnano (1/16/2014)
The focus of the question is "How are filtered indexes usefull?".My answer is "They are not so usefull as Indexed view".
Isn't this like saying...
January 17, 2014 at 6:09 am
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
Viewing 15 posts - 391 through 405 (of 825 total)