Discussion in 'Performance Tuning for SQL Server Replication' started by joe_sql, Jun 7, 2006.
Can someone explane ; what is Adhoc Querries ?
Thanks and Regards
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.
eg OpenRowset. Also do a google search
Failing to plan is Planning to fail
Separate names with a comma.