Forum Replies Created

Viewing 15 posts - 1,981 through 1,995 (of 49,552 total)

  • RE: Backup and Restore SQL stored procedures

    Just the stored procedures without the database? Put them in source control, either manually via scripting or via a tool that interfaces directly.

    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

    December 19, 2016 at 8:13 am

    #1918688

  • RE: Are the posted questions getting worse?

    BLOB EATER (12/19/2016)

    GilaMonster (12/19/2016)

    Grant Fritchey (12/19/2016)

    BLOB EATER (12/19/2016)

    I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?

    I submitted sessions...

    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

    December 19, 2016 at 8:10 am

    #1918686

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/19/2016)

    BLOB EATER (12/19/2016)

    I am 90% sure that I will be going to sqlbits in April, anyone else know if they will be there?

    I submitted sessions today. Fingers crossed...

    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

    December 19, 2016 at 7:45 am

    #1918677

  • RE: Need to find out exact crash time

    SQL Guy 1 (12/15/2016)

    Yesterday our server has crashed and I need to find out exact time. In other words, since when SQL Server has become unresponsive

    That's probably not going...

    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

    December 19, 2016 at 6:22 am

    #1918655

  • RE: Making a copy of a Server Agent Job

    Script the job, put the script into source control.

    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

    December 19, 2016 at 4:06 am

    #1918646

  • RE: trouble shoot Lazy writer

    ramyours2003 (12/19/2016)

    no problem in my system but I would like to know how can we trouble shoot the lazy writer issues ?

    There's not really much configuration you can 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

    December 19, 2016 at 3:53 am

    #1918641

  • RE: trouble shoot Lazy writer

    What's the problem?

    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

    December 19, 2016 at 3:14 am

    #1918633

  • RE: upgrade from SQL 2005 to SQL 2014

    atulyan.aries (12/19/2016)

    Thanks for your response. can this be upgraded directly to SQL 2014?

    No, and in-place upgrades are not a good idea for production systems (plus there's the small matter of...

    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

    December 19, 2016 at 3:07 am

    #1918632

  • RE: upgrade from SQL 2005 to SQL 2014

    In-place upgrade (not recommended) or side-by-side/new server?

    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

    December 19, 2016 at 2:45 am

    #1918624

  • RE: Results to new table

    SELECT *

    INTO Table3

    FROM Table1 CROSS JOIN Table2

    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

    December 15, 2016 at 8:27 am

    #1918203

  • RE: Modifying a system stored procedure

    It probably won't work correctly.

    Why are you using sp_addlogin though? It's deprecated, has been since SQL 2005 and shouldn't be used any longer. It doesn't have support for any features...

    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

    December 15, 2016 at 5:23 am

    #1918143

  • RE: corruption

    johnwalker10 (12/14/2016)

    Note: It fixes the corrupt SQL database but you may will lose some data.

    It will cause data loss, not may.

    Sammy, best thing here is restore to your last good...

    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

    December 15, 2016 at 2:47 am

    #1918104

  • RE: conditional where clause

    marc.corbeel (12/14/2016)

    Found a very simple solution to my problem...

    create procedure stp_test (@only_this_record int)

    as

    begin

    select * from test where (field1=1) and ...etc...

    and (id=@only_this_record or @only_this_record=0)

    end

    I hope you don't need decent performance from...

    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

    December 15, 2016 at 2:44 am

    #1918102

  • RE: Bitwise & NULL

    Sioban Krzywicki (12/14/2016)

    Things are going well. New job that I like a lot better. How's things with you?

    It's been an interesting couple of years (in the Chinese curse sense unfortunately),...

    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

    December 15, 2016 at 2:40 am

    #1918100

  • RE: sp_addlogin,sp_adduser,sp_addrolemember

    Don't use those, they're deprecated and old (SQL 2000). Use the DDL statements instead

    CREATE LOGIN ...

    CREATE USER ...

    ALTER ROLE ...

    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

    December 15, 2016 at 2:38 am

    #1918098

Viewing 15 posts - 1,981 through 1,995 (of 49,552 total)