I have 3 tables Library , Book and Library_Book which is a many-to-many join table containing primary keys of Library and Book tables as the only 2 columns. Both these columns form a composite primary key for the join table Library_Book. LibraryId is of type GUID and BookId is of type int. The Library...

Hello, I have a simple query in a stored procedure that matches on a table of about 12,000 rows and 20 columns containing strings. The search is performed using conditional CONTAINS (). The execution of queries in development environment with SQL Server 2005 takes about 100-200ms for each row, while...

Recently, when I heard SQL Server 2008 had been released I naturally got curious about it, since 2005 was a major improvement over 2000, so I decided to install it. After about 3 hours of hell, over 10 reboots, installing several dependencies (which IMO should have been part of the installation, or at...