Viewing 15 posts - 42,421 through 42,435 (of 59,067 total)
Divide'n'Conquer... it seems like you're trying to do everything in a single query and that can really make a mess of things. Write a proc that will get the...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2009 at 2:54 pm
Ummmm... be careful... aggregated views (views with things like SUM) in them, aren't necessarily going to be faster if you use a criteria against their result set. For example,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2009 at 1:51 pm
Ok... just to set your mind at ease, here's what I see 1 year's worth of storage taking for the data as a worst case rough ESTIMATE...
SchemeCode ...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2009 at 1:38 pm
Heh... I really do have to install the DevEd of 2k8. Thanks for the reminder.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2009 at 1:08 pm
saivko (8/8/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2009 at 1:03 pm
smknox (8/7/2009)
thanks so much. This works.Sam
You bet and my pleasure. I am confused a bit, though... why do you need to do this? It's not often I see...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 8:51 pm
ta.bu.shi.da.yu (8/7/2009)
Hey Jeff... I don't suppose you know how to wrap a CTE in a view? 🙂
Sure... it's easy... you've just gotta follow one of the main rules. Every...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 8:28 pm
The following formula will do it... convert to handle columns from a table instead of variables for a set based solution... this is just for demo...
--I would like to add...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 8:16 pm
Mad-Dog (8/6/2009)
my goal here is to capture all the queries that run now that cause the CPU to become over 90%.
my CPU get to 90-100 a lot of time.
so i...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 8:05 pm
ps (8/6/2009)
I've always been confused abt this part of the overall equation. How exactly adding 2 to the number of rows helps in finding...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 7:59 pm
satishbhargav4u (8/7/2009)
What format is it in:-this is in text format
What do you want to do with this data once you have it:- some analysis...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 7:45 pm
John Paul (8/7/2009)
As per the article ,
UDF as Computed Column
By Dinesh Priyankara,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 7:00 pm
Bob Hovious (8/7/2009)
(Walks in and hoses Jeff down with high pressure ice water hose, just prior to meltdown.)😉
BWAA-HAA!!! Man, I probably shouldn't be posting... let's see... I'm trying to...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 6:52 pm
What are the datatypes for the columns involved and would you post some sample data, please? There's no way to help on this one without that information.
For future posts,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 6:46 pm
thummalalavanya (8/7/2009)
I want to use Cte in my sql server 2005.What is Cte .why...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 7, 2009 at 6:42 pm
Viewing 15 posts - 42,421 through 42,435 (of 59,067 total)