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
go
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.
EXEC...
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:
Note:...
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
Viewing 15 posts - 1 through 15 (of 1,131 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy