Forum Replies Created

Viewing 15 posts - 5,026 through 5,040 (of 14,953 total)

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

    At 11 pages, it better have a better plot, more engaging bad guy, and a more exciting hero, than most resumes I've read! 🙂

    - 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

  • RE: Are the posted questions getting worse?

    newdb (2/10/2011)


    Yes I agree that some of the question posted - you can get the answer from BOL or from other posts, but on the other hand I can understand...

    - 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

  • RE: SSMS Not installing

    In the installation options, did you make sure Client Tools included SSMS? Does your installation media include that option?

    - 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

  • RE: Are the posted questions getting worse?

    Kit G (2/9/2011)


    To those Threadzians (and everyone else) getting hit by the latest winter storm, stay warm and safe.

    And to those in Florida who can't deal with frigid, sub-70 Farenheit...

    - 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

  • RE: Maintaining Parallel environments

    It's not easy, and not practical.

    Here's the simplest reason why: If you add a new column to PreProd (what most would call Dev), how does the data in that stay...

    - 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

  • RE: Evaluation/Free version of SQL?

    Evaluation Edition is Enterprise and stops working after something like 6 months.

    Express Edition is free, but has limits on what it can do. If the class covers features it...

    - 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

  • RE: Force Package not to fail

    It'll depend on what you're trying to do and what error(s) you're getting.

    If, for example, you want the package to "succeed" even if it's unable to connect to any servers...

    - 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

  • RE: Membership Database schema incl. 12 monthly renewals

    Jack Corbett (2/9/2011)


    I probably wouldn't use a view because I like to use SP's for all data access so the query would just go in the SP as is, but...

    - 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

  • RE: Export Sysusers table from all databases to flat file?

    Check out Red Gate's Multiscript product (link at top of the page).

    Otherwise, take a look at sp_MSForEachDB. That'll probably get you most of the way there.

    - 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

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (2/9/2011)


    GSquared (2/9/2011)


    Stefan Krzywicki (2/9/2011)


    GSquared (2/9/2011)That and the thread on "Where do you find DBAs" have made me wonder more about how managers pick DBAs. I know how...

    - 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

  • RE: Password expired and Deactivate logon Id

    There's probably a way to do it through policy management.

    You might be able to get "good enough" by just querying sys.sql_logins. The modify date updates if the data is...

    - 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

  • RE: Database Mail not being sent

    Have you checked the db mail tables in msdb? I find looking in those tremendously helpful for oddball issues with that feature.

    - 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

  • RE: Changing db owner script

    I'll recommend Red Gate's Multiscript product for that kind of thing.

    If you can't get that (check the link at the top of this site), then a dynamic SQL script that...

    - 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

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/9/2011)


    jcrawf02 (2/9/2011)


    Anybody have suggestions (blog/thread/article/advice) for me on how to find whether a value in one column contains a value in a different table's column?

    Currently I'm doing...

    - 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

  • RE: Are the posted questions getting worse?

    GilaMonster (2/9/2011)


    ALZDBA (2/9/2011)


    GilaMonster (2/9/2011)


    ...

    To put things in context, my desktop (which I'll be using for this) blue screened this morning then, on reboot failed POST repeatedly.

    Am hoping it's a once-off,...

    - 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

Viewing 15 posts - 5,026 through 5,040 (of 14,953 total)