Viewing 15 posts - 61 through 75 (of 521 total)
Good question, but the answer from MS is not really applicable, since we have a sub-query expression and not a TVF in the QTOD example.
The more verbose explanation is documented...
September 6, 2012 at 1:45 am
I thought I had 2 Choices:
12:18 AM - Full backup data reading of QotDDatabase ends
12:19 AM - Transaction 4 on QotDDatabase commits
12:19 AM - Full backup transaction log reading...
July 20, 2012 at 1:57 am
Very interesting QODT.
Here a little additional information that I find helpful:
1. The most important explanation from the Support Link:
When the DBCC CHECKDB statement detects a consistency error in the database,...
July 18, 2012 at 2:54 am
bitbucket-25253 (7/5/2012)
Correct answers:1%
(1)
Incorrect answers:
99%
(113)
Total attempts: 114
The 1 percent must come from the Author (or Steve, the point nicker):-P
July 5, 2012 at 6:27 am
Henrico Bekker (7/4/2012)
Don't see how a one answer question has 2 answers. Should be 10.
10 answers?!? 😛
July 5, 2012 at 6:24 am
deepty21 (6/25/2012)
I had read anarticle in SQLSERVERCENTRAL.com comparing table variables and temporary tables. It said that table variables cannot have named constraints. Primary Key doesn't comes under named constarints?????
Depends on...
June 25, 2012 at 3:16 am
Poorly worded question. There is no way for the reader to identify if the author meant implicit or explicit index creation. And the fact that both Primary Keys AND Indexes...
June 25, 2012 at 1:02 am
Hi Hugo,
I did test it, and the table constraint (not column constraint) gets created, even though there is no comma in between.
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)...
May 16, 2012 at 1:56 am
Hm, I am a little confused because of the missing comma before the CONSTRAINT declaration. That does not seem to be required based on a first test. But I checked...
May 16, 2012 at 1:42 am
sjdnfkwejhniof (3/7/2012)
====( http://www.fullmalls.com )=========( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
====( http://www.fullmalls.com )=====
Looks like there is a...
March 8, 2012 at 1:25 am
WayneS (1/19/2012)
this article only talks about the Analytic functions. You might want to look at my previous article The OVER Clause enhancements in SQL Server code named “Denali”, CTP3[/url].
Basically, the...
January 20, 2012 at 12:53 am
WayneS (1/18/2012)
Comments posted to this topic are about the item <A HREF="/articles/SQL+Server+2012/76704/">The new Analytic functions in SQL Server 2012</A>
Great information, thanks for that.
To me it was not clear immediately, what...
January 19, 2012 at 6:01 am
SQL Kiwi (1/18/2012)
The BOL entry for sys.all_objects says:"Shows the UNION of all schema-scoped user-defined objects and system objects."
Server-scoped DDL triggers are not schema-scoped.
Thanks, that makes sense.
January 18, 2012 at 7:13 am
I am not sure I understand the explanation.
I would expect to find a row for the trigger in sys.all_objects, if it is said to be stored as an "object" in...
January 18, 2012 at 1:45 am
Got it wrong because I did not see that EventID was the PK.
But to be honest, i don't agree with the explanation for why the last option is not...
December 27, 2011 at 1:57 am
Viewing 15 posts - 61 through 75 (of 521 total)