Viewing 15 posts - 256 through 270 (of 1,131 total)
For non-production environments, below are the SQL statements that I versus SQL Server 2000 where some minor modifactions to run under 2005 are needed (change the names of the 2000...
SQL = Scarcely Qualifies as a Language
April 24, 2009 at 7:44 am
Regarding antivirus, there are a lot of files and directories that needed to be excluded when running a cluster.
http://support.microsoft.com/kb/822158 and http://support.microsoft.com/kb/250355
Antivirus software that is not cluster-aware may cause unexpected problems...
SQL = Scarcely Qualifies as a Language
April 22, 2009 at 8:40 pm
Welcome to three value logic, which applies when a column may be null.
Under two value logic, the expression if ( a = b or a != b ) is always...
SQL = Scarcely Qualifies as a Language
April 22, 2009 at 8:11 pm
I am getting High disk queue length when
1) Full Backup is running
2) Anti virus is running
3)rebuild indexes
4)DBCC CHECKDB
High disk queue lengths are to be expected as these SQL Server operations...
SQL = Scarcely Qualifies as a Language
April 22, 2009 at 11:06 am
From "Implementing Log Shipping" at http://technet.microsoft.com/en-us/library/cc917705.aspx
Because log shipping relies on the SQL Server restore process, user connections to the standby database must terminate each time the transaction log is restored....
SQL = Scarcely Qualifies as a Language
April 21, 2009 at 1:22 pm
If the machine were you are running SQL Server Management Studio does not have the needed fonts installed to view these characters, the data will be garbabled"
Do these appear correctly...
SQL = Scarcely Qualifies as a Language
April 10, 2009 at 3:16 pm
Use a single quote around the entire command and double quotes to delimit the start and end of strings.
exec master.dbo.xp_cmdshell 'dir "c:\program files\*.*" '
SQL = Scarcely Qualifies as a Language
April 9, 2009 at 2:39 pm
Book OnLine states that the FLOOR function returns the same datatype as the input but this statement is misleading because, for a NUMERIC datatype, the returned datatype is a NUMERIC...
SQL = Scarcely Qualifies as a Language
April 9, 2009 at 6:46 am
As your table has four columns with the text datatype, you may encounter the situation described by the below MS information article, especially at you indicated that creating a copy...
SQL = Scarcely Qualifies as a Language
February 19, 2009 at 9:25 am
Stored procedure msdb.dbo.sp_reassign_dtspackageowner can be used to change the owner of a DTS package but MS has hard-code logic to restrict the usage only to the current package owner or...
SQL = Scarcely Qualifies as a Language
February 18, 2009 at 10:53 am
As others have indicated, the limiting factor is the load the applications put on the server. For example, I support a SQL Server 2000 that has over 6,500 databases...
SQL = Scarcely Qualifies as a Language
January 19, 2009 at 12:57 pm
Itzik Ben-Gan, a SQL Server MVP, has exactly the solution !
The problem involves calculating the maximum number of concurrent sessions for each application that an organization uses. For this problem,...
SQL = Scarcely Qualifies as a Language
October 22, 2008 at 2:52 pm
What are the advantages of this SQL over using the INFORMATION_SCHEMA views defined in the ISO SQL standard?
select *
from INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%Employee_Id%'
SQL = Scarcely Qualifies as a Language
September 10, 2008 at 8:46 am
Your post indicates a 160 GB HDD - is this a SATA, ATA, or IDE drive ?
In order to insure data integrity, the disk drive cache must be disabled or...
SQL = Scarcely Qualifies as a Language
September 6, 2008 at 8:22 am
A computed column cannot be used as defining expression may only reference base columns within the same table.
You will need to add a physical column and then use a trigger...
SQL = Scarcely Qualifies as a Language
September 6, 2008 at 8:11 am
Viewing 15 posts - 256 through 270 (of 1,131 total)