Viewing 15 posts - 376 through 390 (of 819 total)
Good question!
Thanks!
create database DEFAULT_DATABASE
This runs!
create database DELETE
This DOESN'T run!
You can use reserved words that stand for OPTIONS!
February 20, 2014 at 1:18 am
Thomas Abraham (2/19/2014)
If you want numbers for your records in a SELECT, why not use:
ROW_NUMBER ( ) OVER ( <partition_by_clause> <order_by_clause> )
in...
February 19, 2014 at 7:24 am
SQLRNNR (2/19/2014)
I wonder how many people have used identity in this way (select into...).
Just one per year!
😉
February 19, 2014 at 1:25 am
twin.devil (2/14/2014)
now who said sql server does not have a heart 😛
+1
😛
February 14, 2014 at 1:02 am
I also found this doc from MSDN that explains the answer
SSAS2005PerfGuide.doc
February 2, 2014 at 12:03 pm
Koen Verbeeck (1/24/2014)
Great question and a very nice explanation.
+1
January 24, 2014 at 1:55 am
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
Viewing 15 posts - 376 through 390 (of 819 total)