Forum Replies Created

Viewing 15 posts - 421 through 435 (of 716 total)

  • RE: Recovery Interval

    Got it right although i was not quite sure about the crash recovery 🙂

    July 27, 2014 at 4:02 am

    #1732644

  • RE: Non Temp Temp Tables

    TomThomson (7/22/2014)

    Bad question. The answer depends on what privileges you are logged in with. Telling people the correct answer is that you can do this is encouraging them...

    July 27, 2014 at 3:15 am

    #1732640

  • RE: The first thing to do with a damaged off-line database

    raulggonzalez (7/18/2014)

    obviously the first thing should be to backup the log, but what is the point when the database is offline and you will get an error?

    BACKUP LOG [QODTest] TO...

    July 18, 2014 at 1:55 am

    #1730510

  • RE: Is a Primary Key an index?

    Steve Lund (7/17/2014)

    Interesting also, is that when you create a PK on a table, in SSMS that it lists that PK under Indexes and not under Constraints.

    True, although PK is...

    July 17, 2014 at 9:16 am

    #1730321

  • RE: Is a Primary Key an index?

    pmadhavapeddi22 (7/15/2014)

    This is my understanding. primary key is a constraint not an index, but it creates an index automatically by default, but primary key is called a constraint not an...

    July 17, 2014 at 9:09 am

    #1730317

  • RE: Casting and Data Type Conversion

    BTY, @ the end of the explanation, it states that "For example, the following SELECT statement shows that the integer value 123456 is usually stored as a binary 0x0001e240", then...

    July 17, 2014 at 5:10 am

    #1730197

  • RE: Casting and Data Type Conversion

    Jamsheer (7/15/2014)

    Thanks.. But still confused:-P.. need to work on it..

    Same confusion here, really. :w00t:

    July 17, 2014 at 5:08 am

    #1730196

  • RE: Casting and Data Type Conversion

    Raghavendra Mudugal (7/15/2014)

    something happens in sql and it gives 254 as output.

    Nice 😀

    July 17, 2014 at 5:07 am

    #1730194

  • RE: The Size of the Data Pages in SQL Server

    twin.devil (7/17/2014)

    Good Knowledge base question. Thanks for sharing

    Absoulately agree here 😎

    July 17, 2014 at 4:57 am

    #1730188

  • RE: What is the true value?

    pmadhavapeddi22 (7/14/2014)

    I also have no knowledge about powershell script. I have saved the script as.ps1 and executed it in command prompt like mentioned below.

    powershell -ExecutionPolicy ByPass -File c:\Document1.ps1

    (I...

    July 17, 2014 at 4:25 am

    #1730178

  • RE: Difference with DataLength and Len with CHAR and NVARCHAR Datatype

    Koen Verbeeck (7/11/2014)

    Why is DATALENGTH() included in the question? The first two results are the same for all answers 🙂

    Nice 😉

    July 14, 2014 at 1:59 am

    #1729055

  • RE: SSIS Column Export

    robertjtjones (7/9/2014)

    Never come across this before - thanks

    Neither do I 🙂

    July 14, 2014 at 1:39 am

    #1729053

  • RE: What is the Output?

    Good back to basics, thanx a lot 🙂

    July 14, 2014 at 1:37 am

    #1729052

  • RE: Random Sample

    Carlo Romagnano (7/9/2014)

    Thank you for question!

    Theoretically, any query would return different value!

    In practice, Only ORDER BY NEWID() works for us.

    Yes, that`s true, same found here 🙂

    July 9, 2014 at 4:06 am

    #1727974

  • RE: T-SQL Syntax Gotchas

    pmadhavapeddi22 (7/8/2014)

    I have searched all the deprecated / discontinued features in 2012 but could not find "compute", and got it wrong 🙁 :crying:

    ( I had to run the code in...

    July 9, 2014 at 2:34 am

    #1727963

Viewing 15 posts - 421 through 435 (of 716 total)