Forum Replies Created

Viewing 15 posts - 10,261 through 10,275 (of 49,552 total)

  • RE: Query just hangs!

    I doubt triangular joins are the right solution for that (or for much to be honest). There's far faster and easier ways to find duplicates than what's looks like half...

    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

    January 27, 2014 at 1:30 am

    #1683440

  • RE: SQL Cursor Performance.. Cursor Vs While Loop SHUBHAM SAXENA

    Koen Verbeeck (1/27/2014)

    but a cursor has additional constructs to go forward and backward in the set you're looping over (amongst other things).

    Depending on the type of the cursor. A 'firehose'...

    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

    January 27, 2014 at 12:15 am

    #1683428

  • RE: Update a SQL View ..(BY-SHUBHAM SAXENA PIIBHIT)

    The very first result of a google search on "update a sql server view"

    http://technet.microsoft.com/en-us/library/ms180800.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

    January 27, 2014 at 12:13 am

    #1683427

  • RE: CTE results storage same as temp table?

    CTEs aren't tables. They're named subqueries. Their results are not necessarily materialised or stored anywhere.

    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

    January 27, 2014 at 12:10 am

    #1683425

  • RE: Interview Question -help

    Wait. Because there's nothing else you can do.

    Search the forums on this site for several cases where people have been in that situation and see what some of them have...

    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

    January 27, 2014 at 12:09 am

    #1683423

  • RE: Backup Encryption options with SQL Server 2008 R2 SE?

    With Standard edition you'll need to look at 3rd party backup tools. I believe Red Gate's SQLBackup offers encryption, probably several others do too.

    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

    January 27, 2014 at 12:07 am

    #1683422

  • RE: SHRINK LOG FILE IN SIMPLE RECOVERY MODEL.

    For more info on the log, take a read through this http://www.sqlservercentral.com/articles/Administration/64582/

    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

    January 26, 2014 at 5:03 am

    #1683369

  • RE: Having Trouble Understnading Float Data Type

    AndrewSQLDBA (1/25/2014)

    I am trying to understand how to read the float by just looking at it. And also, how to add or subtract a 1 or a 5 or another...

    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

    January 25, 2014 at 1:00 pm

    #1683337

  • RE: Is it better to involve more columns to make an index unique, or just index the nonunique column?

    Generally... Index what you need to index to support the queries that are running against the table. If the index happens to be unique, mark it as so.

    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

    January 24, 2014 at 6:22 am

    #1683107

  • RE: What would happen? - Log shipping, changing to simple recovery, keep the chain going!

    Maddave (1/24/2014)

    However, on the live server, I have suddenly thought, the last full backup of the database was taken back when log shipping was first created - September 2012!!

    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

    January 24, 2014 at 6:20 am

    #1683105

  • RE: Max and Min Memory

    Grant Fritchey (1/24/2014)

    Myself, for a production server, I'd probably just set the Min to the same as the Max so that when you start SQL Server it just allocates it's...

    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

    January 24, 2014 at 6:18 am

    #1683104

  • RE: how to get table 'design' modified history/log in sql server

    You can look in the default trace (several articles here on that), but it's very limited in how long it keeps things for. It keeps 5 files of no more...

    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

    January 24, 2014 at 2:00 am

    #1683026

  • RE: Are the posted questions getting worse?

    Headdesk. http://www.sqlservercentral.com/Forums/FindPost1534283.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

    January 23, 2014 at 3:22 pm

    #1682957

  • RE: Log File Size does not shrink

    Welsh Corgi (1/23/2014)

    GilaMonster (1/23/2014)

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the...

    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

    January 23, 2014 at 3:03 pm

    #1682953

  • RE: Log File Size does not shrink

    Welsh Corgi (1/23/2014)

    GilaMonster (1/22/2014)

    btw, going through the GUI to shrink the log runs DBCC ShrinkFile, there's no difference between running the command from a script or the GUI.

    By going through...

    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

    January 23, 2014 at 2:48 pm

    #1682950

Viewing 15 posts - 10,261 through 10,275 (of 49,552 total)