Viewing 15 posts - 3,181 through 3,195 (of 3,366 total)
Open Query Analyzer with your database open click on the index in the object browser and click on create and you will generate the create index statement you need. Hope...
June 27, 2006 at 12:38 pm
Try the link below for all the T-SQL math functions in SQL Server 2005 most require Float data type. Hope this helps.
http://msdn2.microsoft.com/en-US/library/ms177516.aspx
Kind regards,
Gift Peddie
June 27, 2006 at 6:53 am
Try the links below for conversion codes and known issues to get started. Hope this helps.
http://www.karaszi.com/SQLServer/info_datetime.asp
June 23, 2006 at 2:05 pm
Jeff is right and ANSI SQL limit for OUTER JOIN is four you have five and Sums in an indexed view cannot be nullable. Try the link below for more...
June 16, 2006 at 7:41 am
Embarcadero DBArtisan can be used for most RDBMS(relational database management systems) and it is less than $10,000 dollars. Try the link below to test drive it. Hope this helps.
June 15, 2006 at 9:38 am
Try the link below for guidelines to SQL Server DateTime data type use and known issues and limitations. Hope this helps.
http://www.karaszi.com/SQLServer/info_datetime.asp
Kind regards,
Gift Peddie
June 8, 2006 at 6:22 am
Japanese_BIN means Japanese Binary sort order which tells SQL Server it must be case sensitive because case sensitivity is required for SQL Server Binary sort order. So SQL Server is...
June 6, 2006 at 1:29 pm
You could create jobs to run DBCC shrinkfile on both databases and SQL Server will return space less what it calls active log. You have to decide how many times...
June 6, 2006 at 12:04 pm
I am not sure if you can use the list with SQL Server 2000 but the links below is the complete code page and collation listing for SQL Server 2005. Hope...
May 26, 2006 at 11:14 am
Yes one of the reason the Agent is the best thing in the product, the Agent can run your enterprise.
Kind regards,
Gift Peddie
May 24, 2006 at 11:17 am
Print out the 18 pages in the link below and you will understand the internal mechanics of the Query processor, the paper was created for SQL Server 7.0 but it...
May 24, 2006 at 9:39 am
It seems you are Updating a UNION ALL View which is what a Partitioned view is by default with stored proc but you cannot do that because you are updating something not...
May 22, 2006 at 10:51 am
In SQL Server 2000 and below a Full text index uses the Full text Catalog in Microsoft Search service which is a separate install. If you use CONTAIN and FREETEXT...
May 22, 2006 at 8:50 am
Start with sp_who and sp_who2. Try the link below for more info. Hope this helps.
http://www.mssqlcity.com/FAQ/Admin/current_users.htm
Kind regards,
Gift Peddie
May 18, 2006 at 6:53 am
The reason I don't know but print out the eight pages from the link below it will show you how to create location neutral DateTime for your database. Hope this...
May 17, 2006 at 7:22 am
Viewing 15 posts - 3,181 through 3,195 (of 3,366 total)