Fun Monsters and Mayhem Sci Fi TV show set in modern day.

In other news relating to my bitching around project management yesterday ... Spent 4 days doing crit...

New season of Sanctuary looks good...

This is not the...

The <> here is probably blowing up an index seek. Need...

GilaMonster (9/30/2010)

---

Craig Farrell (9/30/2010)

---

I wonder if this is the trigger I noticed this morning. He's usually tactless, but this morning it's like he's trying to be mean, instead of...

GilaMonster (9/30/2010)

---

Interestingly enough, over at SQLTeam Joe replied to someone's post with a request for DDL. No insults, no arrogance, just a standard request for table definitions, etc and the...

Nope. I do think you've managed to make sure he won't buy your...

I'd disagree. He's usually got the tact of a steamroller but that was obnoxious, even for him.

CELKO (9/30/2010)

---

Have you even thought about using a relational design instead mimicking a deck of punch cards? Do you know about UPC and industry standards? Do you know why IDENTITY...

*blink*blink*... Wow. Makes me never want to buy one of those books of his.

http://www.sqlservercentral.com/Forums/Topic994925-392-1.aspx

Expand this code to each field. You're running subqueries for each line, that's going to hurt.

UPDATE tt

SETclm_loc_city = lt.loc_city,

clm_loc_state = lt.loc_state

-- ... keep going on

FROM

#temp_table AS tt

JOIN

LOCATION_TABLE as...

jackimo (9/30/2010)

---

Thanks Grant,

I do understand that and the fact is in some cases we'll have to do a full scan. Do you think that storing the message in a...

SwayneBell (9/30/2010)

---

Update:

I'm told that what's happening here is that we do full backups each night. The following morning, the log files are 'deleted' and allowed to fill through the day...

Create a copy of the procedure and do timestamp wrappers around each of the updates. Find out where the pain in time is. Then start pulling out execution...

Jeff Moden (9/29/2010)

---

Chris Morris-439714 (9/29/2010)

---

Jack Corbett (9/29/2010)

---

So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who...