Viewing 15 posts - 1,546 through 1,560 (of 3,348 total)
L' Eomot Inversé (1/24/2014)
Yes, but how is release of the log records prevented?
My guess is that the information on that page you used is incorrect. But I have never worked...
January 24, 2014 at 11:55 am
L' Eomot Inversé (1/23/2014)
January 23, 2014 at 1:22 pm
Can anyone explain to me why the script runs without error on my system, every time I try it?
The only things I changed are:
* Change "localost" to "perFact\SQL2012" in the...
January 23, 2014 at 1:19 pm
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 12:12 pm
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 that cars are more...
January 16, 2014 at 11:13 am
jchu 39760 (1/15/2014)
Could you please explain more details about the pass of query 4 and the fail of query 6?
Query 2 (I know, you didn't ask) fails because you search...
January 15, 2014 at 12:02 pm
It took me a lot of time to find the correct answer for this one. I knew the two index types - but under different names ("hash" and "range"). Most...
December 30, 2013 at 11:55 am
L' Eomot Inversé (12/29/2013)
I always wonder why SQL Server behaves this way, though; it seems pretty bizarre, and doesn't seem useful.
My guess - one day, someone discovered that the way...
December 30, 2013 at 11:46 am
In all honesty - I do not like this question.
"Which of these operators creates a cursor" - define cursor?
The dictionary gives me two meanings, neither of which is appropriate here:...
December 24, 2013 at 3:25 pm
Revenant (12/21/2013)
Hugo Kornelis (12/21/2013)
So how exactly does one "aggregate (...) those rows that had been processed BEFORE the current row" with LAG? . . .
Not sure why you post that...
December 21, 2013 at 9:34 am
So how exactly does one "aggregate (...) those rows that had been processed BEFORE the current row" with LAG?
(I emphasized two important words in that quote from the question -...
December 21, 2013 at 5:18 am
marcia.j.wilson (12/9/2013)
Any examples of how these would be used?
Running totals. Traditionally done with slow set-based code, with a (relatively!) fast cursor, or with some dangerous unsupported side effect of a...
December 9, 2013 at 2:18 pm
Ed Wagner (12/6/2013)
1. How are the transaction logs stored? If they aren't written to disk, we'll...
December 6, 2013 at 2:26 pm
Stewart "Arturius" Campbell (12/4/2013)
Kept thinking - "Where's the catch"
The catch is that there are actually many components that you can edit without having an active connection to the source. People...
December 4, 2013 at 12:07 pm
L' Eomot Inversé (12/1/2013)
So, [] is a character, and so is [^]? :w00t: That's quite an amazing misuse of English!
This isn't an English exam, it's a question about...
December 1, 2013 at 7:27 am
Viewing 15 posts - 1,546 through 1,560 (of 3,348 total)