Viewing 15 posts - 61 through 75 (of 1,131 total)
This error can occur when the file is open (in Excel).
SQL = Scarcely Qualifies as a Language
May 29, 2010 at 9:21 am
For error 18456, the value of "State" describes the reasons why the login failed. A state of 16 indicates that the default database for the login is not available.
SQL = Scarcely Qualifies as a Language
May 12, 2010 at 6:40 am
Paul Berzukov posted
totally agree with Don Peterson's position on the matter but please note neither original poster nor anybody else in this thread is suggesting the creation of a...
SQL = Scarcely Qualifies as a Language
May 8, 2010 at 9:45 am
There is no deadlock wait period, which is why you cannot find any information. When a deadlock is detected, the transaction that needs the least amount of resources to...
SQL = Scarcely Qualifies as a Language
May 7, 2010 at 3:49 pm
Don Peterson has written an article on why you should not use the type of design that you are proposing: "Lookup Table Madness" at http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/
SQL = Scarcely Qualifies as a Language
May 7, 2010 at 3:42 pm
If these servers are dedicate to running SQL Server, you should be seeing very little paging.
A few questions:
Have the SQL Server service accounts been granted the "lock pages in memory"...
SQL = Scarcely Qualifies as a Language
May 7, 2010 at 3:38 pm
Does the errorlog file have a large number of messages for backup operations ? These messages can be suppressed with trace flag 3226 See http://msdn.microsoft.com/en-us/library/ms188396.aspx
SQL = Scarcely Qualifies as a Language
May 6, 2010 at 6:27 pm
The log files growth is the same as when it is in full mode
Do you mean the size of the database log file ( ldf extention) or the size of...
SQL = Scarcely Qualifies as a Language
April 22, 2010 at 6:30 am
With the SQL Server Configuration Manager open, expand "SQL Native Client Configuration", right click the 'Aliases' in the tree, and choose 'New Alias'. There are 4 items...
SQL = Scarcely Qualifies as a Language
April 12, 2010 at 3:19 pm
There are multiple parts to the solution:
1. for each columns, convert numeric values to a numeric data type and non-numerics to null
2. sum the three columns after...
SQL = Scarcely Qualifies as a Language
April 11, 2010 at 9:25 am
how do I link the DNS to the SQL alias (SQLAlias2005)?
You do not resolve the SQL Server instance name with DNS but instead use the SQL Server utilities...
SQL = Scarcely Qualifies as a Language
April 9, 2010 at 2:52 pm
There is a very long set of posts titled "Just the date, please"
http://www.sqlservercentral.com/Forums/Topic379596-8-2.aspx
The below method is 10 times faster than converting to character and then truncating the time portion:
CAST(convert(int,...
SQL = Scarcely Qualifies as a Language
April 3, 2010 at 12:06 pm
Not using SQL directly:
The WMI ODBC Adapter is not available in Windows Server 2003. When you upgrade to Windows Server 2003 from Windows 2000 Server, the WMI ODBC Adapter is...
SQL = Scarcely Qualifies as a Language
March 29, 2010 at 5:39 am
Linchi Shea has a six part blog titled "Performance Impact: file fragmentation and SAN" that will cover may of your questions at http://sqlblog.com/blogs/linchi_shea/archive/2008/12/07/performance-impact-file-fragmentation-and-san.aspx
Database files will fragment whenever the file automatically...
SQL = Scarcely Qualifies as a Language
March 25, 2010 at 4:05 pm
A Clarification regarding the master database; although the recovery mode can be set to FULL, transaction log backups cannot be performed and transaction log restores cannot be performed.
Here is the...
SQL = Scarcely Qualifies as a Language
March 25, 2010 at 1:14 am
Viewing 15 posts - 61 through 75 (of 1,131 total)