Thanks man!
Ok, i found a solution so never mind unless you think my way is a slow or bad way. I had to use a subquery for one count, but i guess there is now...
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...
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...
Ok, I will try to rewrite the statement. However, can someone please tell me wheter or not there is a max-row-size for a resultset?
Ok, the select will follow. But a simple question. Is there a maximum row-size for a returned resultset? code: SELECT TABLE_B.RECRUITMENT_ID,...
Hi,<br /><br />What exactly is the deal with row sizes?<br /><br />I have table A with:<br />column A int(4),<br />column B tinyint(1),<br />column C...
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...
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...
Hi, I've been given the assignment of tuning and optimizing our companies database. The database has been created by someone who obviously loves...
Oh, if this is of any importance to my question, the query should return about 90-110 rows each time. Anyway, its not a problem procedure, i'm just...
Thanks for the advice. PFK means its the primary key and also a foreign key. Mp_user_sid comes first in the definition, then the fasett_sid. "If...
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...
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...
Yes, that is not a bad idea. smalldatetime is acceptable for my needs. (at least until the Y2079 bug <img src='/community/emoticons/emotion-1.gif'...
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...
Yes, the item_response table has index with session_sid, item_sid, responsevalue. Since i've now included the item table as a part of the procedure...
Yeah i guess thats it. same on fasett/faktor when inserting in tscores_faktor, tscores_fasett.
With reversed index on lookup(language_sid, fasett_sid) clustered, it effectivly decreased the reads in the lookuptable from 1000 to 170. Twan: The...
Yes, clustered index on lookup table.
Separate names with a comma.
