CROSS APPLY behaves like a LEFT OUTER JOIN, so you will a row for each Client that...

The OLEDB provider has a memory leak, hence the error will occur after repeated executions. See http://kbalertz.com/908915/receive-error-message-Microsoft-Provider-Visual-FoxPro-Server.aspx for the hotfix

Under SQL Server 2005, the query cache is flushed when a database is change to read only, causing a performance problem on the entire instance. You can determine if...

First one needs to get the date only from the datetime column using this method:

1. subtract one-half of a day and subtract 2 milliseconds, which is 43200002 milliseconds.

2. convert to...

For Logins from Windows accounts, no options may be specified, hence the somewhat misleading message. Correct is

CREATE LOGIN [FREEDOM\SqlAgentWorke] from WINDOWS

go

When designing a table is the size of the field relevant to database performance?

Yes but rather than repeat all of the concerns, do a internet search for

"sql server" "data...

As "dbo" is a database user and the owner of a database must be a login, you cannot specify "dbo". I typically use the "sa" login as the owner.

EXEC...

We have a requirement to maintain the state history of an object which tells how much time an object was in a particular state. For every state change, previous state's...

"I am experiencing issues with SQL Server 2005 grabbing hold of random TCP/IP ports and am looking for a way to restrict the ports it can use to a specified...

Please post the SQL Server Agent Logs. The log files are named SQLAGENT.* where an extension of "out" is for the currently running service and previous files have a...

You can use a DNS Alias where you do not need to specify the SQL Server Name, IP or port, here is a list of the steps needed to implement:

Note:...

MS has posted information on Reporting Services and non-Internet Explorer browsers, which indicates that these features are not supported or give inconsistent results in "third party" browsers:

· ...

Please realize that foreign key delete action need to be specified based on the business rules and a global approach of changing all of the actions to "cascade" is not...

Creating a database by restoring from a backup that happens to be for a system database works fine.

Just did this last week for MSDB where some developers deleted some information...

SQL Server 2005 sample databases are available at http://msftdbprodsamples.codeplex.com/releases/view/4004

Be sure to install service pack 2 before installing the sample databases.