Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 5,685 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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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,...

    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...

    November 22, 2010 at 2:04 pm

    #1254043

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