Forum Replies Created

Viewing 15 posts - 7,636 through 7,650 (of 49,552 total)

  • RE: Update stats

    Read all or part of a column of a table, compute the distribution statistics, update the stats blob.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 1, 2014 at 2:37 am

    #1749329

  • RE: Ranking

    Sean Pearce (10/1/2014)

    Roland C (10/1/2014)

    Another badly redacted question ! It gets a little boring :doze:

    You could always submit your own question.

    This kind of reaction is why I don't submit questions...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 1, 2014 at 2:29 am

    #1749327

  • RE: clustered index deadlock

    They're row locks. So two exclusive locks on different rows of the same index.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 1, 2014 at 2:24 am

    #1749325

  • RE: Are the posted questions getting worse?

    The promised picture

    This shows about the rear 1/4 of my desk, slap in the centre (left-right).

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 1, 2014 at 2:22 am

    #1749323

  • RE: Is Alter database minimally logged in bulk recovery mode?

    Operations which can be minimally logged: http://technet.microsoft.com/en-us/library/ms191244%28v=sql.105%29.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    October 1, 2014 at 2:19 am

    #1749321

  • RE: Are the posted questions getting worse?

    "Do I really have to do things the proper way?"

    http://www.sqlservercentral.com/Forums/Topic1621383-2799-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 4:50 pm

    #1749281

  • RE: Trying to set variable to last day of current month, but seeing NULL instead of 28, 30 or 31?

    pietlinden (9/28/2014)

    DECLARE @currMonthNum INT,

    @lastDayMonth INT

    SET @currMonthNum = DATEPART(MM, GETDATE())

    IF @currMonthNum IN (1, 3, 5, 7, 8, 10, 12)

    SET @lastDayMonth = 31

    IF @currMonthNum = 2

    SET @lastDayMonth = 28

    IF @currMonthNum IN (4,...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 3:39 pm

    #1749274

  • RE: db_owner or not

    Which is it?

    They need to be able to query and change data, create tables, views and procs?

    or

    They need full control over the database?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 3:37 pm

    #1749273

  • RE: Sql Server restart

    ramana3327 (9/30/2014)

    I go and check D:\MSSQL\MSRS11.MSSQLSERVER\Reportingservices\Logfiles

    Why are you looking in the SQL Server Reporting Services logs?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 12:33 pm

    #1749243

  • RE: Sql Server restart

    Anything from a couple minutes upward. I've seen 13 hours, I've heard of a couple of days.

    Why restart? If TempDB is full, make the files larger. Interrupting everyone because you've...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 10:23 am

    #1749221

  • RE: Why do they not listen?

    Eric M Russell (9/30/2014)

    So, if a DBA removes an end user from the DBO role in the process of performing a migration to the next release of SQL Server, and...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 9:49 am

    #1749207

  • RE: issue with datetime

    It's the format code. See the CAST and CONVERT page in Books Online.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 9:44 am

    #1749204

  • RE: Why do they not listen?

    Eric M Russell (9/30/2014)

    The intent is not the deceive but rather to present a simplified version of the truth that supports one's side of an argument and avoids a longer...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 9:42 am

    #1749203

  • RE: Sorting an Execution Plan

    Plan Explorer from SQL Sentry.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 8:04 am

    #1749161

  • RE: Are the posted questions getting worse?

    Jack Corbett (9/30/2014)

    1. I'd work from home almost exclusively in this case and just be in the office for meetings.

    This, in an instant.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 30, 2014 at 7:59 am

    #1749159

Viewing 15 posts - 7,636 through 7,650 (of 49,552 total)