Forum Replies Created

Viewing 15 posts - 1,651 through 1,665 (of 3,348 total)

  • RE: TSQL- XQuery

    L' Eomot Inversé (7/29/2013)

    if I need to know I can either play (if I have a SQL Server instance I can play with handy) or look it up (if I...

    July 29, 2013 at 4:26 am

    #1636579

  • RE: TSQL- XQuery

    I like the question. I don't think it's a trick question - many people here are so used to using case insensitive collations (stupid defaults!!!) that they can and will...

    July 29, 2013 at 2:32 am

    #1636551

  • RE: TDE Setup

    I got it right, because I know that you have to create a certificate in master to protect the master key - but the question is a bit misleading.

    The question...

    July 26, 2013 at 8:28 am

    #1636180

  • RE: Could You Live Like a DBA?

    I am now searching (or rather, scanning) all nooks and corners in my home to find the hidden camera that just has to be installed somewhere. This is exactly my...

    July 26, 2013 at 8:23 am

    #1636176

  • RE: Indexing in views

    wolfkillj (7/25/2013)

    Andrew Diniz (7/25/2013)

    I supposed (incorrectly) that the ALTER VIEW would fail due to the addition of the non-determinitic column, CurrentDate, to the indexed view.

    Learned lots this morning! Nice question!

    Even...

    July 25, 2013 at 10:29 am

    #1635828

  • RE: What's in a name?

    L' Eomot Inversé (7/24/2013)

    PHYData DBA (7/23/2013)

    L' Eomot Inversé (7/22/2013)

    I suppose I ought to install BIDS and learn to use it on 2008R2 and install SSDTBI on my win 8/SQL 2012...

    July 24, 2013 at 8:42 am

    #1635388

  • RE: Indexing in views

    Interesting question!

    I would have expected the ALTER VIEW to fail because of the presence of an index - if you had included that as an answer option, I would have...

    July 24, 2013 at 1:46 am

    #1635226

  • RE: The OUTPUT clause and T-SQL Syntax

    Carlo Romagnano (7/24/2013)

    Hugo Kornelis (7/23/2013)

    ...

    In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an...

    July 24, 2013 at 1:35 am

    #1635223

  • RE: The OUTPUT clause and T-SQL Syntax

    kapil_kk (7/23/2013)

    Hugo Kornelis (7/23/2013)

    kapil_kk (7/23/2013)

    Can someone please throw more light on this statement-

    DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause

    Which part...

    July 23, 2013 at 4:00 am

    #1634845

  • RE: The OUTPUT clause and T-SQL Syntax

    kapil_kk (7/23/2013)

    Can someone please throw more light on this statement-

    DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause

    Which part of the statement...

    July 23, 2013 at 3:20 am

    #1634819

  • RE: T-SQL

    kapil_kk (7/22/2013)

    (...)

    In this example after putting clustered index we will data in ascending sorted order.... while before adding clustered index data was not coming in an order...

    I am confused now...

    July 22, 2013 at 6:09 am

    #1634431

  • RE: T-SQL

    kapil_kk (7/22/2013)

    John Mitchell-245523 (7/22/2013)

    kapil_kk (7/22/2013)

    Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of...

    July 22, 2013 at 5:42 am

    #1634417

  • RE: T-SQL

    kapil_kk (7/22/2013)

    Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the data in...

    July 22, 2013 at 5:23 am

    #1634409

  • RE: T-SQL

    PRR.DB (7/22/2013)

    If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column order.

    Is my...

    July 22, 2013 at 3:59 am

    #1634384

  • RE: Change Tracking

    DivyaMohankumar (7/10/2013)

    Hi

    Can anyone explain Change tracking and its use...

    Start here: http://msdn.microsoft.com/en-us/library/bb933875.aspx. Then,...

    July 10, 2013 at 3:35 am

    #1631128

Viewing 15 posts - 1,651 through 1,665 (of 3,348 total)