Forum Replies Created

Viewing 15 posts - 166 through 180 (of 3,221 total)

  • RE: Data compression

    Nice question on basics ....

    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]

    January 29, 2013 at 8:46 pm

    #1582451

  • RE: CHOOSE - 1

    Hugo Kornelis

    I am surprised to see that you responded to one post, but didn't respond in any way to the criticism from other posts. With that, you create the appearance...

    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]

    January 29, 2013 at 8:53 am

    #1582185

  • RE: CHOOSE - 1

    davoscollective

    A lot of people are complaining about not having SQL Server 2012 or Adventureworks on production machines. I have a test/dev VM with SQL Server 2012 SP1 and both 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]

    January 29, 2013 at 6:46 am

    #1582106

  • RE: Help on how to count guests in hotel every day

    Maple07-598122 (1/25/2013)

    I have a table keeps guest records in a hotel. For each guest I have check in date and check out date. If I want to know how many...

    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]

    January 25, 2013 at 3:23 pm

    #1581224

  • RE: Create string using input values

    Here is another method .... not efficient .... not recommended ... but it does what you seem to need to do.

    DECLARE @BegYr INT = 2013

    ...

    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]

    January 25, 2013 at 11:51 am

    #1581173

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (1/25/2013)

    Are the posted posts about the posted questions and posted answers getting posted worse-ly than previous posters posted in the posted past?

    NO, NO, NO, YES...

    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]

    January 25, 2013 at 10:58 am

    #1581150

  • RE: Online training for sql 2012 ( focus on performance )

    Check out any training given by Paul Randal. ... just search using google for his latest schedule, and check out his blog ... has lots of free training available from...

    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]

    January 23, 2013 at 7:18 pm

    #1580331

  • RE: Grouping Active units by YYYYMM

    To assist those who can and want to help you ... please post table definition, some sample data.

    To do so click on the first link in my signature block. ...

    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]

    January 23, 2013 at 9:29 am

    #1580170

  • RE: An oddball survey, seeing as I'm looking at a new car...

    Lamborghini - hope your pocket book is as great as your taste in cars.

    Me Mercedes (Diesel) excellent milage .. long trips at avg speed 70+ ... 39 mph using...

    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]

    January 21, 2013 at 1:19 pm

    #1579367

  • RE: EOMONTH - 1

    Revenant (1/21/2013)

    Ron, as always I love your question. Please keep them comin'!

    Thank you .. coming from one as knowledgable as you about sql ... it is an honor

    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]

    January 21, 2013 at 1:14 pm

    #1579364

  • RE: Import data from one table to another excluding any duplicates help

    Look at using the MERGE statement

    http://technet.microsoft.com/en-us/library/bb510625(v=sql.100).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]

    January 21, 2013 at 10:59 am

    #1579332

  • RE: Are the posted questions getting worse?

    john.arnott (1/18/2013)

    SQLRNNR (1/18/2013)

    Lowell (1/18/2013)

    Brandie Tarvin (1/18/2013)

    All we need is an actual Go Faster flag for the database, and everything will be FINE.

    got your fix right here:

    I need one of those

    Funny...

    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]

    January 18, 2013 at 7:01 pm

    #1578918

  • RE: SQL Server 2012 Express Management Studio does not show columns of tables in tempdb

    Can you post your actual T-SQL might help us help you

    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]

    January 18, 2013 at 4:54 pm

    #1578908

  • RE: Number of Rows

    Dave62 (1/18/2013)

    bitbucket-25253 (1/18/2013)

    ...

    Been there done that ... the message tab is NOT, let me repeat, the message tab in NOT part of the estimated execution plan

    I think the message tab...

    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]

    January 18, 2013 at 2:05 pm

    #1578882

  • RE: Number of Rows

    Dave62 (1/18/2013)

    L' Eomot Inversé (1/18/2013)

    ...

    So either I am missing something, or there's been a change in behaviour between 2008+SP3 and 2008R2+SP3.

    Try this:

    1) Paste code into SSMS query analyzer

    2)...

    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]

    January 18, 2013 at 12:11 pm

    #1578842

Viewing 15 posts - 166 through 180 (of 3,221 total)