Viewing 15 posts - 33,016 through 33,030 (of 59,102 total)
Pagan DBA (8/2/2011)
The idea behind the question was to get some insight into...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 11:10 pm
Thinky Night (8/1/2011)
My query is like:
alter view dbo.Query_Test(col1,col2,col3) WITH SCHEMABINDING
select a.col1,b.col2,c.col3
from table1 a
inner join table1...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 8:01 am
There's actually a serious improvement that can be made to the code which will guarantee that if something goes wrong, an error will be generated. If you can wait,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 7:59 am
srinath.vanama (8/1/2011)
am facing a performance problem in one server like there are so many blockings are occured on the server which becomes SQL server is using more CPU memory...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 7:37 am
Ninja's_RGR'us (8/2/2011)
I always wait 24H before actually posting anything in case this is an exam or cert or late homework.
I was hoping for an...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 7:13 am
Same message, talktosivas... lots of people want and need help and lots of good people on the forums want to test their answer against some data before posting their coded...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 7:05 am
johnsonchase7 (8/1/2011)
CREATE TABLE #TEMP
(ID INT, VALUE INT)
INSERT INTO #TEMP
select 0, 21 union all
select 1, 98...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 6:58 am
Ninja's_RGR'us (8/2/2011)
Ignoring the <uselessly> complexe query by peso... so what did you come up with?
Ummm... did you miss it, Remi?
I tried the following but the group by makes it...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 6:49 am
Leo.Miller (8/1/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 6:34 am
Leo.Miller (8/1/2011)
Since an iTVF is typically only called once it would be much like Vijay's original solution with the case statement, it would just be moved to the iTVF.
Hmmm......
--Jeff Moden
Change is inevitable... Change for the better is not.
August 2, 2011 at 6:31 am
As a side bar, I think it's really cool that you have 2K8. I also think it's really cool that you've learned to use the "new" Insert/Values. But,...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2011 at 7:48 pm
Pagan DBA (8/1/2011)
-- Which is FASTER?
Do what any of us would do... TEST IT and see! 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2011 at 7:40 pm
Heh... Joe who? 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2011 at 7:37 pm
Leo.Miller (8/1/2011)
In line functions aren't actually compliled into the code, they are still external functions that need to be called.
I agree that's true about Scalar and mTVF's (multi-line Table Valued...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2011 at 6:56 pm
If you really want help, post the data in a readily consumable format. See the first link in my signature line below for how to do that correctly.
As a...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 1, 2011 at 6:52 pm
Viewing 15 posts - 33,016 through 33,030 (of 59,102 total)