SQL Server Performance

Search Results

Search Again
  1. JKAU

    Assign a single column query value to SSIS variable

    Thread by: JKAU, Dec 6, 2008, 1 replies, in forum: SQL Server 2005 Integration Services
    Hi I have created the following; OLEDB Connection to the database variable --> user::GetName (string type) Exec SQL Task --> Select Top 1...
  2. JKAU

    Executing DTS through SQL server 2005 Job Agent

    Thread by: JKAU, Nov 16, 2008, 1 replies, in forum: SQL Server 2005 General DBA Questions
    Hi I am trying to execute DTS through SQL Server 2005 Job which fails. The following is the error: Step Error Source: Microsoft Data...
  3. JKAU

    HOW TO CHECK SQL Server Performance Tuning for Stored Procedures

    Post by: JKAU, Jul 3, 2008 in forum: Getting Started
    You can profile it to see duration, Reads, writes and CPU. Also when you run query plans, check each components rowcounts and cost. You can decide...
Showing results 1 to 3 of 3
Search Again