SQL Server Performance

'Adhoc' Querries

Discussion in 'Performance Tuning for SQL Server Replication' started by joe_sql, Jun 7, 2006.

  1. joe_sql New Member


    Can someone explane ; what is Adhoc Querries ?

    Thanks and Regards
  2. merrillaldrich New Member

    Adhoc queries are "sent" into the database server as plain text, e.g. "Select column_a, b, c from myTable"

    That distinguishes them from other methods, like Stored Procedures, where the SQL statement(s) are not delivered to the server in that way.
  3. Madhivanan Moderator

    eg OpenRowset. Also do a google search


    Failing to plan is Planning to fail

Share This Page