Viewing 15 posts - 1 through 15 (of 1,131 total)
My understanding of CROSS APPLY is that it should behave like an inner join.
CROSS APPLY behaves like a LEFT OUTER JOIN, so you will a row for each Client that...
December 14, 2011 at 4:15 pm
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
June 4, 2011 at 7:16 am
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...
March 21, 2011 at 8:23 am
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...
January 18, 2011 at 5:54 am
For Logins from Windows accounts, no options may be specified, hence the somewhat misleading message. Correct is
CREATE LOGIN [FREEDOM\SqlAgentWorke] from WINDOWS
December 24, 2010 at 9:40 am
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...
December 10, 2010 at 1:26 pm
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.
December 9, 2010 at 11:46 am
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...
December 4, 2010 at 6:44 am
"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...
December 3, 2010 at 9:55 am
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...
December 3, 2010 at 4:30 am
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:
December 2, 2010 at 6:41 pm
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:
November 29, 2010 at 6:22 am
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...
November 23, 2010 at 8:08 am
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...
November 22, 2010 at 4:17 pm
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.
November 21, 2010 at 3:47 pm