Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 5,843 total)

  • RE: SQLServer2012 Locking

    TSQLLearner2014 (7/7/2014)

    Given the situation where we had to put a hot fix asap... This worked brilliantly. We have now time to fine tune the code.

    I will now try using the...

    July 7, 2014 at 1:09 pm

    #1727540

  • RE: Need help

    No problem is a good problem to have!! 😀

    My guess is the log reuse is simply because you have log shipping enabled and are getting a fair amount of activity...

    July 7, 2014 at 1:07 pm

    #1727539

  • RE: Need help

    crazy4sql (7/7/2014)

    Thanks Kevin, for taking time to look into this.

    1) I would use things like dbcc sqlperf(logspace) to see the size and percent full of each database's tlog.

    All...

    July 7, 2014 at 6:31 am

    #1727326

  • RE: SQLServer2012 Locking

    neltonk (7/7/2014)

    Hi I have modified the query as directed. The filters in the query are on the columns that are part of the clustered index (primary key) so I am...

    July 7, 2014 at 6:20 am

    #1727325

  • RE: Need help

    crazy4sql (7/6/2014)

    I have a sql server where alwayson is configured between the instances. Recently we migrated a database here which is very small of 500mb but it started blotting waits....

    July 6, 2014 at 9:51 am

    #1727228

  • RE: Stored Procedure Performance

    If I added everything I wanted to my Common TSQL Mistakes talk it would be about 327 hours long!! 🙂 Actually I did give the talk on a webex...

    July 5, 2014 at 8:18 pm

    #1727199

  • RE: Mysterious deadlocks on a heap table

    Eirikur Eiriksson (7/5/2014)

    I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans which...

    July 5, 2014 at 2:13 pm

    #1727178

  • RE: Poor performance - SQL server 2012 standard edition

    1) There are about a bajillion things that could be at play here.

    2)

    cost threshold for parallelism to 0.

    THAT is a WAY WAY WAY bad thing to do!!!...

    July 4, 2014 at 10:27 pm

    #1727130

  • RE: Mysterious deadlocks on a heap table

    Mark down my vote for a clustered index too - with appropriate fill factor as mentioned. Token is looking VERY much like something that will have values spread throughout...

    July 4, 2014 at 6:28 am

    #1727076

  • RE: Need help with backup statement for a SQL Server 6.5 instance

    Tim Cullen (7/3/2014)

    Disregard-I finally found it. Here's a sample statement:

    DUMP DATABASE model

    TO DISK = '\\[SERVERNAME]\[FOLDERLOCATION]\model_test.BAK'

    WITH INIT

    You may want to set up a "device" to backup to.

    NOTE: you MUST...

    July 3, 2014 at 12:51 pm

    #1726941

  • RE: SQLServer2012 Locking

    1) You simply MUST fix the IS NULL OR construct - and do so EVERYWHERE you have it in your code.

    2) On the whole I would say that...

    July 3, 2014 at 12:42 pm

    #1726939

  • RE: Select query error

    ALERT!!!! You should NEVER use sp_MSforeachdb!!! http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx

    July 3, 2014 at 12:37 pm

    #1726936

  • RE: Identifying specific blocker SQL stmt when it is part of an explicit tran

    I wouldn't be surprised to see that sp_WhoIsActive has all the relevant information from that post exposed. @get_full_inner_text, @get_outer_command, @get_locks, @get_additional_info, @find_block_leaders, @get_transaction_info. But if you have another solution...

    July 3, 2014 at 7:17 am

    #1726803

  • RE: TSQL Short-circuit

    ScottPletcher (7/2/2014)

    TheSQLGuru (7/1/2014)

    Very few things in SQL Server land can/will short-circuit.

    I think that's over-stated. Most optimizers will short-circuit when they safely can. Presumably later versions of the...

    July 2, 2014 at 6:57 pm

    #1726669

  • RE: Performance Tuning Methodology

    Grant Fritchey (7/2/2014)

    Lynn Pettis (7/2/2014)

    TheSQLGuru (7/2/2014)

    Users - BAHHH!!! Who needs 'em?!? 😀

    Yea, our databases would perform so much better without them! :w00t:

    And the queries would run even faster if...

    July 2, 2014 at 3:24 pm

    #1726643

Viewing 15 posts - 1,906 through 1,920 (of 5,843 total)