Forum Replies Created

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

  • RE: I Hate To Send This Email

    Steve Jones - SSC Editor - Thursday, March 23, 2017 10:47 AM

    Plenty of people have one way hashes with this value:
    0x5BAA61E4C9B93F3F0682250B6CF8331B7EE68FD8
    Can...

    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

    March 23, 2017 at 3:19 pm

    #1934663

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, March 23, 2017 11:57 AM

    But, looks like they lost, Apple checked, didn't find evidence of a breach 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

    March 23, 2017 at 3:15 pm

    #1934661

  • RE: tuning help

    Ok, so firstly for those saying this isn't T-SQL, it is. It's just the variant of T-SQL used in PDW/Azure SQLDW (they have a CREATE TABLE AS statement, and up...

    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

    March 23, 2017 at 9:37 am

    #1934546

  • RE: I Hate To Send This Email

    Gary Varga - Thursday, March 23, 2017 5:41 AM

    GilaMonster - Thursday, March 23, 2017 4:22 AM

    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

    March 23, 2017 at 6:01 am

    #1934481

  • RE: I Hate To Send This Email

    Passwords should be hashed, not encrypted.  Encryption is reversible, so is for places where you need to get the original data back. Passwords aren't one of those

    Yes, some...

    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

    March 23, 2017 at 4:22 am

    #1934470

  • RE: trying to upsize MSACCESS 2010 to sql server 2008

    Question: Why upgrade to an eight-year old version that's out of support? You can't even buy licenses for SQL 2008 any longer, you'd need to buy 2016 licenses with downgrade...

    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

    March 22, 2017 at 4:30 pm

    #1934423

  • RE: Licensing of SQL Standard 2016 (and SSIS) as Management Instance alongside SQL Express

    This kind of thing comes up frequently. You can't use Express or a web server to act as a 'user' so as to only buy one CAL. The Standard edition...

    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

    March 22, 2017 at 4:27 pm

    #1934422

  • RE: tuning help

    That looks like SQL Server Parallel Data Warehouse, or Azure SQL Datawarehouse.
    Is that the case?  If so, which one?

    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

    March 22, 2017 at 4:24 pm

    #1934420

  • RE: Urgent help

    I have last used reporting services 5 years ago and have barely touched clustering. I don't think my experience will help you in the slightest.

    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

    March 22, 2017 at 4:21 pm

    #1934419

  • RE: Urgent help

    Please don't post multiple threads for the same question.
    No replies here please. Direct replies to https://www.sqlservercentral.com/Forums/1865935/Urgent-help-on-ssrs

    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

    March 22, 2017 at 5:02 am

    #1934272

  • RE: Locking on Table with covering non clustered index

    alex.palmer - Wednesday, March 22, 2017 3:23 AM

    So presumably the insert will be unable to complete until the SELECT has release its...

    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

    March 22, 2017 at 4:05 am

    #1934268

  • RE: SQL Server 2008 R2 migration to Sql Server 2014

    SQL006 - Sunday, March 19, 2017 11:48 PM

    I am browsing the net to find out what are the most issues will face...

    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

    March 20, 2017 at 2:50 am

    #1933947

  • RE: Memory Issue - SQL Server 2008 R2

    I typically leave min server memory at 0, unless I expect memory contention on the server and I want SQL never to reduce below a value.

    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

    March 18, 2017 at 4:27 am

    #1933861

  • RE: Do derived tables joins perform better than plain joins? We are using Parallel datawarehousing sql server

    kukr007 - Thursday, March 16, 2017 6:20 AM

    GilaMonster - Thursday, March 16, 2017 5:45 AM

    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

    March 16, 2017 at 6:25 am

    #1933445

  • RE: Do derived tables joins perform better than plain joins? We are using Parallel datawarehousing sql server

    The two will be identical, identical plans, identical performance.

    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

    March 16, 2017 at 5:45 am

    #1933437

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