SQL Server Performance

Search Results

Search Again
  1. adnan8t2

    What are the best practices when creating a new database on SQL Server?

    Thread by: adnan8t2, Jun 20, 2010, 4 replies, in forum: General Developer Questions
    Dear Readers,According to your experience what we should set the size of following fields while creating a new database.MDF Initial Size = ?LDF...
  2. adnan8t2

    Query about current stock in one store but not another

    Post by: adnan8t2, Jun 3, 2010 in forum: SQL Server 2008 General Developer Questions
    As I understand, it would beSelect S1.StoreCode, S1.SKU, S1.Stock From CurrentStock S1 Where (S1.Stock >= 5 AND S1.StoreCode = '1')AND S1.SKU IN...
  3. adnan8t2

    Triggers Inserts

    Post by: adnan8t2, May 23, 2010 in forum: SQL Server 2008 General Developer Questions
    /* 01 - Creating tables Employee, HR, Payroll 02 - Making trigger on Employee table for Insertion 03 - Inserting row in Employee table 04 - Testing,...
Showing results 1 to 3 of 3
Search Again