SQL Server Performance

Search Results

Search Again
  1. sgovoni

    DBCC INPUTBUFFER

    Thread by: sgovoni, Jul 1, 2008, 9 replies, in forum: General DBA Questions
    Hi, within a trigger I use the command "DBCC INPUTBUFFER (@@SPID) WITH NO_INFOMSGS" to capture the statement that the client has sent to the server....
  2. sgovoni

    ANSI_NULLS and Performance

    Thread by: sgovoni, Jun 10, 2008, 7 replies, in forum: T-SQL Performance Tuning for Developers
    Hi, I am developing an application that uses OLE DB to connect to SQL Server 2000; originally the application was using DB-Library to connect to SQL...
  3. sgovoni

    Fully qualified filtering

    Thread by: sgovoni, Jun 10, 2008, 1 replies, in forum: SQL Server 2005 T-SQL Performance Tuning
    Hi, I read that writing query with filtering criteria fully qualified greatly reduces the I/O operation. So I'm changing the WHERE clause which are...
Showing results 1 to 3 of 3
Search Again