Forum Replies Created

Viewing 15 posts - 17,536 through 17,550 (of 49,552 total)

  • RE: How Many type of Function in SQL Server ?

    lokeshvij (7/19/2012)

    Further to add on; scalar functions are always deterministic.

    Sure about that?

    All scalar udfs will always return the same value if called multiple times with the same parameter?

    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

    July 19, 2012 at 11:20 am

    #1515034

  • RE: Optional parameters in WHERE clause

    pdanes (7/19/2012)

    Thanks, that also helped clear up some confusion about injection for me. I have been assembling query strings without really understanding how to proof them against injection - I...

    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

    July 19, 2012 at 10:37 am

    #1514996

  • RE: Optional parameters in WHERE clause

    pdanes (7/19/2012)

    I've just assembled this:

    I would recommend not doing that. If you want to go that way, create multiple procs and call them from within the IFs. The selects within...

    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

    July 19, 2012 at 10:33 am

    #1514993

  • RE: Optional parameters in WHERE clause

    Dynamic SQL or OPTION RECOMPILE (if you're on 2008 SP2 or above). Test the recompile, make sure it really does help.

    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

    July 19, 2012 at 9:59 am

    #1514966

  • RE: Are the posted questions getting worse?

    The Lost Fleet series is excellent.

    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

    July 19, 2012 at 5:37 am

    #1514762

  • RE: SQL Server 2005 High Memory Usage gradually over time

    In short, max server memory's not configured properly. If that's left at default, SQL thinks it can use up to 2000 TB of memory. Probably OK if you have 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

    July 18, 2012 at 3:52 pm

    #1514562

  • RE: can any solve ny problem iam facing error in a funtion?

    Well firstly I would suggest that you discard that function entirely. If that's intended to be called as part of a larger query it's going to perform abysmally, at best....

    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

    July 18, 2012 at 3:23 pm

    #1514555

  • RE: WAIT TYPE SOS_SCHEDULER_YIELD - Scheduler / Worker Issue SQLOS?

    b.hedge (7/18/2012)

    Found out that all Log file LUNs for multiple server were stored in the same disk group and was ~75 % subscribed. They also bypass cache and update...

    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

    July 18, 2012 at 2:07 pm

    #1514534

  • RE: Geeky Books

    If you like your books deep, try Foucault’s Pendulum. I struggled through it. Interesting though.

    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

    July 18, 2012 at 1:39 pm

    #1514520

  • RE: Down grade from enterprise to standard in sql 2008r2

    Uninstall, reinstall. First make sure you're not using any persistent enterprise only features

    SELECT * FROM sys.dm_db_persisted_sku_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

    July 18, 2012 at 1:19 pm

    #1514496

  • RE: Mirroring to multiple databases possible?

    Another option: Mirror for automatic failover (synchronous with witness) and log ship to a 3rd site for extra redundancy.

    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

    July 18, 2012 at 1:12 pm

    #1514490

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/18/2012)

    WayneS (7/18/2012)

    Gianluca Sartori (7/18/2012)

    SQLRNNR (7/17/2012)

    Congrats to Gail and Grant on the new book coming out in November.

    http://www.apress.com/9781430247708

    Here's another one coming out in August (by a...

    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

    July 18, 2012 at 12:50 pm

    #1514472

  • RE: Mirroring to multiple databases possible?

    Kiran.Baderdinni (7/18/2012)

    Won't a bad page in the tran log backup (any of the hourly tan backup) have the same outcome?

    Corruption is from something in the IO subsystem stamping on a...

    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

    July 18, 2012 at 12:44 pm

    #1514465

  • RE: Mirroring to multiple databases possible?

    Kiran.Baderdinni (7/18/2012)

    The over-arching concern I have with LS is that 'page corruptions' will propogate to the secondaries.

    No they won't. Not unless the corruption is in the initial full backup used...

    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

    July 18, 2012 at 12:37 pm

    #1514456

  • RE: SQL Server 2005 High Memory Usage gradually over time

    loda117 (7/18/2012)

    why isn't SQL letting go of some of the memory once it allocates it 🙁

    Because it's designed not to. What you're seeing there is documented, by design behaviour.

    See...

    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

    July 18, 2012 at 12:34 pm

    #1514452

Viewing 15 posts - 17,536 through 17,550 (of 49,552 total)