Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 3,221 total)

  • RE: when you do Union all, does the order of the columns matter? (sql server 2008))

    Simply put .. Yes it does

    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: Study material\dumps for Exam 70-450

    1. If you do not know how to use Goggle to find "braindumps", I doubt if and when you find one, you will be able to understand it, or...

    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: Convert string to datetime

    Provided that EDT is NOT required this is one way, and for a million rows it will NOT be quick.

    DECLARE @T VARCHAR(20)

    SET @T = 'July 7 2011 12:47 pm EDT'

    SET...

    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: Restoring Features

    paul s-306273

    Way back in the beginning, to make the site more attractive to those interested in Microsoft's SQL Server the founders decided to award points to the site users....

    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: Career Advice

    Become a member of PASS, find a local SQL Server user group

    http://www.sqlpass.org/PASSChapters/USNortheast.aspx

    Attend the meetings, introduce your self to other attending. In our user group frequent meeting sponsor(s) are consulting...

    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: delete without commit

    You can, but remember the old irish saying "There is many a slip between the cup and the lip"

    Set up a test database or sandbox as I call it

    Test your...

    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: run sprocs with date

    Here is another method to add 1 year and 1 day as the OP requested

    DECLARE @EndDate VARCHAR(10)

    DECLARE @StartDate VARCHAR(12)

    SET @EndDate = '07/15/2011'

    SET @StartDate = DATEADD(DD,1,DATEADD(YY,1,(CAST(@EndDate AS DATETIME))))

    SELECT CONVERT(DATETIME,@StartDate,101)...

    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: Query to calculate Turnaround Time

    I wrote a query that gives me all the cases from a single room and a single day, but I'm struggling how to identify the "previous" case end time.

    ...

    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: Did you notice SSC has passed the 1,400,000 members mark

    Did not notice until looking through the Forums and seeing this post of yours. While I agree it is a fantastic number of members, I also wonder 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]

  • RE: NUMA

    The source cited has the following statement:

    Nodes are created per physical NUMA memory nodes

    But, as it always is, how does one determine the number of soft NUMA nodes?

    Anyone.

    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: Article about server slowness/failures/showdowns

    An immediate source - In the left pane of an SSC page click on Books. Scroll through the list and you will find at least two available in...

    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: We Need a DBA Boot Camp

    1. Yes U.S. Army 1955 - during what was called the Korean Police Action, and received a 2nd Lts salary.

    2. I believe it would be an excellent idea...

    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: Rookie DBA

    Now this in NOT a quick technique to find a job, but something you might / should investigate for the longer term. Locate your nearest local chapter of...

    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: Cloud Barriers

    Jeff, gotcha beat on that dropping the cards - always sequence punched the cards in what (memory failing me) in columns 72 - 80. Then when I did drop...

    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: Cloud Barriers

    Jeff Moden

    None of these restrictions or limitations are new to us old farts. The only real difference that I can see between the Cloud and an old IBM Mainframe 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 - 1,111 through 1,125 (of 3,221 total)