Viewing 15 posts - 721 through 735 (of 1,825 total)
If readability / re usability and maintainability are issues then I would be looking at using Inline table valued functions.
July 9, 2010 at 6:39 am
There will be no performance impact.
With both SQLServer will evaluate the 'best' query plan at execution time.
For this purpose CTE's are Views and vice-versa.
July 8, 2010 at 7:28 am
GilaMonster (7/8/2010)
Not as useful as it could be, because it's missing two columns used in the where clause and because of the 'catch-all' type query.
That is *NOT* to say that...
July 8, 2010 at 5:37 am
GilaMonster (7/8/2010)
Not as useful as it could be, because it's missing two columns used in the where clause and because of the 'catch-all' type query
That is *NOT* to say that...
July 8, 2010 at 5:36 am
Please see this article
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
Additionally , i wouldnt use Table variable here , i would be using temp tables.
Also i suspect that with smarter SQL you should be able to remove...
July 8, 2010 at 4:50 am
Please see this article
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 8, 2010 at 2:42 am
IMO , poor performance is generally the cause of poor TSQL and poor design.
Please post DDL , queries and Execution Plans
July 8, 2010 at 2:37 am
Hi ,
Can you expand on what your problem is ? Is it inserting when it shouldn't ? or updating when it shouldn't ?
There doesent seem to be anything related to...
July 6, 2010 at 2:28 am
Cross server queries can be troublesome , in you view on DB-Srv2 are you joining to any other tables ?
Please post DDL, and execution plans as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 5, 2010 at 4:12 am
And Another, all aggregate function support the OVER clause.
with cte
as
(
select state,
Per,
SUM(amt) over(partition by state) as...
July 5, 2010 at 2:39 am
SqlBits is also doing a precon this time around, feel free to submit 🙂
July 3, 2010 at 4:11 am
Jeff Moden (7/2/2010)
Here's a real life example of what I'm talking about. I gave a 2 hour session at my local Pass chapter. The first hour was ....
Agreed...
July 2, 2010 at 4:10 pm
It much worse than the function call being non-deterministic, now blogged ...
July 2, 2010 at 9:23 am
Paul White NZ (7/2/2010)
Reported as spam - assuming no-one here is in the market for kitchen cabinets?
Thought about it but gave the benefit of the doubt.
July 2, 2010 at 7:10 am
Viewing 15 posts - 721 through 735 (of 1,825 total)