Forum Replies Created

Viewing 15 posts - 1,276 through 1,290 (of 3,348 total)

  • RE: Composite foreign key

    The question is okay (though I was hoping everyone would know that - not every table needs an IDENTITY primary key, you know?)

    I don't understand the discussion on preventing truncate...

    October 7, 2015 at 2:56 pm

    #1832150

  • RE: Restore

    Koen Verbeeck (9/30/2015)

    Seems like a certification question 😀

    Didn't know you could switch order, so I learned something.

    You can't switch order. All the correct options restore the backups in proper sequence.

    In...

    September 30, 2015 at 4:06 am

    #1830368

  • RE: Restore

    helenlu7 65408 (9/30/2015)

    Theoretically you can use all the log backs after the full backup. But use Diff backup is far more efficient than using a series of log backups.

    After...

    September 30, 2015 at 12:53 am

    #1830342

  • RE: Restore

    None of these answers are fully correct. To ensure minimal data loss, one should always start by a tail-log backup. (Which will fail if the log file is unavailable, but...

    September 30, 2015 at 12:17 am

    #1830333

  • RE: CXPACKET

    Iwas Bornready (9/22/2015)

    porter.james (9/21/2015)

    It does make slow queries hard to troubleshoot though, since it obscures the actual cause of query running slow... so for troubleshooting I'd consider temporarily setting MAXDOP...

    September 22, 2015 at 12:11 pm

    #1828524

  • RE: CXPACKET

    Almost entirely correct.

    The actual correct answer is that a CXPACKET wait indicates that one thread in a parallel plan has to wait for others as part of the synchronization.

    Whenever a...

    September 21, 2015 at 12:09 pm

    #1828184

  • RE: Round

    bmm7749-sqlservercentral (9/15/2015)

    Interestingly enough, select round(0.99+0.009,2) also works

    That is because of the rules for inferring data types after addition. Those rules DO take into account that the most significant digit can...

    September 15, 2015 at 12:03 pm

    #1826859

  • RE: Missing Indexes

    Jacob Wilkins (9/11/2015)

    Hugo Kornelis (9/11/2015)

    Jacob Wilkins (9/10/2015)

    Well, I tested it multiple times in 2008 R2 and that was the behavior I saw. Perhaps that behavior is different than in...

    September 11, 2015 at 8:50 am

    #1826014

  • RE: Missing Indexes

    Jacob Wilkins (9/10/2015)

    Well, I tested it multiple times in 2008 R2 and that was the behavior I saw. Perhaps that behavior is different than in other versions, but at...

    September 11, 2015 at 1:33 am

    #1825893

  • RE: Missing Indexes

    Jacob Wilkins (9/10/2015)

    Ken Wymore (9/10/2015)

    Interesting question. I was sure it would give an error.

    Queries that already have a plan cached that uses the nonclustered index will throw an error.

    The...

    September 10, 2015 at 1:07 pm

    #1825809

  • RE: Missing Indexes

    Luis Cazares (9/10/2015)

    Is there any difference when using clustered indexes instead of heaps?

    Both a heap and a clustered index hold all the data.

    A heap in unorganized. There are just two...

    September 10, 2015 at 11:12 am

    #1825764

  • RE: Counting Rows

    If your response to my argument is to call me numerically illiterate, then we are done.

    Please accept my apologies for wasting your and my time.

    September 3, 2015 at 1:18 pm

    #1824473

  • RE: Counting Rows

    TomThomson (8/31/2015)

    Hugo Kornelis (8/31/2015)

    TomThomson (8/30/2015)

    A nice easy question to start the week.

    And it shows that T-SQL doesn't always get aggregates on empty sets completely wrong.

    "Not always"???

    Can you give me an...

    September 1, 2015 at 1:06 pm

    #1823772

  • RE: Counting Rows

    TomThomson (8/30/2015)

    A nice easy question to start the week.

    And it shows that T-SQL doesn't always get aggregates on empty sets completely wrong.

    "Not always"???

    Can you give me an example of where...

    August 31, 2015 at 1:13 am

    #1823304

  • RE: What are your five most common T-SQL commands

    Jeff Moden (8/27/2015)

    Favorite name for a Temp Table when troubleshooting something that should never have made it to production...

    [font="Arial Black"]#MyHead[/font]

    When I want to make sure that my query tuning measurements...

    August 28, 2015 at 1:29 am

    #1822984

Viewing 15 posts - 1,276 through 1,290 (of 3,348 total)