Viewing 15 posts - 4,651 through 4,665 (of 5,843 total)
Sanjays probably has the right solution here, assuming the number of rows matched is (or may be) low. Otherwise, you can force the plan to use a HASH join...
August 4, 2009 at 9:06 am
irobertson (7/30/2009)
Thankfully it's also a one off job, with a fixed data volume. The brief explicitly states "Performance is not an issue".
Until someone decides it isn't fast enough...
July 30, 2009 at 8:03 am
Hey - if it is acceptable for your purposes that is all that truly matters. Well, at least until your data volumes grow a bit! 🙂
July 29, 2009 at 11:03 am
Triangular joins anyone? Search this site for stuff about that.
Have you tried this with 1M or even 100K rows in the table? Just scanned quickly so if I...
July 29, 2009 at 9:44 am
shamassaeedmr (7/28/2009)
First convert the chardate into date format then you can apply all date functions you want.convert(datetime,chrdate,103)
What happens to your query when chrdate isn't actually convertable to a datetime datatype??
July 29, 2009 at 9:43 am
Probably more important than cluster size is sector alignment of the partition itself. Review all the stuff here for details: http://blogs.msdn.com/jimmymay/archive/2008/10/14/disk-partition-alignment-for-sql-server-slide-deck.aspx
July 28, 2009 at 8:30 am
LOTS of other things make MSDB grow, such as backups, restores and job executions. IIRC, isn't msdb set to SIMPLE mode by default during installation?
In any case...
July 23, 2009 at 8:43 am
Just as a follow-up you probably want to check to make sure none of your other databases are set to autoshrink (or autoclose for that matter). 🙂
July 23, 2009 at 8:36 am
Dynamic SQL has EXPLICIT values for stuff in the where clause, and thus the optimizer has the exact information it needs to get accurate statistics and put together the optimum...
July 20, 2009 at 8:33 am
David.Poole (7/16/2009)
You have to remember NOT to synchronise...
July 16, 2009 at 4:40 pm
Grant Fritchey (7/16/2009)
TheSQLGuru (7/16/2009)
July 16, 2009 at 4:37 pm
Grant Fritchey (7/16/2009)
Jeff Moden (7/16/2009)
Think "parameter sniffing" to determine how far you'd carry the approach and when you can least afford for it to occur.
Yes, true. But there's good &...
July 16, 2009 at 12:11 pm
AmolNaik, did you read the thread completely? I think everything you said had already been covered, most of it more than once. 🙂
July 16, 2009 at 12:08 pm
Grant Fritchey (7/16/2009)
TheSQLGuru (7/16/2009)
I think we will have to disagree on this one. I estimate that 90+% of the time a user has a query with a date range...
July 16, 2009 at 9:39 am
JohnG (7/16/2009)
An advantage for using GUIDs in a .Net application is that the value can be generated anywhere...
July 16, 2009 at 9:19 am
Viewing 15 posts - 4,651 through 4,665 (of 5,843 total)