Viewing 15 posts - 3,241 through 3,255 (of 3,348 total)
sho (1/9/2008)
Whats this??!!
I had no idea this was needed... is this new to SQL2005?
And just to be absolutly sure, everytime a table used in a view changes (ie column added/deleted)...
January 9, 2008 at 1:59 am
peterhe (1/4/2008)
January 4, 2008 at 7:22 am
Hi Peter,
It's a nice theory, but unfortunately (or maybe I should say: fortunately), completely incorrect.
IF NOT EXISTS(SELECT 1 FROM sys.server_principals b
WHERE b.sid=(SELECT [sid] FROM sys.databases a WHERE a.name=DB_NAME()))
The...
January 2, 2008 at 2:19 am
The "correct" answer is wrong. TRUNCATE TABLE takes page and table locks, but it also needs a database lock. Otherwise, I would be able to truncate a table from one...
December 21, 2007 at 2:36 am
Mark Powell (12/20/2007)
Can anyone justify the official answer as to why it is right and the first choice was wrong?
Hi Mark,
The first choice was not wrong, it was incomplete. The...
December 21, 2007 at 2:26 am
Steve Jones - Editor (12/13/2007)
So do you take a chance that you'll be fired if the CIO finds out and it's a legitimate use?
If a company fires me for not...
December 14, 2007 at 3:09 am
Andrew Fitzgerald (12/13/2007)
MS On-line help for SQL lists three Types of DML triggers: After, Instead of and CLR.
Tempted as I now am to submit a documentation bug report, I can't...
December 13, 2007 at 1:18 pm
Andrew Fitzgerald (12/13/2007)Since CLR is present in the DML language the correct answer based on the way the question is written is three.
Hi Andrew -- and everyone who has posted...
December 13, 2007 at 9:15 am
Hi all,
I'll have to disagree with the many objections and agree with the original question (now that is uncommon for me!). Though the explanation is confusing, misleading, and maybe even...
December 13, 2007 at 2:45 am
<nitpicking>
Especially in a question in the design and theory category, I'd prefer the answer to use the proper term "attribute" or "column" rather than "field".
</nitpicking>
Otherwise, a good question. I never...
December 3, 2007 at 1:32 am
Michael Kipp (11/21/2007)
Here is the information concerning AS 2005: http://msdn2.microsoft.com/en-us/library/ms174750.aspx
Thanks, Michael!
November 21, 2007 at 6:32 am
The question is about "AS2005". But the article that the explanation refers to is clearly marked as refering to "Analysis Services (SQL Server 2000)".
Can someone point me to a source...
November 21, 2007 at 1:55 am
jishar (11/14/2007)
I answered it as NTFS.... but this system shows as my answer is wrong... Microsoft is strongly recommending to place files on NTFS
That is indeed the recommendation, but the...
November 14, 2007 at 2:44 am
The answer is incorrect. Locating files on NTFS and FAT partitions may be recommended, but SQL Server can locate database files on RAW and NFS as well.
Jacob already posted a...
November 14, 2007 at 1:11 am
Hugo Kornelis (10/30/2007)
The resource could not be found
Sorry, we could not find the resource...
November 1, 2007 at 2:49 am
Viewing 15 posts - 3,241 through 3,255 (of 3,348 total)