Forum Replies Created

Viewing 15 posts - 46 through 60 (of 120 total)

  • RE: Second Highest

    hopefully following will help

    http://pramodsingla.wordpress.com/category/interview-questions-2/

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

    September 16, 2013 at 5:33 am

    #1650376

  • RE: Declare Variable

    Koen Verbeeck (9/15/2013)

    The question itself is great, however the explanation is lacking.

    There's no reference, and the explanation itself is incorrect.

    There's no variable that is "reset".

    The DECLARE is not ignored, it...

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

    September 16, 2013 at 1:47 am

    #1650331

  • RE: t-sql full table scan problem

    A view with clustered index is indexed view.

    There are lot of limitations/conditions apply on creating the index view.see BOL for detail

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

    September 16, 2013 at 12:17 am

    #1650318

  • RE: It's not you; it's us

    It is very shocking and saddening to me. 🙁

    I was also planning to go for MCM/MCA but now I am bit suspicious for going even for MCSE.

    in my opinion also,Microsoft...

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

    September 4, 2013 at 1:29 am

    #1647195

  • RE: Today's Random Word!

    nasty

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

    August 30, 2013 at 7:37 am

    #1646364

  • RE: Global Configuration Settings

    alex.d.garland (8/30/2013)

    "The SQL Server Database Engine recognizes any unique string that is part of the configuration name."

    Wow, I did not know that. Good question, I always like it when...

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

    August 30, 2013 at 4:37 am

    #1646285

  • RE: Transaction Control in SSIS

    Following steps might be helpful:

    1.What I think is put all the task that you want to rollback in one transaction using required followed by supported

    2. bit put the transaction option...

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

    August 29, 2013 at 1:46 am

    #1645866

  • RE: Today's Random Word!

    crookj (8/21/2013)

    Daniel Bowlin (8/21/2013)

    starting over

    Reboot

    Windows

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

    August 21, 2013 at 7:56 am

    #1643469

  • RE: EXCEPT vs NOT IN vs LEFT OUTER JOIN

    at least avoid use of NOT IN rather use NOT Exists

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

    August 21, 2013 at 7:23 am

    #1643445

  • RE: Expressions

    sestell1 (8/8/2013)

    Excellent question.

    I'm definitely going to remember this in the future.

    +1

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

    August 9, 2013 at 9:05 pm

    #1640340

  • RE: Sync databases over Internet

    For such scenarios compbination of Log shipping and FTP will work.

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

    August 9, 2013 at 9:54 am

    #1640205

  • RE: SSIS Question

    Thanks Koen and Duncan

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

    August 7, 2013 at 8:22 am

    #1639413

  • RE: SSIS Question

    As per my understanding yes

    A control flow task is not a task..

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

    August 6, 2013 at 8:09 am

    #1638943

  • RE: SSIS Question

    Control flow tasks is not a task or container so not an object.

    It's just a name give to collection of tasks and container..

    and writer is asking for SSIS objects..

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

    August 6, 2013 at 6:29 am

    #1638888

  • RE: SSIS Question

    Any thought on this guys..

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

    August 6, 2013 at 6:11 am

    #1638876

Viewing 15 posts - 46 through 60 (of 120 total)