Search Results | SQL Server Performance Forums

Speed of If Else

Post by: matt3.5, Oct 22, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

I have found another way to solve my problem using a Case When statement - I found out that SQL Server is unlikely to cache query plans for sprocs...

Speed of If Else

Thread by: matt3.5, Oct 21, 2008, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi folks, I have a procedure for custom/sorting paging a datagrid on a web page. It uses a sortparameter which (unfortunately) I have to pass in to...

Is this a sql injection risk?

Thread by: matt3.5, Sep 29, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

I have a full text search sproc which accepts a string as a parameter i.e. @term nvarchar(120) I then have to do this within the sproc: declare...

Index performance question

Post by: matt3.5, Sep 23, 2008 in forum: SQL Server 2005 General Developer Questions

Hello. Are you using asp.net membership by any chance? Anyway, it is possible to have a guid as a primary key but this is not recommended due to the...

Raid and disk configuration - New Dell PowerEdge 2950 Server

Post by: matt3.5, Sep 23, 2008 in forum: SQL Server 2005 Performance Tuning for Hardware

With a db that big you should consider scrapping sata hd's and going with 15,000rpm scsi drives. You will find that you get to a point where CPU and...

Convert uk date format to iso standard?

Thread by: matt3.5, Sep 12, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hi, how can I convert one date format to another? I have a procedure (below) where 2 dates are passed in (in UK format). Ideally I would like to...

When does a table become "big"?

Post by: matt3.5, Sep 11, 2008 in forum: SQL Server 2005 General Developer Questions

Thanks Martins, that's interesting. You see a database I am working on at the moment has a table that is only ever going to have 2-300 rows x 18...

When does a table become "big"?

Thread by: matt3.5, Sep 10, 2008, 3 replies, in forum: SQL Server 2005 General Developer Questions

Hi, I have been reading some articles on the site about index selection etc and keep reading the phrase "an index scan may be better if many rows are...

Query lots of date columns per record, a better way?

Post by: matt3.5, Sep 9, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

I don't think I can normalize any further really, the table I am querying consists of a ProductId column, then the date columns. I like the idea of...

Query lots of date columns per record, a better way?

Thread by: matt3.5, Sep 9, 2008, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello, I'm querying a table where a lot of dates are stored per row. Each record can have up to 15 nullable dates i.e. productid, dateA, dateB,...

Replacing sub query with inner join?

Post by: matt3.5, Sep 3, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Frank, YOU ARE THE MAN!

Replacing sub query with inner join?

Thread by: matt3.5, Sep 3, 2008, 3 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hi, how can I get another inner join in here to improve the performance of this query? I'm querying a training courses database. The query below...

When is the full-text search really really needed?

Post by: matt3.5, Aug 15, 2008 in forum: SQL Server 2005 T-SQL Performance Tuning

Thank you for your reply. After more research though I have decided to still go with the full-text catalog - mainly to avoid table scan and also...

When is the full-text search really really needed?

Thread by: matt3.5, Aug 15, 2008, 2 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hey, In a database I am designing for a website, one of the main tables is a products table. Users will need to be able to search using a search box...

Arguing against LINQ 2 SQL

Post by: matt3.5, Aug 12, 2008 in forum: SQL Server 2005 General DBA Questions

Hey, I haven't had time to get into LINQ to SQL yet, but there is a lot of info about it over at Scott Gu's blog (Microsoft leader for ASP.NET). The...

A lot of bit columns in a where, a bad thing for performance?

Thread by: matt3.5, Aug 12, 2008, 3 replies, in forum: SQL Server 2005 General DBA Questions

Hello, I have a design issue with a table. To cut a long story short, users of a site need to be able to store their preferences in a table. Part of...