Viewing 15 posts - 886 through 900 (of 10,144 total)
For testing I have created a table with a clustered index selecting all columns...
March 7, 2017 at 8:36 am
I hear the "couple" one far too often. A couple is two.
Actually, "a couple" is...
March 6, 2017 at 4:33 am
March 2, 2017 at 10:18 am
Combine the tally table with
March 1, 2017 at 8:10 am
Luis, how are you getting your code to format nicely? Until a couple of days ago, I was copying from SSMS to a text file then into here - but...
March 1, 2017 at 7:48 am
March 1, 2017 at 5:31 am
-- Give a fast streaming aggregate a chance:
CREATE INDEX ix_Stuff ON tblDE (ANNEE, APE, A64, A38,A21,A10, ART) INCLUDE...
February 28, 2017 at 6:27 am
-- If two rows don't have at least one column value in common, then you can't reliably
-- assume that they are the same person.
-- Choose an...
February 21, 2017 at 7:42 am
Nice, Sergiy, and very useful.
I'm guessing that you've checked out all of the alternatives to get rid of the row count spool. I've only had a little time...
February 17, 2017 at 9:38 am
Jeff Moden - Wednesday, February 15, 2017 10:37 PM
The posted data won't load. It's missing quotes.
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near '.1'.
Msg...
February 16, 2017 at 2:10 am
The n is just a placeholder, and in fact for multiple occurrences of the keyword you'd need TOP(1) n. To get around this, you could also use EXISTS like this:
February 15, 2017 at 8:10 am
Viewing 15 posts - 886 through 900 (of 10,144 total)