Forum Replies Created

Viewing 15 posts - 7,651 through 7,665 (of 49,552 total)

  • RE: Why do they not listen?

    Eric M Russell (9/30/2014)

    OK, but is it really a lie? I believe it's just being "economical with the truth".

    http://en.wikipedia.org/wiki/Lie#Types

    It's a lie by omission. Yes, it's a lie.

    It's actually true...

    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:50 am

    #1749152

  • RE: Are the posted questions getting worse?

    If working from home was encouraged, I'd do it in an instant. It's not allowed except in exceptional circumstances.

    It's odd, in some aspects this company's awesome, flat management structure, minimal...

    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:37 am

    #1749138

  • RE: White Space in fields??

    jlandry (9/30/2014)

    Would regular maintenance routines assist with this issue?

    No

    Could creating a backup cause this issue?

    No.

    so I am looking for any suggestions on how we 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

    September 30, 2014 at 7:04 am

    #1749122

  • RE: Are the posted questions getting worse?

    Ed Wagner (9/30/2014)

    Hey, what if you were to run the cables up the glass and duct tape them in place so you could use the real estate on your...

    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 6:39 am

    #1749115

  • RE: Encrypting Master and tempdb

    You cannot encrypt master. TempDB is encrypted as soon as any user database has TDE enabled on it.

    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 6:31 am

    #1749111

  • RE: want to run a query which will give the Admin detail

    I think you're going to have to give us a bit more to work with than 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

    September 30, 2014 at 6:09 am

    #1749105

  • RE: How to get total hours in stead of Date time view

    WITH RawData AS (Select naam as name, Maandnummer as Month, Org as Organisation, totaal as total, opendate, closedate as solved, datediff(ss, opendate, closedate) as Seconds from #tickettotal)

    SELECT name, Month, Organisation,...

    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:07 am

    #1749082

  • RE: Are the posted questions getting worse?

    Sooo.. what happens when you design by committee

    We just moved into a new office. Promised new, better desks.

    Desks are slightly smaller, not much, not a major issue. Partitions between 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

    September 30, 2014 at 4:05 am

    #1749081

  • RE: Why do they not listen?

    Eric M Russell (9/29/2014)

    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry, I know it a pain in...

    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 2:47 am

    #1749077

  • RE: Logspace ussage

    There's no % that's good or bad. It's just a measure of how much of the log is currently in use.

    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 2:42 am

    #1749076

  • RE: Why do they not listen?

    Koen Verbeeck (9/29/2014)

    Hire an overpriced consultant. Chances are they'll listen to him/her...

    Unfortunately, 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

    September 29, 2014 at 7:15 am

    #1748800

  • RE: very large log file due to mysterious replication configuration

    No, that wasn't sufficient. You got lucky this time.

    Yes, that bug is probably what you have. Check whether there's still replication-related events.

    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 29, 2014 at 1:38 am

    #1748723

  • RE: query running 15hrs for 1lakh records

    Table definitions, index definitions and execution plan please, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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 28, 2014 at 4:02 pm

    #1748688

  • RE: Event ID 202

    Shawn Melton (9/28/2014)

    Verify the connection string between the two servers. On the server having problems you can test the client/provider being used by following these steps:

    1. Create a text 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

    September 28, 2014 at 2:44 pm

    #1748686

  • RE: Restricting a sysadmin login

    A sysadmin account has full permissions to the entire instance and nothing can be denied to it. If you want something that only has permissions to some DBs, it cannot...

    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 28, 2014 at 1:12 pm

    #1748679

Viewing 15 posts - 7,651 through 7,665 (of 49,552 total)