SQL Server Performance

Search Results

Search Again
  1. lucutus

    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...
  2. lucutus

    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...
  3. lucutus

    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...
  4. lucutus

    Replace & 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...
  5. lucutus

    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...
Showing results 1 to 5 of 5
Search Again