What are the query optimization techniques used in SQL 2000?
What are the query optimization techniques used in SQL?

Answer Question   |  August 28, 2010  5:22 PM
SQL Server 2000, SQL Server 2000 queries, SQL Server Query, SQL Server query optimization

Does SQL support nonlinear recursive queries?
does sql supports nonlinear recursive queries

Answer Question   |  July 21, 2010  10:15 AM
SQL, SQL Query, SQL Server, SQL Server Query, SQL Server query optimization

Spatial query optimizing
I have a development machine and a production machine with identical databases, but I’m getting huge differences in execution plans when running a spatial query. First, my development machine: It’s SQL Server Express x64 with Reporting Services running on Win7 with 8Gb RAM. Then my production machine: SQL Server with Reporting Services running on Windows [...]

Answer Question   |  June 2, 2010  11:32 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data

Substring Query SQL
Hi All, I’m trying to build a query to join names in one table to abbreviated names in another table. So for example I have – Harry Harold Harrison on one table, but in the other table I have just Har, this can vary in length so does anyone know how I can sum the [...]

Answer Question   |  March 30, 2010  12:44 AM
SQL, SQL Server query optimization

Optimize the query in sql server
CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID, b.BatchID, b.ParentID, r.Active, CASE WHEN b.ParentID = 0 THEN 0 ELSE 1 END AS IsChildRecord, CAST(b.PersonID AS varchar(4)) AS PersonIDStr FROM dbo.ltcBatch b INNER JOIN dbo.ltcResults r ON b.BatchID = r.BatchID INNER JOIN dbo.ltcPerson ON b.PersonID [...]

Answer Question   |  June 3, 2009  12:35 PM
SQL Server 2000, SQL Server Query, SQL Server query optimization

Performance issues with a large table in SQL Server 2005
I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup for this in which [...]

Answer Question   |  May 18, 2009  12:11 AM
SQL Server 2005 performance, SQL server 2005 performance tuning, SQL Server query optimization

Execute a view/query is slower in SQL Server 2005 than 2000
Hi, I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index. When I run the following query “select top 500 * from myview order by name”, it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely [...]

Answer Question   |  May 2, 2009  9:15 AM
SQL Server 2000, SQL Server 2005, SQL Server Query, SQL Server query optimization, VARCHAR

SQL Server security bulletin MS09-004
Has anyone dealt with issues related to this security bulletin ?

Answer Question   |  February 12, 2009  5:32 PM
SQL Server 2000, SQL Server query optimization, SQL Server security, SQL Server security bulletin MS09-004, SQL Server Security Bulletins