Search Results

Urgent: Using decimal type

Thread by: apskallen, Mar 8, 2007, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, I have a problem that gives me quite a headache. I'm writing this code (simplified example): DECLARE @SumDECIMAL SET @Sum = 88.5 SELECT @Sum...

Criteria on INNER JOIN vs. WHERE

Post by: apskallen, Jan 30, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

quote:Originally posted by Roji. P. Thomas With INNER JOINs it doesnt matter. But with outer joins its a different story. I'd recommend putting the...

Criteria on INNER JOIN vs. WHERE

Thread by: apskallen, Jan 30, 2007, 7 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, What is most efficient: SELECT * FROM Company a INNER JOIN Store s ON a.companyID = s.companyID INNER JOIN Department d...

Search in pdf stored i db?

Thread by: apskallen, Sep 11, 2006, 1 replies, in forum: SQL Server 2005 General DBA Questions

Hi,<br />I want to search for a specific word in a number of pdf<img src='/community/emoticons/emotion-7.gif' alt=':s' /> (and .doc<img...

Performance hit using UPDATE CASCADE?

Thread by: apskallen, Aug 23, 2006, 30 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I need to use UPDATE CASCADE on a table. Is this a major performance hit? It will be a quite small database, so I expect it won't. But is there a...

Log in or Sign up

Urgent: Using decimal type

Criteria on INNER JOIN vs. WHERE

Criteria on INNER JOIN vs. WHERE

Search in pdf stored i db?

Performance hit using UPDATE CASCADE?