Forum Replies Created

Viewing 15 posts - 391 through 405 (of 1,170 total)

  • RE: Database File Placement and number of files

    SSDs are relatively cheap today, so why not include them in the analysis? They perform excellent as well.

    February 3, 2015 at 8:42 am

    #1775053

  • RE: How to reduce MDF file size ?

    1. If you can allow the shrink operation then you can shrink the data file and after rebuild the indexes, because the shrink will introduce a lot of fragmentation.

    2....

    February 3, 2015 at 12:57 am

    #1774952

  • RE: CASE vs ISNULL? Which is faster?

    Bhushan Kulkarni (2/1/2015)

    Performance of both will be same. I tested both queries on my test database. I got same execution plan for both ISNULL and Case statement

    I agree. Even if...

    February 2, 2015 at 1:06 am

    #1774693

  • RE: Group By, Count, and NULLs

    Good to know that group by lumps the nulls.

    Thanks

    February 2, 2015 at 12:46 am

    #1774690

  • RE: Just an idea ...

    This is something that I noticed some period ago, and it's definitely a good idea - a filter for the columns to be implemented in ssms.

    Sometimes I use the red-gate...

    January 23, 2015 at 2:34 am

    #1772533

  • RE: The Identity Limit

    h.tobisch (1/20/2015)

    10 ^38 > 8 ^21 = 2 ^63

    +1

    Great question. Could have considered the above in order to get the question right.

    January 23, 2015 at 2:09 am

    #1772525

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/31/2014)

    Igor Micev (12/30/2014)

    I had 4 update statements (2 updates and 2 merges ) in one transaction and I isolated them in separate transactions.

    Which means you no longer have atomicity...

    December 31, 2014 at 3:32 am

    #1767154

  • RE: Deadlocks, wiats, deadlocks

    Thanks to all in this discussion.

    I had 4 update statements (2 updates and 2 merges ) in one transaction and I isolated them in separate transactions.

    On the update statements i...

    December 30, 2014 at 11:46 am

    #1767056

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/30/2014)

    Igor Micev (12/30/2014)

    GilaMonster (12/29/2014)

    Have a read through this: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    Hi Gail,

    I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't...

    December 30, 2014 at 11:26 am

    #1767048

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/29/2014)

    Have a read through this: https://www.simple-talk.com/sql/performance/sql-server-deadlocks-by-example/

    Hi Gail,

    I read your article. In Reader-Writer Deadlocks, why do you move the merge statement into another SP (UpdateCustomerLatestOrderStatus ), can't you do that...

    December 30, 2014 at 10:31 am

    #1767039

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/29/2014)

    Igor Micev (12/29/2014)

    Then, even though the isolation level is READ COMMITTED using row versions, there are sill deadlocks.

    Yes, and?

    I've read that read committed snapshot uses pessimistic writes, and snapshot...

    December 29, 2014 at 4:54 am

    #1766728

  • RE: Deadlocks, wiats, deadlocks

    Igor Micev (12/29/2014)

    GilaMonster (12/29/2014)

    Depends. If you explicitly request an isolation level, you get whichever one you request. If you allow the default of read committed, then you get read committed...

    December 29, 2014 at 3:35 am

    #1766713

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/29/2014)

    Depends. If you explicitly request an isolation level, you get whichever one you request. If you allow the default of read committed, then you get read committed using row...

    December 29, 2014 at 3:33 am

    #1766712

  • RE: Deadlocks, wiats, deadlocks

    GilaMonster (12/29/2014)

    Read committed snapshot is the read committed isolation level, implemented with row versions. It's not a separate isolation level like Snapshot is.

    Hence you see Read Committed as the isolation...

    December 29, 2014 at 3:07 am

    #1766705

  • RE: Deadlocks, wiats, deadlocks

    Thanks both for the replies

    from the deadlock report you can see isolationlevel = "read committed (2)"

    Isolation level for all databases is READ COMMITTED SNAPSHOT, and that is one of...

    December 29, 2014 at 2:58 am

    #1766703

Viewing 15 posts - 391 through 405 (of 1,170 total)