Viewing 15 posts - 31 through 45 (of 219 total)
jeff.mason (6/23/2012)
The only possible indexes might be a byproduct of primary key creation, and otherwise indexes are NOT supported.
This is incorrect, because unique indexes are supported too.
declare @Tmp...
June 24, 2012 at 11:29 pm
Thanks for the question.
There is one thing not mentioned in the explanation, but very important to keep in mind: the INTERSECT statement and the SELECT #4 do not always return...
June 19, 2012 at 12:29 am
This is a good idea for QOD, unfortunately the QOD itself was ruined by a syntax error. The REPAIR_FAST argument cannot be used without a database name or ID.
http://msdn.microsoft.com/en-us/library/ms176064.aspx
DBCC CHECKDB...
June 15, 2012 at 1:01 am
...zero zero colon zero zero colon zero zero point zero zero zero zero zero zero zero... 🙂
Nice question anyway.
June 6, 2012 at 12:20 am
reema.m
A DataSet will be serialized only into xml irrespective of the formatter which is used.
It was true only for .NET 1.x.
In .NET 2.0 (introduced in 2005 – seven years ago!)...
May 2, 2012 at 1:29 am
Carlo Romagnano (3/21/2012)
Is there difference between SOME and ANY?Can someone explain?
There is no difference. http://msdn.microsoft.com/en-us/library/ms175064.aspx:
SOME and ANY are equivalent.
March 21, 2012 at 2:26 am
Nice question, although the 'explanation' is confusing and does not explain anything.
To find the real cause of the observed behavior, we can do a simple conversion. The statement
s.Stat NOT IN...
March 1, 2012 at 12:38 am
Hugo Kornelis (2/6/2012)
Stewart "Arturius" Campbell (2/6/2012)
A TRUNCATE can be rolled back in Oracle as well....
I've never used Oracle, so I can't speak from experience - but the official Oracle documentation...
February 6, 2012 at 1:52 am
Hugo Kornelis (2/6/2012)
And 34% of them are for "you can never rollback a truncate table statement"
Maybe they are Oracle refugees? :hehe: http://qa.sqlservercentral.com/articles/Raw+Materials/71108/
February 6, 2012 at 1:22 am
Explanation
there is no documentation on a non-existant concern
I disagree. Here is the link: http://msdn.microsoft.com/en-us/library/ms191544.aspx
Transact-SQL Statements Allowed in Transactions
You can use all Transact-SQL statements in an explicit transaction, except for the...
February 5, 2012 at 11:25 pm
LutzM (1/23/2012)
January 23, 2012 at 9:56 pm
Hugo Kornelis (12/15/2011)
I did not run sp_lock, so I don't know what kinds of locks are involved in this case.
spid = 58
dbid = 7
ObjId = 0
IndId = 0
Type = DB
Resource...
December 21, 2011 at 10:57 pm
Nice tricky question with stupid 'explanation'.
Of course, the string (not datetime) '2011-07-31 00:00:00.000' is greater than the other string '2011-07-31', and thus the result of the batch is 'No'.
November 27, 2011 at 9:41 pm
Explanation
The sum(1) returns exactly the same as count(*).
This is incorrect as Jostein already explained.
Explanation
Both have the same execution plan as well.
This is incorrect too. Execute the following script and you...
November 21, 2011 at 9:53 pm
Viewing 15 posts - 31 through 45 (of 219 total)