Forum Replies Created

Viewing 15 posts - 20,341 through 20,355 (of 49,552 total)

  • RE: Return Scalar Value from Stored Proc

    May I suggest an output parameter instead? The return code is supposed to be an indication of success or failure, not a data value.

    CREATE PROCEDURE cpas.POIDVendorProjectDate

    @VendorID int,

    @ProjectID int,

    @WorkDate datetime

    @PO_ID int...

    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 13, 2012 at 12:30 pm

    #1446450

  • RE: Are the posted questions getting worse?

    Evil Kraig F (2/13/2012)

    Side note: It's really nice my first handful of QotDs have gone off without flamewars, abuse, detail harpies, or other assundry annoyances. Woot! Go me!...

    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 13, 2012 at 12:25 pm

    #1446449

  • RE: Duplicate User Names

    Redoing the links so they work as intended

    http://www.sqlservercentral.com/Forums/UserInfo1000801.aspx

    http://www.sqlservercentral.com/Forums/UserInfo17330.aspx

    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 13, 2012 at 12:19 pm

    #1446440

  • RE: Upgrading Your Career

    tony.turner (2/12/2012)

    Wake me up again once it becomes viable for people in their personal capacity; I could just become interested if I am still young enough

    I live in the 3rd...

    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 13, 2012 at 12:10 pm

    #1446437

  • RE: SQL Change Log

    Query the default trace and apply your own filters. Do note that the default trace is not a change log for all time, it keeps 5 files of 20MB each...

    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 13, 2012 at 12:06 pm

    #1446433

  • RE: SELECT statement takes about 30 seconds to complete... should I use NO LOCK to reduce potential blocking? (pros/cons)

    kschwid (2/13/2012)

    I also stated before that I only use them for reporting, so there are no inserts or updates involved, using NoLock on some of the tables in my query...

    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 13, 2012 at 12:03 pm

    #1446429

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (2/13/2012)

    OK, I hadn't noticed the blog post items, but they shouldn't appear. I'll see if we can get a fix in.

    Thanks. It's irritating over weekends...

    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 13, 2012 at 11:29 am

    #1446404

  • RE: DBCC REINDEX on table with 970GB data and 10GB index with 5 billions rows of count

    Maramor (2/13/2012)

    Need to spread over multiple files possibly filegroups if supported (one per CPU equal size?)

    The 1 per CPU, equal size is an old and outdated recommendation for TempDB only....

    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 13, 2012 at 11:26 am

    #1446402

  • RE: SELECT statement takes about 30 seconds to complete... should I use NO LOCK to reduce potential blocking? (pros/cons)

    kschwid (2/13/2012)

    Well in my case Stored Procedures are used for Reporting Purposes and no I don't care because you report on the day, week, month prior. So the data shouldn'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

    February 13, 2012 at 11:25 am

    #1446401

  • RE: backup tool

    I think you're mixing up backup compression and database compression. Backup compression compresses the backup and does not care what is in the backup. As far as the backup process...

    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 13, 2012 at 9:09 am

    #1446316

  • RE: SELECT statement takes about 30 seconds to complete... should I use NO LOCK to reduce potential blocking? (pros/cons)

    Err, not exactly. Data modifications put the older versions into TempDB so that selects can read them if necessary.

    First thing though is to see if you really do have blocking,...

    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 13, 2012 at 9:06 am

    #1446314

  • RE: SELECT statement takes about 30 seconds to complete... should I use NO LOCK to reduce potential blocking? (pros/cons)

    Assuming you have severe blocking (and not just slow queries), have you considered snapshot or read committed snapshot isolation levels?

    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 13, 2012 at 8:42 am

    #1446287

  • RE: back up into many disks

    Dev (2/13/2012)

    That’s why I said hot (exact) / warm (with some lag) standby server. Server that is lagging (intentionally) behind can help me in getting last night’s data.

    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

    February 13, 2012 at 7:53 am

    #1446252

  • RE: back up into many disks

    Dev (2/13/2012)

    Those are HA/DR, not backups. They're great for HA/DR, but pretty useless when you need to get last night's data.

    I have another question now. Does it mean...

    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 13, 2012 at 7:23 am

    #1446227

  • RE: back up into many disks

    Dev (2/13/2012)

    Just for clarity, what do you mean by "duplicating database is beter than taking backups"?

    Hot / Warm standby servers.

    Those are HA/DR, not backups. They're great for...

    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 13, 2012 at 6:56 am

    #1446213

Viewing 15 posts - 20,341 through 20,355 (of 49,552 total)