Forum Replies Created

Viewing 15 posts - 1,351 through 1,365 (of 49,552 total)

  • RE: user unable to see all running queries

    DBO gives full rights on a database, so you can do anything in that database, it does not give rights to the server as a whole.
    Running queries are server-level,...

    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

    June 2, 2017 at 12:39 am

    #1945015

  • RE: secondary data file

    jasona.work - Thursday, June 1, 2017 2:11 PM

     (beyond the obvious if you used something like TXT)

    I've done that. SQL didn't care

    (to 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

    June 1, 2017 at 2:26 pm

    #1944967

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, June 1, 2017 1:38 PM

    GilaMonster - Wednesday, May 31, 2017 2:16 PM

    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

    June 1, 2017 at 1:45 pm

    #1944961

  • RE: SQL server 2014 is very slow

    I give up.

    Firstly, those are all also useless waits, so get Glenn Berry's *latest* script, not one that's probably from 2005 looking at the excluded waits.

    Second....

    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

    June 1, 2017 at 1:27 pm

    #1944958

  • RE: SQL server 2014 is very slow

    Just use the first part of it, there's no need for the complex portion.

    SELECT
    wait_type,
    wait_time_ms / 1000.0 AS WaitS,
    (wait_time_ms - signal_wait_time_ms)...

    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

    June 1, 2017 at 7:14 am

    #1944888

  • RE: Stored Procedure history

    John Mitchell-245523 - Wednesday, May 31, 2017 9:50 AM

    Not without capturing them as you go, no, or maybe with the Query Store...

    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

    June 1, 2017 at 2:16 am

    #1944859

  • RE: Stored Procedure history

    SQLSACT - Wednesday, May 31, 2017 9:39 AM

    Hi All
    Is there anyway to get the stats (logical reads, physical reads, elapsed time etc)...

    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

    June 1, 2017 at 2:13 am

    #1944857

  • RE: Detaching moving database files and reattaching a log shipped database

    Are you trying to move the files of the log shipping primary (where the log backups are taken), or the secondary (where the log backups are restored)?

    If 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

    May 31, 2017 at 2:32 pm

    #1944819

  • RE: Sleeping connections with CPUtime and DISKio growing continuously?!

    WebTechie - Wednesday, May 31, 2017 1:03 PM

     However, why does the CPUTime and DISKio keep increasing? 

    Because the CPU and DiskIO are cumulative,...

    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 31, 2017 at 2:29 pm

    #1944818

  • RE: Are the posted questions getting worse?

    Ed Wagner - Monday, May 29, 2017 12:08 PM

    Eirikur Eiriksson - Monday, May 29, 2017 8:10 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

    May 31, 2017 at 2:16 pm

    #1944816

  • RE: Primary Key Indexes

    paul.farnell - Wednesday, May 31, 2017 4:02 AM

    I have a table in a database (it's a data warehouse) which is populated once...

    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 31, 2017 at 8:35 am

    #1944735

  • RE: SQL server 2014 is very slow

    pranabpal - Wednesday, May 31, 2017 7:26 AM

    Can you guide me with that kind of script - so I can provide...

    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 31, 2017 at 8:33 am

    #1944732

  • RE: After a Checkpoint

    Rechana Rajan - Wednesday, May 31, 2017 1:42 AM

    my question is when a page is written to disk the data 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

    May 31, 2017 at 3:44 am

    #1944688

  • RE: Adding Minutes to DATETIME2

    Sergiy - Tuesday, May 30, 2017 7:29 PM

    It's not quite a hack.All date-time manipulation a in Excel are built on this "hack".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

    May 31, 2017 at 3:42 am

    #1944686

  • RE: SQL server 2014 is very slow

    pranabpal - Wednesday, May 31, 2017 1:16 AM

    What wait type is causing the problem . What is solution  for this?

    I don't...

    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 31, 2017 at 3:40 am

    #1944685

Viewing 15 posts - 1,351 through 1,365 (of 49,552 total)