Viewing 15 posts - 40,936 through 40,950 (of 59,069 total)
Unfortunately, that's not been my particular experience. I usually experience the ol' "too many cooks spoil the broth" syndrome.
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:51 pm
I never use percentage for many of the reasons stated.
I also never leave the defaults. It's takes and makes 73 disk fragments to grow a database from 1MB to...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:48 pm
Steve Jones - Editor (11/25/2009)
Apparently not doing much networking with this one.
About the only social networking I do is on LinkedIn and then only when required. I use it...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:42 pm
Yes... write an exclusive self join or a union between two queries on the same table using EXCEPT.
Since you're new to the forum, take a look at the article in...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:33 pm
shanghaigirl-1125377 (11/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:28 pm
Mostly, conditioning for me. It just takes time to learn to ignore and be as one with the computer. It's a real PITA that's not easily overcome...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:24 pm
Even the best written triggers can cause an application to crash because of just one thing... the returned rows counts generated in the triggers are interpreted as "error messages". ...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:21 pm
I'm not sure if my luck will run out or not but, so far, every time I've rewritten a DTS package to be done all in T-SQL, I've beaten the...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:19 pm
stewsterl (11/25/2009)
Jan Feb Mar April May Jun JUL YEAR$23,000 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $2,008.00 2008
$23,000 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $36,236.00 $2,008.00 2009
Great post and thanks for all the data...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 10:12 pm
Sergiy (11/25/2009)
Jeff, a small correction.It should be:
...
join sysdba.history h on h.accountid = maxdate.accountid AND h.startdate = maxdate.MaxStartDate
...
🙂
Heh... now you know why I like to test my stuff......
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:54 pm
Jack Corbett (11/25/2009)
Jeff Moden (11/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:47 pm
Agreed.... if everything were absolutely perfect. The problem is that clustered indexes can do page splits and non-clustered indexes do "extent splits". Guess what happens when you do...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:33 pm
They finally have the code windows so close to being right that I don't want them to touch them for fear of them mucking them up like they have in...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:29 pm
Steve Jones - Editor (11/25/2009)
You can't force people to read or pay attention.
Heh... you can if there're some tight ropes and high velocity pork involved. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:26 pm
Irish Flyer (11/25/2009)
I have never seen any tempdb growth that could be called abnormal, it just is what it is
Heh... man, I have. Developer ran some code that had...
--Jeff Moden
Change is inevitable... Change for the better is not.
November 25, 2009 at 9:20 pm
Viewing 15 posts - 40,936 through 40,950 (of 59,069 total)