Forum Replies Created

Viewing 15 posts - 7,081 through 7,095 (of 26,490 total)

  • RE: The Abstract DBA

    Eric M Russell (12/12/2013)

    ...

    Why pay a contractor $100,000+ a year to shuffle your backup tapes and network logins, when they could hire a full time staff member for half...

    December 12, 2013 at 9:15 am

    #1673001

  • RE: The Abstract DBA

    jim.drewe (12/11/2013)

    Lynn

    I normally don't follow up on these types of tracks, but I think what I was trying to say (and presumably what the other gentlemen was also trying to...

    December 11, 2013 at 7:53 pm

    #1672815

  • RE: The Abstract DBA

    Eric M Russell (12/11/2013)

    Lynn Pettis (12/11/2013)

    Eric M Russell (12/11/2013)

    jim.drewe (12/11/2013)

    Eric ... I would heartily agree. Unfortunately, executives in publicly held companies listen to Wall Street, not the common sense...

    December 11, 2013 at 4:55 pm

    #1672791

  • RE: The Abstract DBA

    Eric M Russell (12/11/2013)

    jim.drewe (12/11/2013)

    Eric ... I would heartily agree. Unfortunately, executives in publicly held companies listen to Wall Street, not the common sense from subordinates. If Wall...

    December 11, 2013 at 9:34 am

    #1672680

  • RE: SELECT question

    Luis Cazares (12/9/2013)

    You could use EXCEPT

    SELECT SSN , PKT , FICE_NBR

    FROM A

    EXCEPT

    SELECT SSN , PKT , FICE_NBR

    FROM B

    This?

    with baserecs as (

    SELECT SSN , PKT , FICE_NBR

    FROM TableA

    EXCEPT

    SELECT SSN , PKT...

    December 9, 2013 at 5:53 pm

    #1672184

  • RE: Set based super challenge

    I may have an idea on how to do this, I just don't have time to convert the info in your text file into DDL and DML statements to do...

    December 9, 2013 at 5:45 pm

    #1672183

  • RE: query won't give same result on SQL 2000 and SQl 2008

    Dominic Gagné (12/9/2013)

    thanks a lot everyone for your replies.

    I'll see if I can do something with the indexes on the tables

    That still will not guarantee the order of the final...

    December 9, 2013 at 1:20 pm

    #1672116

  • RE: query won't give same result on SQL 2000 and SQl 2008

    Dominic Gagné (12/9/2013)

    I can't add the ORDER BY, I don't have the source code of the application.

    Why the data are returned perfectly in the SQL 2000 and the same query,...

    December 9, 2013 at 11:49 am

    #1672090

  • RE: sql 2008 std to 2008 r2

    Ratheesh.K.Nair (12/9/2013)

    Editions of SQL Server is not a problem when you do the restore its Version that matters and SQL server don't have backward compatibility.

    Not completely true, if you have...

    December 9, 2013 at 8:35 am

    #1671976

  • RE: display order by houseno

    One, reposting on a new thread isn't going to get you different answers.

    Two, on your original thread, please post the code you are using. You should also take the...

    December 7, 2013 at 11:00 am

    #1671729

  • RE: Backup and restoration scenario need perfect answer

    What do you think is the solution? By the way, there is no perfect solution.

    December 7, 2013 at 8:53 am

    #1671724

  • RE: Should big tables with more cols be breaken into two tables?

    Mark Eckeard (12/6/2013)

    Did you look at the execution plan on the query to see if there are any bottlenecks or possible improvements?

    Do you have proper indexes on the tables based...

    December 6, 2013 at 8:47 am

    #1671559

  • RE: Are the posted questions getting worse?

    GilaMonster (12/4/2013)

    In unrelated news, slightly belated drum rolls please..

    <---------

    Congratulations!

    December 5, 2013 at 7:07 am

    #1671075

  • RE: Are the posted questions getting worse?

    SQLRNNR (12/4/2013)

    SQLRNNR (12/4/2013)

    Lynn Pettis (12/4/2013)

    Steve Jones - SSC Editor (12/4/2013)

    Lynn Pettis (12/4/2013)

    There could easily be routers and firewalls configured that are preventing us from using Linked Servers. Lets just...

    December 4, 2013 at 3:27 pm

    #1670876

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (12/4/2013)

    Lynn Pettis (12/4/2013)

    There could easily be routers and firewalls configured that are preventing us from using Linked Servers. Lets just say this site is...

    December 4, 2013 at 1:28 pm

    #1670842

Viewing 15 posts - 7,081 through 7,095 (of 26,490 total)