Forum Replies Created

Viewing 15 posts - 76 through 90 (of 521 total)

  • RE: Concurrent Operations

    Hi,

    This QOTD may not be as clear as it seems.

    While you (as asked in the question) can certainly run 2 of these backups at the same time without getting an...

    December 15, 2011 at 1:24 am

    #1421768

  • RE: Using SP_

    Koen Verbeeck (12/14/2011)

    Great question!

    I have a question:

    why doesn't the second 'drop table' statement drop the table in the master database?

    Won't the statement look for the table in the master database,...

    December 14, 2011 at 12:43 am

    #1421050

  • RE: Variant Order 3

    john.arnott (12/12/2011)

    So nearly two-thirds of respondants so far are smarter than I. They wouldn't have just run the code and clicked the corresponding option now, would they?

    Well, you...

    December 13, 2011 at 12:48 am

    #1420392

  • RE: Variant Order 3

    L' Eomot Inversé (12/12/2011)

    What's the most important use of SQL_VARIANT order? Well, in my experience its main use is in generating T-SQL trivia questions for use as QotD -...

    December 13, 2011 at 12:41 am

    #1420387

  • RE: Variant Order 3

    I liked the first question in the series, but I did not really need the follow-ups.

    The first question already taught me to never ever consider order by SQL_VARIANT columns.

    Maybe I...

    December 12, 2011 at 7:21 am

    #1420067

  • RE: Maximum number of Databases.

    Why not in prod?

    Don't you have 82 GB left for 32,767 empty Databases? 😉

    I tried it with 1001 though (on my local machine of course!) and at these 1001 DBs...

    December 8, 2011 at 1:16 am

    #1418509

  • RE: The Right Kind Of Join III

    Very nice question series. By the way, you could make the query fail using

    SET FORCEPLAN ON

    as well.

    September 8, 2011 at 12:46 am

    #1378377

  • RE: system stored procecures

    elbedata (8/23/2011)

    It returns "that" when I test on SQL Server 2008, but I thought it should return "this"...

    Has this changed in later SQL versions? I am pretty sure I've learned...

    August 23, 2011 at 1:11 am

    #1371787

  • RE: system stored procecures

    kapfundestanley (8/23/2011)

    The answer is syntax error why should we assume the database test2 exist when it does not?

    The fact that test2 does not exist is not a syntax error.

    August 23, 2011 at 12:59 am

    #1371784

  • RE: T-SQL

    pksutha (3/23/2011)

    Hi Gopi,

    select * into TestTable from

    (

    select CAST(1 as smallint) as C1, CAST(6 as smallint) as C2

    union

    select CAST(2 as tinyint),CAST(6 as int)

    union

    select CAST(3 as bigint),CAST(6 as smallint)

    union

    select CAST(4 as int),CAST(6...

    August 8, 2011 at 1:03 am

    #1365039

  • RE: Exists

    SQLkiwi (8/2/2011)

    deepak.a (8/2/2011)

    Even for the below statement also

    SELECT 'Test' WHERE EXISTS (SELECT SQRT(-1))

    Some more:

    SELECT 'Test' WHERE EXISTS (SELECT ACOS(PI()))

    SELECT 'Test' WHERE EXISTS (SELECT ASIN(PI()))

    SELECT 'Test' WHERE EXISTS (SELECT LOG10(0))

    If you...

    August 3, 2011 at 5:28 am

    #1362929

  • RE: Niagara Falls

    I liked the QOTD and especially the Niagara Falls idea.

    August 1, 2011 at 12:58 am

    #1361380

  • RE: TDE and Filestream

    Hi Ron,

    these pages are correct.

    Only the Answer & Explanation of this QOTD are paradox.

    While the Explanation is correct, the Answer is wrong.

    June 28, 2011 at 11:42 pm

    #1345635

  • RE: TDE and Filestream

    Come on, Steve! Make a decision. You cannot have both 🙂

    June 28, 2011 at 11:32 pm

    #1345632

  • RE: Know Your SQL Objects

    Paul Randal (5/13/2011)

    Steve - I got this wrong because your wording is broken. Extents can NOT be owned by multiple objects. When an extent is a mixed extent, it is...

    May 13, 2011 at 9:28 am

    #1324395

Viewing 15 posts - 76 through 90 (of 521 total)