When I do a searches across all forums, I get this: Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired /forum/search.asp,...
Is there a way to use SQL Server Profiler to show the SQL for prepared statements that are being traced? Essentially there are two things we need...
Why can't the query optimizer figure out that a subquery is a constant value and create a good plan? For example: 1) SELECT * FROM table1 WHERE...
A couple of annoyances with this site: 1. I hadn't logged on for a couple of years, so couldn't remember login info. But your "forgot" password...
We have a set of SQL scripts for setting up tables that are run in a prescribed order using SQL Analyzer. We would like to create a "master" script...
Separate names with a comma.
