Forum Replies Created

Viewing 15 posts - 331 through 345 (of 3,221 total)

  • RE: Tlog space getting full whcle executing the Update statement

    Post your actual T-SQL statement.. some one will be able to show you how to run that for a reasonable number of rows, then take a log file backup, and...

    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: A printable list of T-SQL commands

    go here and print away

    http://www.sqlserverspace.com/SQLServerReservedWordList.html

    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: Basic of T-SQL

    Now the question was a good question on the basics, I am NOT disputing that !

    [rant]

    http://msdn.microsoft.com/en-us/library/ms175997.aspx

    From the above reference (bolding added for emphasis)

    COUNT(*) returns the number of rows in a...

    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: only get data with special pattern

    Be very, very careful about using ISNUMERIC .. for example, altering your input data slightly to more readily see the possible problem.

    DECLARE @Codes TABLE (Code VARCHAR(100),LineNr INT)

    ...

    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: Table Variable

    Stewart "Arturius" Campbell (8/16/2012)


    Good question, thanks.

    Learned something here.

    +1

    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: Monitoring table data validity

    This might give you a view ideas of what you can do

    http://msdn.microsoft.com/en-us/library/bb522489(v=sql.100).aspx

    The other item I would draw to your attention. What are the terms of the purchase/lease of the...

    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: Are the posted questions getting worse?

    L' Eomot Inversé (8/14/2012)


    Lynn Pettis (8/14/2012)


    Brandie Tarvin (8/14/2012)


    I get ideas from the weirdest places. I keep threatening to write stories about you people and never do. Well, this debate has...

    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: BIT Conversions

    One of the things that I'm trying to learn is to write better QotD questions. It looks like most that have responded here about missing it have acknowledged not reading...

    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: DATEADD function

    L' Eomot Inversé (8/11/2012)


    Nice easy question to start the week with (2 days early).

    I wonder if the 100% correct rate will continue when everyone sees it and starts answering on...

    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: Constraint Event Order

    Rather suprised by the distribution of answers for such a basic question

    Correct answers:

    37%

    (68)

    Incorrect answers:

    63%

    (118)

    Total attempts: 186

    From a teaching aspect this question is full filling a major QOD objective

    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: Constraint Event Order

    Thanks for the question. But using answers given on Stack Overflow as support for the correct answer, is rather weak, and lame.

    There is a reference on msdn to support...

    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: SQL Server 2008 R2 Express version with advanced services and Developer Edition

    The DEVELOPER edition contains all the features that the ENTERPRISE edition contains.

    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    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: Import data from excel and load into sql server

    Is

    Test01 test02 test03 test04 test05

    -----------------------------------------------------

    State2_J State4_A ...

    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: ISNULL

    Back to the basics .. nice question

    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: Are the posted questions getting worse?

    Sean Lange

    I think the real concern is the additional administration by Steve to keep this all moving. What happens when a question does not meet the standards or there is...

    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 - 331 through 345 (of 3,221 total)