SQL Server Performance

Search Results

Search Again
  1. mkal

    New index

    Thread by: mkal, Oct 28, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    I've been looking at the following query: SELECT CONVERT (varchar, @runtime, 126) AS Runtime , CONVERT (decimal (28,1),...
  2. mkal

    Max degree of parallelism question

    Thread by: mkal, Sep 21, 2009, 9 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Config info: 4CPU (quad core) SQL 2005 SP3 32GB RAM Max Degree of Parallelism set to 8 OS Windows 2003 sp2 on a RAID 1, RAID 10 log files, DAS unit...
  3. mkal

    Drive Configuration for Dell R905

    Thread by: mkal, Aug 14, 2009, 5 replies, in forum: SQL Server 2005 Performance Tuning for Hardware
    I have a DELL R905 w/2-quad core cpu's, 32GB RAM, Windows 2003 x64, SQL 2005 x64 and would like to know about the drive configuration. Right now I...
  4. mkal

    Memory issue (Erratic PageLife Expectancy)

    Thread by: mkal, Nov 13, 2008, 2 replies, in forum: Performance Tuning for DBAs
    I have been battling what I believe is a memory issue and I have been trying to figure out why the page life expectancy on this server is all over...
  5. mkal

    Param passed to Stored Proc is failing

    Thread by: mkal, Aug 22, 2003, 8 replies, in forum: General Developer Questions
    I'm trying to create a proc (SQL 2000) that takes a single input paramter from a front Cold Fusion app. The parameter should hold a comma delimited...
Showing results 1 to 5 of 5
Search Again