Viewing 15 posts - 166 through 180 (of 455 total)
sql Sarah (5/9/2014)
I changed A and B to temp tables and ran this. It returned 5 rows.How do you get 8 rows for the answer? :unsure:
TOP n WITH TIES...
May 9, 2014 at 8:50 am
Eirikur Eiriksson (5/6/2014)
According to Celko, "Machine-level things like a BIT or BYTE data type have no place in SQL."😎
This is why it's a very good thing Celko isn't the only...
May 6, 2014 at 7:40 am
Jeff Moden (5/5/2014)
May 6, 2014 at 7:31 am
Gobikannan (4/18/2014)
...If the settings are imported from SQL Server 2018 settings...
Well, that's what you get for time-travelling. 😛
April 18, 2014 at 6:33 am
I remembered hearing about this at PASS 2013, and remembered correctly!
Some interesting wrong choices, though!
April 17, 2014 at 8:08 am
This is a good start to an article, but it's more of an advertisement than a convincing argument. Why? It's all upside.
You don't acknowledge the costs of clustering: hardware, licensing,...
April 15, 2014 at 6:43 am
We're actively reviewing our licensing RIGHT NOW. So you pulled me in with this one. I should have realized it was fake, given that the links to the "new" licensing...
April 1, 2014 at 7:25 am
Stewart "Arturius" Campbell (3/24/2014)
Carlo Romagnano (3/24/2014)
Stewart "Arturius" Campbell (3/24/2014)
Interesting question, thanks Carlothought the lack of a semi-colon between deleted.* and COMMIT would cause an error.
Goes to show...
The lack of a...
March 24, 2014 at 12:43 pm
I haven't done any replication yet, so this is entirely based on the documentation, but it looks like none of the answers are correct. From the linked document:
For all types...
March 19, 2014 at 7:55 am
david.wright-948385 (2/12/2014)
Always add brackets when mixing operators. Even if you know the rules, brackets make a calculation less prone to misunderstanding.
Until you have several layers of brackets, at which point...
February 12, 2014 at 7:29 am
Fun question!
Although it doesn't change the answer, there is still some debate as to whether Rudolph is canon... 😛
December 25, 2013 at 11:16 am
SQLRNNR (11/13/2013)
Gary Varga (11/13/2013)
SQLRNNR (11/12/2013)
November 13, 2013 at 8:52 am
ronmoses (10/31/2013)
"TestWindowsUser is in a domain group that is a member of db_owner and...
October 31, 2013 at 6:48 am
Carlo Romagnano (10/1/2013)
sknox (10/1/2013)
Guessed optimistically.
Got it wrong.
Can anyone explain why this should still be around when CLR has been available to replace its...
October 1, 2013 at 8:21 am
Haven't had time to research SQL 2014 yet.
Guessed optimistically.
Got it wrong.
Can anyone explain why this should still be around when CLR has been available to replace its functionality since 2005?
October 1, 2013 at 7:35 am
Viewing 15 posts - 166 through 180 (of 455 total)