Forum Replies Created

Viewing 15 posts - 6,526 through 6,540 (of 49,552 total)

  • RE: Correct SQL version? Developer vs. Standard 2014

    gkruse (2/20/2015)

    I currently have a dedicated desktop PC (not a server) running SQL 2008. I have a dozen OLAP Cubes running with Analysis Services and two SQL databases that...

    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

    February 23, 2015 at 1:58 am

    #1779200

  • RE: SQL Server 2012 - Transaction log growth

    Grant Fritchey (2/21/2015)

    Here, read this.[/url]

    And this[/url]

    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

    February 23, 2015 at 1:52 am

    #1779198

  • RE: SQL Server 2012 - Transaction log growth

    Bouke Bruinsma (2/22/2015)

    First of all, make sure you create full backups asap. Big tranlogs are usually a sign of absence of full backups altogether.

    Absolutely not. You can have 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

    February 23, 2015 at 1:39 am

    #1779193

  • RE: Min and Max Memory Setting

    Have a read through Chapter 3 of http://www.red-gate.com/community/books/accidental-dba

    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

    February 23, 2015 at 1:36 am

    #1779191

  • RE: SQL server table encryption

    sql-lover (2/19/2015)

    But in cases where the application or design uses a single user which of course, already has SELECT permissions against that table or column and Dev already uses same...

    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

    February 20, 2015 at 1:46 am

    #1778880

  • RE: Are the posted questions getting worse?

    spaghettidba (2/18/2015)

    GilaMonster (2/17/2015)

    Anyone going to be at SQL Sat Vienna? It's the Saturday before SQLBits.

    Unfortunately no. I would have loved to attend and meet you (at last!).

    I'll be speaking...

    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

    February 19, 2015 at 2:12 am

    #1778569

  • RE: SQL server table encryption

    Because you're protecting it against people who don't have proper permissions.

    Consider, all HR people have access to the Employees table but only the HR head for each department should be...

    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

    February 19, 2015 at 2:10 am

    #1778567

  • RE: SQL Server 2008 backup running long and backup threads show suspended

    Suspended with what wait type?

    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

    February 19, 2015 at 2:04 am

    #1778564

  • RE: SQL apparently not realising it should ditch a cached execution plan and make a new one

    Duran (2/18/2015)

    Maybe I have it wrong (most likely), but I wondered if the gentleman configuring the server for AD-HOC queries might help in this situation?

    Since they're stored procedures, not ad-hoc...

    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

    February 19, 2015 at 1:57 am

    #1778563

  • RE: how to find order of the lock taken and released.

    Question 2 isn't a question, so it's kinda hard to answer.

    Trace or extended events will let you see the order that locks are acquired and released.

    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

    February 18, 2015 at 2:10 am

    #1778284

  • RE: Are the posted questions getting worse?

    rodjkidd (2/17/2015)

    GilaMonster (2/17/2015)

    Anyone going to be at SQL Sat Vienna? It's the Saturday before SQLBits.

    That would be me then! 😀

    Currently working out if I want to go out a day...

    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

    February 17, 2015 at 9:47 am

    #1778106

  • RE: Database Log size huge, which backup is better

    Please 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

    February 17, 2015 at 5:49 am

    #1778038

  • RE: convert all the column of table to ToBase64String

    No, because a checksum doesn't need to be base64 encoded.

    Base64 is used for converting binary values to text.

    Again, what are you trying to do here? What's the point of this?

    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

    February 17, 2015 at 5:25 am

    #1778032

  • RE: convert all the column of table to ToBase64String

    A checksum is numeric, it doesn't require Base64 encoding.

    Something like

    Select Deptid,Dept_name,location, checksum(Dept_name) from department

    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

    February 17, 2015 at 5:19 am

    #1778028

  • RE: convert all the column of table to ToBase64String

    Couple steps back... What are you trying to do?

    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

    February 17, 2015 at 5:12 am

    #1778023

Viewing 15 posts - 6,526 through 6,540 (of 49,552 total)