Forum Replies Created

Viewing 15 posts - 4,291 through 4,305 (of 5,685 total)

  • RE: Date range query slow on a date as varchar

    This will still get you incorrect results. You're avoiding the conversion this way, which is then avoiding finding the correct values.

    Let me show you what's happening.

    You have 5 dates:

    DECLARE...

    January 21, 2011 at 2:00 pm

    #1276791

  • RE: Should SSIS sit on its own server?

    Jeffrey Williams-493691 (1/21/2011)

    Michael Valentine Jones (1/21/2011)

    We have been using centralized servers for DTS and SSIS for several years for packages that mainly produce scheduled customer reporting deliverables like spreadsheets.

    A big...

    January 21, 2011 at 1:39 pm

    #1276781

  • RE: Where do you look for DBA's?

    This topic is near and dear to me, so it's been percolating in my brainpan a few days now. Ferguson, tell me what you think of the following as...

    January 21, 2011 at 12:58 pm

    #1276750

  • RE: Are the posted questions getting worse?

    bitbucket-25253 (1/21/2011)

    LutzM (1/21/2011)

    GilaMonster (1/21/2011)

    ...

    Yes, and I got a second meeting invite for Monday afternoon. Accepted that cause I just don't feel like fighting any more.

    Unfortunately, a term like "mañana" seems...

    January 21, 2011 at 12:26 pm

    #1276733

  • RE: Where do you look for DBA's?

    Brandie Tarvin (1/21/2011)

    Hey, Craig, even us non-employer types are learning a lot from this discourse. I've learned a lot about job descriptions just by reading your responses (and Gail's).

    Thanks.

    Thanks for...

    January 21, 2011 at 11:38 am

    #1276719

  • RE: Need a solution for this sql query

    Guvera (1/21/2011)

    Hi,

    Thanks for your reply. I am using PIVOT table concept already. I am using Oracle 10g. 10g version is not supported PIVOT Table.

    Thats why i think that using sql...

    January 21, 2011 at 3:02 am

    #1276436

  • RE: Need a solution for this sql query

    Lookup the PIVOT function. You'll have to create a column in the table/result set that the PIVOT will work from that will give names to each row though. ...

    January 21, 2011 at 2:22 am

    #1276423

  • RE: Are the posted questions getting worse?

    Jeff Moden (1/20/2011)

    Koen (da-zero) (1/19/2011)

    WayneS (1/19/2011)

    This thread has made me realize that I suck in deciphering job descriptions. Craig, hurry up with your articles - I need the help!!!

    At my...

    January 20, 2011 at 7:24 pm

    #1276340

  • RE: Where do you look for DBA's?

    Ferguson,

    Just a note. I know it looks like I'm abusing you and/or your intentions. I'm really not trying to flog this. I'm hoping that you're not the...

    January 20, 2011 at 3:30 pm

    #1276284

  • RE: Where do you look for DBA's?

    Ferguson (1/20/2011)

    To the comments on words, inconsistencies in the descriptions -- got it. These things get written by committees, and clearly the result reflects it. There is a...

    January 20, 2011 at 12:45 pm

    #1276205

  • RE: Where do you look for DBA's?

    Ninja's_RGR'us (1/20/2011)

    In all those instances, I did my due dilligence and figured out what the market is where I was going to contract... 75$/H is on the low range...

    January 20, 2011 at 12:26 pm

    #1276193

  • RE: Where do you look for DBA's?

    Ferguson (1/19/2011)

    Craig, thanks.

    It is senior, not sure where you saw it was not, I did not post the actual position description in full. Should have. it is...

    January 19, 2011 at 9:24 pm

    #1275659

  • RE: Query to Rip the X & Y from a Geometry column

    Since this sat around a bit here, I'll ask the obvious. Can you post the DDL and a few rows of sample data here, specifically for the Map table?...

    January 19, 2011 at 4:55 pm

    #1275618

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/19/2011)

    GilaMonster (1/19/2011)

    Craig Farrell (1/19/2011)

    Anyone know what brand of cookies (or cigars) the current MVPGA likes? 😉

    Bribing a committee is an expensive proposition. :hehe:

    Bribing witnesses can be even more...

    January 19, 2011 at 3:54 pm

    #1275610

  • RE: Are the posted questions getting worse?

    GilaMonster (1/19/2011)

    Craig Farrell (1/19/2011)

    Side note: How does one become a MS SQL MVP? My google-fu is failing miserably.

    You get a nice little email from MS on the first day...

    January 19, 2011 at 3:16 pm

    #1275600

Viewing 15 posts - 4,291 through 4,305 (of 5,685 total)