Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 14,953 total)

  • RE: Where are the good Senior Level DBA's?

    Yep. We've had plenty of discussion on "how can you define 'Senior DBA' when you can't even define 'DBA'?"

    I'm an adequate database administrator. I know not to put...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 1:53 pm

    #1401829

  • RE: Subquery With Aggregates and Pivot

    I'd have to see the whole query to really nail this one down.

    Is it in the form of?:

    select CompanyName, AccountNumber, County, Territory, SalesCount

    from dbo.Accounts as PT

    left outer join

    ...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 1:43 pm

    #1401820

  • RE: XQuery where clause with between operator question

    Try this:

    declare @x xml

    declare @f bit

    set @x = ' <Answer code="Text" data="2011-10-25" />'

    set @f = @x.exist('.[(concat(string((/Answer/@data)[1]), "Z") cast as xs:date?) eq xs:date("2011-10-25Z")]');

    select @f

    You can also programmatically generate the date to...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 12:19 pm

    #1401772

  • RE: Can't use a dynamic connection manager with Data Flow Task

    That's precisely what Delayed Validation is for.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 9:05 am

    #1401681

  • RE: Stored procedure performance

    The problem for me isn't money. It's that there's no way for me to "copy and paste into SSMS and run the query", since I don't have the tables,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 7:08 am

    #1401592

  • RE: Can't use a dynamic connection manager with Data Flow Task

    In the properties of any connection in SSIS, you can use an Expression for the Connection String, and can control the connection dynamically that way.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:54 am

    #1401586

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/31/2011)

    Steve Jones - SSC Editor (10/31/2011)

    Congrats, Gail.

    I am not putting as much effort into the discussions lately with all the travel. Not likely to change, either, so I think...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:48 am

    #1401580

  • RE: Flexible filters - can XML be used to avoid lots of "or xxxx IS NULL"?

    paul.jones (11/1/2011)

    Thanks for the suggestions - it may be I'm ruling out dynamic SQL unnecessarily and I'll look into it. Not sure what is meant by name-value pairs?

    As for examples,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:43 am

    #1401575

  • RE: How to Import multiple .csv files into different tables

    "Select Into" will replicate the columns of the data-source into a new table. You can use dynamic SQL to build the query so that you can name the table...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:39 am

    #1401571

  • RE: Happy Halloween 2011

    djackson 22568 (10/31/2011)

    GSquared (10/31/2011)

    I usually go as a computer geek on Halloween.

    I assumed you went as Picard or Data!

    Dave

    Those are Star Trek characters, right? I've heard of them.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:34 am

    #1401567

  • RE: Where are the good Senior Level DBA's?

    If all a company is looking for is speed-of-query, then hardware is almost certainly cheaper than a good DBA.

    However, if that's all they're looking for, then they don't know what...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    November 1, 2011 at 6:30 am

    #1401566

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/31/2011)

    We all knew this was coming....

    Edit : And here's the kicker... Attachment # 10111. Only 1 bit of being #1 all across the board :w00t:.

    Grats Gail!

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    October 31, 2011 at 12:25 pm

    #1401241

  • RE: Flexible filters - can XML be used to avoid lots of "or xxxx IS NULL"?

    In SQL 2008, you could probably do name-value pairs, either in XML or (probably better) a Table Value Parameter, and then join to that using some variation of Outer Join.

    I'll...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    October 31, 2011 at 11:31 am

    #1401234

  • RE: SQL server does not allow remote connection(SQL express edition)

    In SQL Configuration Manager, what connection types have you allowed?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    October 31, 2011 at 11:27 am

    #1401232

  • RE: Where are the good Senior Level DBA's?

    There's definitely demand for senior DBAs. I get several calls per month from recruiters.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

    October 31, 2011 at 11:26 am

    #1401231

Viewing 15 posts - 3,001 through 3,015 (of 14,953 total)