Viewing 15 posts - 1,606 through 1,620 (of 2,894 total)
...
what is the alternative of any of this??
...
Alternative is here: http://www.sqlservercentral.com/articles/Best+Practices/61537/
, but you've been referred to this magic place so many times but failed to follow simple tips...
I have...
May 9, 2012 at 9:52 am
Have you tried http://www.sqlservercentral.com/articles/Best+Practices/61537/?
May 9, 2012 at 9:47 am
ggjjbb1983 (5/9/2012)
I'm aware that using a wildcard on both sides of a search criteria will stop the index being used, because of the first %:
e.g. Select * from person where...
May 9, 2012 at 9:46 am
... complex OLAP is better done in a tool specifically designed to do OLAP such as SSAS...
So far OP failed to present enough details about required output to judge on...
May 9, 2012 at 9:33 am
david.ostrander (5/9/2012)
Thank you both for the replies...And to save on the knuckle beating with a ruler for future post I have reread the best practices on asking questions article.
+100 for...
May 9, 2012 at 8:51 am
Yeah, the thread title "Trigger works for one user but not..." did catch my attention. As I do hate discrimination of any sort... :hehe:
May 9, 2012 at 8:49 am
Sean Lange (5/9/2012)
Phil Parkin (5/9/2012)
Sean Lange (5/8/2012)
With 526 points I would think you would know you should provide a bit more detail than this.--
Looks like 62 points to me...
May 9, 2012 at 8:21 am
Is there a way to produce an output with profitable products per week, year etc in one query?
There is a way!
But, how exactly do you want results to look like?...
May 9, 2012 at 8:19 am
...
When the FedEx software inserts data into the ITEMSENT table, the trigger is, in fact, being ran but the data is not getting updated in the CONTACT2 table as stated...
May 9, 2012 at 3:17 am
...
But the DBA refuses to do the changes, as long there is no really need for it...
He follows "If it ain't broke, don't fix it" paradigm.
So, do break something...
May 9, 2012 at 3:00 am
ColdCoffee (5/8/2012)
Eugene Elutin (5/8/2012)
1. If you group by LastYearQtyActualContainers and ForecastQtyContainers, you cannot SUMLastYearQtyActualContainers - ForecastQtyContainers
One small correction here Eugene, you can SUM the columns used in GROUP BY,...
May 9, 2012 at 2:56 am
...not because of all of the usual gump that people spout about not using triggers (they are the devil along with cursors and function
...
I'm an atheist. Are you afraid...
May 8, 2012 at 10:44 am
You can set your FT index population to CHANGE_TRACKING AUTO.
It will make FT index to be updated after data is modified, not immediately, but quite close to it.
May 8, 2012 at 9:56 am
... Surely it doesnt update the catalog every time a query it?
I cannot understand what are you up to exactly, but:
No, the FT catalog is not updated every time you...
May 8, 2012 at 9:51 am
Viewing 15 posts - 1,606 through 1,620 (of 2,894 total)