SQL Server Performance

Search Results

Search Again
  1. Hmnt

    Consolidated: SQL 2005+ Dynamic Pagination using SET ROWCOUNT or RowNumber() ?

    Thread by: Hmnt, Nov 3, 2009, 1 replies, in forum: General DBA Questions
    I've a complex SP which applies multiple JOINs and lookup and come complex filters like comma-separated values, etc... On top of it, I've to deploy...
  2. Hmnt

    Deploy view or use function for lookup

    Thread by: Hmnt, Oct 31, 2009, 1 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    I've two master tables **Org** & **Item** and then there's an **OrgItem** table.I have to fetch *ItemCodes* for a particular Org. TABLE STRUCTURE: -...
  3. Hmnt

    SQL Server Foreign Key constraint benefits

    Thread by: Hmnt, Oct 27, 2009, 10 replies, in forum: Performance-Related Article Discussions
    We're designing a database in which I need to consider some FK(foreign key) constraints. But it is not limited to formal structuring and...
  4. Hmnt

    SQL-Server DB design time scenario (distributed or centralized)

    Thread by: Hmnt, Oct 27, 2009, 4 replies, in forum: General DBA Questions
    We've an SQL-Server DB design time scenario .. we've to store data about diff Organizations in our database (i.e. like Customer, Vendor, Distributor,...
Showing results 1 to 4 of 4
Search Again