Viewing 15 posts - 41,746 through 41,760 (of 59,067 total)
SQL Noob (9/28/2009)
and PrepLogic is having a sale. $10 for the 70-432 pdf download with 150 questions
Hmmm... I suppose it comes with the answers to those 150 questions,...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 7:35 pm
Bob Hovious 24601 (9/28/2009)
But I thought the frozen ones hurt more, Jeff. 😛
I used to think that but I did an experiment and found that if you cook...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 7:26 pm
Bob Hovious 24601 (9/28/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 11:21 am
Dave Ballantyne (9/28/2009)
Jeff Moden (9/28/2009)
Heh... what ordering issues?
Well , just that on your base table , you dont ( disclaimer More testing needed) need a clustered index in the...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 9:31 am
Dave Ballantyne (9/28/2009)
this goes some way to resolving quirky update ordering issues.
Heh... what ordering issues?
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 8:30 am
Thanks Greg.
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 8:25 am
brett.davis1 (9/28/2009)
Jeff,I'm not certain that we will have the kinds of problems you are refering to - but correct me if I'm wrong.
Now that I know what the table is...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 28, 2009 at 4:44 am
winterminute (9/27/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 9:28 pm
I've run into this problem many times especially when the view calls other views and aggregations are involved. Every system has a "tipping point" very much like the proverbial...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 9:25 pm
For better answers quicker, I recommend the following article...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 9:08 pm
roy.neelanjana (9/27/2009)
I have a requirement in sql server 2005 reporting services where I need multiple selection. But my database is in Sqlserver 2000.
If the input is as follows:
declare...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 9:05 pm
Grant Fritchey (9/25/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 8:07 pm
I've got to ask... what do you do next week since this original table posted gives no clue as to date? I don't know if you can change from...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 8:04 pm
I agree with you, but you didn't tell them how to export to a CSV. Keep in mind that T-SQL is part of the stack and the user doesn't...
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 7:48 pm
jwhisman (9/27/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
September 27, 2009 at 7:40 pm
Viewing 15 posts - 41,746 through 41,760 (of 59,067 total)