Search Results | SQL Server Performance Forums

Datetime as Primary Key or Unique constraint?

Thread by: lucutus, Oct 6, 2008, 1 replies, in forum: SQL Server 2005 General Developer Questions

Hello, I have a table where I want to insert values for each day and each ID: Table: Availabilities HotelID (bigint) Day (datetime) Availability...

xml production with default namespaces and subqueries

Post by: lucutus, Feb 16, 2008 in forum: SQL Server 2005 General Developer Questions

Its disappointing that nobody had any thoughts about this. Here are two ways to get rid of the additional (default) namespaces: Look at this xml...

openxml vs nodes()

Thread by: lucutus, Jan 21, 2008, 4 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello guys, I would like to open a thread here at sql-server-performance about the advantages and performance impacts of 2 different ways to bring...

xml production with default namespaces and subqueries

Thread by: lucutus, Jan 21, 2008, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hello all, I recently started a project to produce xml data from relational data with default namespaces. I use the new path method. An abstract...

Replace &amp; with simple &

Post by: lucutus, Dec 14, 2007 in forum: SQL Server 2005 General Developer Questions

Well, the requirement of escaped & in XML resolved my problems because I am using the resulting XML as a Google Sitemap. The Links inside are not...

Replace &amp; with simple &

Thread by: lucutus, Dec 13, 2007, 2 replies, in forum: SQL Server 2005 General Developer Questions

Hello All, Im trying to do the somthing like this to output a Link in XML Format: SELECT 'http://mysite.com/Hotels?'+HotelID+'&LanguageID'+@Lang...

Comparison of 3 different Queries with same result

Post by: lucutus, Nov 30, 2007 in forum: SQL Server 2005 T-SQL Performance Tuning

It really seems that (in SQL 2005) the IN (subquery) is overestimated. The EXISTS version runs definitly fine and the Plan shows 6 Index seeks. The...

Comparison of 3 different Queries with same result

Thread by: lucutus, Nov 29, 2007, 6 replies, in forum: SQL Server 2005 T-SQL Performance Tuning

Hello All! Im trying to figure out which variant of a query (subquery with EXISTS, subquery with IN, one overall join with group and having) is the...