Forum Replies Created

Viewing 15 posts - 31 through 45 (of 3,221 total)

  • RE: Index Help Utility

    Thanks for an easy question .... now a question of my own "Is this QOD an Xmas present ?"

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Today's Random Word!

    crookj (12/6/2013)


    Cool (-6 degrees outside)

    Snow

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Thanksgiving 2013

    D.Oc (11/28/2013)


    Happy Thanksgiving to all!!!

    May the turkey be tender and juicy and the people you're celebrating with be the ones you love and care about.

    +100

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Output a query as an Excel file

    Here is an adhoc method, to run when you want ... uses just the basics

    http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: List of SQL Server Express gotchas?

    There are three (3) versions of SQL Express

    Express

    Express with Advanced Services

    ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Most frequent used stored procedures without access to system tables

    From:

    http://glennberrysqlperformance.spaces.live.com/default.aspx

    Try this

    SELECT TOP 100 qt.text AS 'SP Name', qs.execution_count AS 'Execution Count',

    qs.execution_count/DATEDIFF(Second, qs.creation_time, GetDate())...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: ISOLATION LEVELS

    Try reading this:

    http://gavindraper.com/2012/02/18/sql-server-isolation-levels-by-example/

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Patch SQL 2008 Express

    Yes you can. To obtain the latest patch and how to use it go here:

    http://www.microsoft.com/en-us/download/details.aspx?id=20610

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: UNION

    Nice QOD to start the week ---- Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Nested Transactions

    Nice question on the fundamentals ..

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: palindrome

    declare @count int

    declare @charvaluefront varchar

    declare @charvalueback varchar

    declare @frontpos int

    declare @backpos int

    select @count=len('ABC')

    ...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Transaction

    Too simple .....

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: STR

    So nice to be reminded of the fundamentals ... Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: What happens to a variable after COMMIT or ROLLBACK

    A very back to basics question ...... Thanks

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • RE: Finding and picking from Duplicates...

    RedBirdOBX (10/4/2013)


    Thanks Ron! I was just working on the Temp table approach. Will try and post back....

    The temp table - I only selected it, since I do NOT have...

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

Viewing 15 posts - 31 through 45 (of 3,221 total)