Ian Boyd
  • Member for 10 years, 5 months
  • Last seen more than a week ago
  • Windsor, Canada
SQL Server, Allow remote connections to this server option. What does this do?
Accepted answer
6 votes

This checkbox is the GUI way of setting the remote access configuration option, EXEC sp_configure 'remote access', 0; -- UI checkbox unchecked EXEC sp_configure 'remote access', 1; -- UI checkbox ...

View answer
Hovering over an Operator in Execution Plans: How to make the tooltip not disappear when moving the mouse
3 votes

The time that a hint window is shown (it's TTDT_AUTOPOP time), is based on your double-click time. The default delay times are based on the double-click time. For the default double-click time of 500 ...

View answer
SQL Relationship between Subtree Cost and Performance Time
3 votes

SQL Server I/O and CPU Cost is an estimate of seconds from the year 2000. SQL Server estimates that each I/O will take 3.125 ms (i.e. 1⁄320 s, because of the assumption that the disk can perform 320 I/...

View answer
SQL Server Estimated I/O Cost in real units
3 votes

SQL Server I/O and CPU Cost is an estimate in seconds from the year 2000. SQL Server estimates that each I/O will take 3.125 ms (i.e. 1/320 s, because of the assumption that the disk can perform 320 ...

View answer
Why does a query run slower in a Stored Procedure than in the Query window?
0 votes

From a similar question on Stackoverflow (with more answers), check your stored procedure. BAD: SET ANSI_NULLS OFF (5 minutes, 6M eager spool) GOOD: SET ANSI_NULLS ON (0.5 seconds)

View answer