jfogel (5/17/2012)

---

"It depends on some good senior people in your own organization, and their willingness to assess the candidates without involving themselves in a competition of sorts with the interviewee"

Never...

I wouldn't use this for a backup specifically however it will be very useful in updating the hundreds to thousands of databases in our multitenant environment with the latest dacpac...

I find it less important whether the manager 'gets the concepts' than whether she recognizes that she doesn't get them. I have had good managers who had no concept...

1) No military boot camp for me, but my summer field geology course was a mini-geology boot camp. Just more fun and with better food.

2) I think...

There weren't a whole lot of options for women back then - teacher, nanny, scullery maid, wife/mother.

I think it would have depended on whether my family was rich or poor....

Last year my honey bought me a Kindle with his holiday bonus from work. (This wasn't the cheap part.)

Since then I've spent countless hours reading the books available for...

Here's the showplan (sorry for the crappy formatting:

update top(100000) MainTable set IntFK7=@tagid, ChangedBy=@userid, ChangedDate=@date from MainTable M inner join TempTableeead95e8x75a5x4f42xb639xbe56e74bd752 T on M.Pkey=T.Pkey where M.IntFK7 <> @tagid option(recompile)440NULLNULL4NULL90000NULLNULLNULL88.34656NULLNULLUPDATE0NULL

...

doobya (7/13/2010)

---

use tablockx

create index on temp table

update statistics before update

check index condition before and after update

adjust fillfactor, padindex accordingly

ensure logs are on separate drives to data

ensure data and log files...

lloyd-236007 (7/14/2010)

---

Anye Mercy (7/13/2010)

---

Each job has its own database. The schema of an individual job database is about 98% the same between jobs, with a couple of tables that...

Good catch - I do actually have option(recompile) at the end of the query, but forgot to type it in the window here. I don't think I ever ran...

Hm.. I don't know if that would be a good fit here. The update is performed based on something the user is doing in the application - and it...

I think you are right on both counts - at first glance it appeared that the contents of the Query fields in database B were about the same size but...

Ok, I dug it up (or dug up something else that was related) and I apparently misread it -- the article I read says that the CTE is executed the...

Hi Lawrence, I have spent quite a bit of time recently using Row_Number() with CTEs for paging purposes and have tried to gauge how to get the best performance possible...

When I am evaluating software for work, I absolutely want full-featured, for a limited time. Usually vendors are willing to give you extra time if you need it, especially...