Search Results | SQL Server Performance Forums

Thread by: erkdahl, Apr 12, 2007, 3 replies, in forum: General Developer Questions

Hi guys! Lets say you have three tables. CUSTOMER(CUST_ID (PK), NAME) ORDER(CUST_ID (PKFK), SEQ_NR (PK), DATE) ORDERLINE(CUST_ID(PKFK), SEQ_NR...

Thread by: erkdahl, Mar 13, 2007, 1 replies, in forum: General Developer Questions

Hello friends, I've recently been assigned in a project developing a web application. My role is to develop the database. The system has a highly...

Thread by: erkdahl, Feb 5, 2007, 5 replies, in forum: General Developer Questions

Hi, What exactly is the deal with row sizes? I have table A with: column A int(4), column B tinyint(1), column C...

Thread by: erkdahl, Oct 31, 2006, 5 replies, in forum: T-SQL Performance Tuning for Developers

I know this is may not fall under the category of T-SQL tuning, but I can not find a better place for sql-server knowlegde. Ok, basicly there is...

Thread by: erkdahl, Aug 31, 2006, 0 replies, in forum: T-SQL Performance Tuning for Developers

Ok guys. This subject drives me crazy. All feedback is greatly appriciated. Lets say you have to store emails in a table. (sent / unsent /drafts...

Thread by: erkdahl, Aug 31, 2006, 2 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I've been given the assignment of tuning and optimizing our companies database. The database has been created by someone who obviously loves...

Thread by: erkdahl, May 26, 2006, 8 replies, in forum: T-SQL Performance Tuning for Developers

Hi again, I'm still learning how to properly optimize my code and I want to get your opinions on one simple bit of code. There is two tables...

Thread by: erkdahl, May 22, 2006, 1 replies, in forum: SQL Server-Related Job Postings

Our company is currently looking for developers with a good skills in SQL/Java. To qualify for the job you have to live in Oslo - Norway or be...

Thread by: erkdahl, May 18, 2006, 9 replies, in forum: T-SQL Performance Tuning for Developers

Hi again! I'm back with a question we are discussing at my office. Lets say you have a large table (100.000 ++) with user information, one of the...

Thread by: erkdahl, May 11, 2006, 51 replies, in forum: T-SQL Performance Tuning for Developers

Hi, I'm quite new to optimizing Stored procedures, I'm currently developing a application who will be added to a website which have 6000+ daily...