Viewing 15 posts - 1 through 15 (of 94 total)
May 17, 2012 at 8:11 am
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...
April 27, 2012 at 7:28 am
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...
August 26, 2011 at 8:45 am
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...
July 6, 2011 at 7:47 am
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....
October 29, 2010 at 8:58 am
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...
October 21, 2010 at 7:56 am
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) 4 4 0 NULL NULL 4 NULL 90000 NULL NULL NULL 88.34656 NULL NULL UPDATE 0 NULL
July 14, 2010 at 8:22 am
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...
Anye Mercy (7/13/2010)
July 14, 2010 at 7:37 am
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...
July 13, 2010 at 5:08 pm
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...
July 13, 2010 at 4:07 pm
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...
June 18, 2010 at 12:45 pm
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...
June 15, 2010 at 8:07 am
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...
June 15, 2010 at 6:57 am
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...
June 3, 2010 at 9:42 pm