Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 49,552 total)

  • RE: Which command to reduce log fle ?

    contact 14920 - Tuesday, May 23, 2017 1:49 AM

    Hi,

    It's a little database : 
    one file *.mdf : 8 Gb
    one file *.ldf :...

    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

    May 23, 2017 at 2:06 am

    #1943718

  • RE: backup after a restore.

    John Mitchell-245523 - Tuesday, May 23, 2017 1:06 AM

    Well, you can't make any log backups until you've made a full backup.  Therefore...

    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

    May 23, 2017 at 1:42 am

    #1943706

  • RE: Deadlock

    Look in the system health extended event session's captured data. The deadlock graphs are caught by that session.

    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

    May 22, 2017 at 4:45 pm

    #1943676

  • RE: What does the $ mean in this calculation?

    $20 is a literal of the data type money/smallmoney, because they're the only data types that can have a currency symbol in front, just like 10.0 would be a literal...

    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

    May 22, 2017 at 4:44 pm

    #1943675

  • RE: Azure data warehouse - Index maintenance

    SQL!$@w$0ME - Monday, May 22, 2017 1:49 PM

    Thanks! I see I'm not able to use dmv for index physical stats... according...

    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

    May 22, 2017 at 2:15 pm

    #1943654

  • RE: Azure data warehouse - Index maintenance

    SQL!$@w$0ME - Monday, May 22, 2017 1:47 PM

    Thanks Gail! We are using default clustered column store index. We have statistics created...

    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

    May 22, 2017 at 2:14 pm

    #1943653

  • RE: backup after a restore.

    sqlfriends - Monday, May 22, 2017 11:30 AM

    What I was thinking, whenever I do a restore from a production database to a...

    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

    May 22, 2017 at 2:12 pm

    #1943652

  • RE: Azure data warehouse - Index maintenance

    SQL!$@w$0ME - Monday, May 22, 2017 12:35 PM

    Hello Folks,

    How do you perform/schedule index maintenance on Azure Data warehouse. Is there an option...

    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

    May 22, 2017 at 1:07 pm

    #1943640

  • RE: Azure data warehouse - Index maintenance

    Lowell - Monday, May 22, 2017 12:41 PM

    the structure of a database and dmv's are all exactly the same, whether Azure or...

    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

    May 22, 2017 at 1:03 pm

    #1943637

  • RE: deadlocks and IX Rebuilds

    sqlguy80 - Monday, May 22, 2017 11:56 AM

    Do fragmented indexes also cause deadlocks?

    No.
    Fragmentation affects large range scans from disk. Emphasis large 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

    May 22, 2017 at 12:50 pm

    #1943633

  • RE: add 2nd data file and limit the size of 1st datafile

    If you don't set maxsize, then the size is unlimited. To restrict the size of the first file, you can set a max size on the existing file.

    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

    May 21, 2017 at 5:20 am

    #1943473

  • RE: Check if Function EXISTS before adding

    Please note: 4 year old thread

    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

    May 21, 2017 at 5:19 am

    #1943472

  • RE: Creating temporary tables and declaring tables as variables

    Well, nolock's a bad idea, so you shouldn't be judging based on that.

    http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

    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

    May 20, 2017 at 12:48 pm

    #1943441

  • RE: query time out from .net code

    sqlfriends - Friday, May 19, 2017 2:26 PM

     what else can I do the troubleshooting?

    Identify the query, see if you...

    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

    May 19, 2017 at 2:40 pm

    #1943395

  • RE: The target database, '', is participating in an availability group and is currently not accessible for queries.

    SQL-DBA-01 - Friday, May 19, 2017 1:58 PM

    But when I right click on the database and check properties I see the below...

    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

    May 19, 2017 at 2:28 pm

    #1943394

Viewing 15 posts - 1,426 through 1,440 (of 49,552 total)