Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 5,678 total)

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (11/23/2010)

    Topic changer:

    I want to bring up the age old question related to books.

    If you were to buy a SQL book, what would you buy? If there is a...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 23, 2010 at 10:44 am

    #1254601

  • RE: Are the posted questions getting worse?

    GilaMonster (11/23/2010)

    Craig Farrell (11/23/2010)

    Yep, one definately has job security, and I actually don't consult the way Gail and the rest do to clean up systems, I just travel as a...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 23, 2010 at 10:38 am

    #1254599

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/23/2010)

    GilaMonster (11/23/2010)

    Grant Fritchey (11/23/2010)

    I see how you consultants keep making money though. Seems like these shops are mushrooms. They're springing up all over the place.

    There are stories I...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 23, 2010 at 10:12 am

    #1254580

  • RE: Converting Rows into Columns

    For a fast explaination, a fast answer. You're looking for the PIVOT command. Quite handy.

    If you'd like more tested code, please see the first link in my signature...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 23, 2010 at 10:03 am

    #1254568

  • RE: Identity messed up on merge replication

    Dominic Gagné (11/23/2010)

    thanks for the hints. I was figuring something like that to "rescue" the data on subscribers. that'll be a pain, but, no pain no gain! 🙂

    thanks all for...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 23, 2010 at 9:58 am

    #1254564

  • RE: SQL Row Level Security in a Relational World?

    Peter Jenks (11/22/2010)

    The main point of this thread was to see if the wider commiunity had come up with something better or more elegant. I'm sure this isn't unique...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 4:32 pm

    #1254114

  • RE: SQL Row Level Security in a Relational World?

    What is your difference between Finance 1 and Production 1, or is that overlap on purpose?

    In your current model, his restriction on Finance is reduced to 3 records, but his...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 4:09 pm

    #1254111

  • RE: Can SQL Job schedules be used by more than 1 job?

    WayneS (11/22/2010)

    Craig Farrell (11/22/2010)

    I wouldn't do this, too hard to realize what-all is connected to the same schedule.

    Really?

    In SSMS, open up a job. In the Job Properties screen, select...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 3:58 pm

    #1254107

  • RE: Verifying Backups and status

    Vertigo44 (11/22/2010)

    Is there some kind of SQL injection protection going on? Whenever I try to post code the server just hangs. However if I just post text like this there...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 3:01 pm

    #1254084

  • RE: Can SQL Job schedules be used by more than 1 job?

    Yes. And if you change the schedule on one job, you change everyone who's got the same schedule.

    I found this only really useful when I needed to do some...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:59 pm

    #1254083

  • RE: SQL Row Level Security in a Relational World?

    Peter Jenks (11/22/2010)

    Okay, thanks for your comments.

    Has anyone else tried something like this? I'm keen to hear of your experiences.

    Not necessarily a helpful answer, but one none-the-less... Yes, I've...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:55 pm

    #1254081

  • RE: Identity messed up on merge replication

    Dominic Gagné (11/22/2010)

    new snapshot from the publisher, applied to the subscriber, will replace existing data by the publisher's data, am I right? How can I do otherwise?

    sorry if questions seems...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:37 pm

    #1254070

  • RE: Update Error

    Rog Saber (11/22/2010)

    I added indexes to the tables same problem. I don't understand because none of my other tables have PK, just a lot of indexes built from not null...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:34 pm

    #1254068

  • RE: 2 sep. queries are fast except when executed together via UNION ALL

    p1nball (11/22/2010)

    Unfortunately the answer is no to all 3 questions.

    Hrm. Okay, couple of things to try.

    First, set the UnionAll to MAXDOP 1. Get rid of possible parallelism issues,...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:11 pm

    #1254050

  • RE: Update Error

    Rog Saber (11/22/2010)

    I am using MS SQL Server Mgt Studio. I r-click on the table and select Open Table. I have a date field which I try and modify (I...

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

    November 22, 2010 at 2:04 pm

    #1254043

Viewing 15 posts - 4,846 through 4,860 (of 5,678 total)