Forum Replies Created

Viewing 15 posts - 61 through 75 (of 120 total)

  • RE: Isolation levels

    Michael Riemer (8/6/2013)

    Was looking for the trick in the question - great back to basics. Thanks.

    +1

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    August 6, 2013 at 5:59 am

    #1638869

  • RE: PRIMARY KEY VS UNIQUE KEY*

    On the other hand, an Unique Index is an index that doesn't allow for duplicate values but it is not a Referential Integrity constraint.

    Paul,what exactly you mean by that..

    As we...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 30, 2013 at 5:01 am

    #1636914

  • RE: LEN and CONVERT

    Nice Question

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 30, 2013 at 4:41 am

    #1636906

  • RE: Parameter Sniffing and Sniffing Memory

    loved reading it

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 15, 2013 at 7:10 am

    #1632453

  • RE: Mirroring Standard and Enterprise

    not sure about 2005 but in 2008 and above you can upgrade the servers without downtime.

    first upgrade the mirror server

    then fail-over to to mirror server

    then upgrade initial primary server

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 11, 2013 at 8:07 am

    #1631593

  • RE: Certification

    Training kit books are really helpful to me...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 11, 2013 at 5:43 am

    #1631526

  • RE: Migration of Maintenance Plans - Server to Server

    maintenance plans are stored in msdb.

    So restoring the msdb on new server should server your purpose.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 11, 2013 at 2:40 am

    #1631493

  • RE: Contained database

    http://msdn.microsoft.com/en-us/library/ff929071.aspx

    this might help you.

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 11, 2013 at 1:35 am

    #1631483

  • RE: What will convert return?

    Good question..and I have seen this behavior earlier as well.

    As per BOL, "*" is returned when we try to convert to char and varchar and

    Error message when try on convert...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 11, 2013 at 1:31 am

    #1631482

  • RE: SQL Server 2012 Concat

    its new function added in SQL 2012

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 9, 2013 at 7:34 am

    #1630794

  • RE: SP_Spaceused

    As there is lot of unallocated space then once you can shrink the file..

    if it grows again then don't shrink file again.

    Note:As specified by some geeks ,it is not advisable...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 9, 2013 at 5:35 am

    #1630743

  • RE: MCSA 70-461 --Question 2

    thanks Gail,,,I got what author is trying to say...

    I think instead of clustered index he should have used clustered table to make it clear..

    SQL Server uses an allocation order scan...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 9, 2013 at 4:41 am

    #1630724

  • RE: MCSA 70-461 --Question 2

    HanShi (7/9/2013)

    The answer is B.

    Does the exam kit has an explanation or link to why C should be the correct answer?

    Writer's Explanation

    3. correct answer: c

    a. incorrect: When SQL...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 9, 2013 at 3:32 am

    #1630701

  • RE: SQL Server 2012 Concat

    Carlo Romagnano (7/9/2013)

    select concat(null + 'Hello','testString') as a

    , null+'testString' as b

    It simply returns 'testString', NULL

    😀

    Looks ok to me as :

    null + 'Hello' --->NULL

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 9, 2013 at 1:30 am

    #1630670

  • RE: Len() with different datatypes

    Hugo Kornelis (7/8/2013)

    Not a bad question, but the explanation is only partial. Here's a fuller explanation.

    For varchar, trailing spaces are preserved, so the variable stores six letters plus two trailing...

    Pramod
    SQL Server DBA | MCSE SQL Server 2012/2014
    in.linkedin.com/in/pramodsingla/
    http://pramodsingla.wordpress.com/

    July 8, 2013 at 8:11 pm

    #1630630

Viewing 15 posts - 61 through 75 (of 120 total)