Forum Replies Created

Viewing 15 posts - 3,706 through 3,720 (of 18,926 total)

  • RE: Courses?

    Rob-350472 (8/5/2011)


    I've been using SSRS for a few months but I seem to run into problems with a few things and then sometimes am able to solve them via the...

  • RE: Deadlock question

    GilaMonster (8/5/2011)


    Extended events are a SQL 2008 feature.

    Running something by y'all.

    Let's say I run a trace for replay on 2K5. Replay on 2K8 R2 dev. Would those...

  • RE: Courses?

    There's a heck of a lot of excellent free videos on the web.

    IE : http://pragmaticworks.com/Resources/webinars/Default.aspx

    Disclaimer, you need to create an account and give them your e-mail.

    Once you've been through those...

  • RE: Delete ON Self Join

    Maybe a better case would be Employee, supervisor, teams...

    Won't get you any "you need to redo the design" types of answers.

  • RE: Conversion of a varchar data type to a datetime data type

    I have a similar problem in our ERP app.

    One way I was able to fix it (because all the dates were actually real dates) was to do

    SET DATEFORMAT YMD...

  • RE: Deadlock question

    GilaMonster (8/5/2011)


    Extended events are a SQL 2008 feature.

    TX, one more point for my upgrade request :-D.

  • RE: is the backup really running

    Taking a stab at it but I'm out of my confort zone.

    Both of those mean waiting on disks. Suggested to check with perfmon to find the exact issue.

    BACKUPBUFFER seems...

  • RE: Deadlock question

    Anyway to get this to work on 2k5? I'm on CS server so that might just be it but I can't seem to be able to link dm_xe_session_targets...

  • RE: question about upgrading sql2008 r2 standard

    danschl (8/5/2011)


    actually most of my databases are still in sql2000 mode

    still i thouhgt in the past it flat wouldnt let you change from enterprise to standard without a rebuild

    Even if...

  • RE: checkdb running on it's own?

    GilaMonster (8/5/2011)


    Ninja's_RGR'us (8/5/2011)


    How do you define seldom and what's the "usual" delay to bring it back online (ms or s)?

    The same way I define 'often', 'most', etc. Relative to what...

  • RE: checkdb running on it's own?

    How do you define seldom and what's the "usual" delay to bring it back online (ms or s)?

  • RE: question about upgrading sql2008 r2 standard

    I don't know about the install part of it. But if you ARE using enterprise features and try to do the restores to standard. The restore will run...

  • RE: checkdb running on it's own?

    GilaMonster (8/5/2011)


    btw, if you're getting that in the middle of the day it means that the database closed and SQL opened it again. That's only printed when SQL brings a...

  • RE: No Parallelism When using Row level function

    TheSQLGuru (8/5/2011)


    Leo.Miller (8/4/2011)


    I've run some tests ranging from a few hundred rows to a few million rows, and in most cases using the inline case is more efficient than passing...

  • RE: is the backup really running

    Denise McMillan (8/5/2011)


    From sp_who2:

    Status Dbname Command ...

Viewing 15 posts - 3,706 through 3,720 (of 18,926 total)