You can install 32-bit applications on x64 OS, they would just run in compatible mode

I don't see why in your case, SQL x64 should run better on x64 OS

Check the...

Your million dollar answer - it depends!!!

If there's no severe performance problem, using NOT IN is okay

especially for code clarity

NOT EXISTS or OUTER JOIN usually can replace NOT IN with...

+1 for OUTPUT clause

That is something new I learned recently too, which is quite cool

It's almost like TRIGGER's DELETED and INSERTED "hidden" tables

STUFF

http://msdn.microsoft.com/en-us/library/ms188043.aspx

+1

If I remember correctly (actual experiences):

You can write report in BIDS2005, deploy to SSRS2005

You can write report in BIDS2005, deploy to SSRS2008

But if you write report in BIDS2008, you can...

This is what I see from BOL

http://msdn.microsoft.com/en-us/library/cc879320.aspx

To view the Activity Monitor in SQL Server 2005 and SQL Server 2008, a user must have VIEW SERVER STATE permission.

To view the Activity...

I didn't configure FILESTREAM

but I did have to install Full-Text Search before I can restore AdventureWorks OLTP (the installer would tell you why it didn't install, I hope)

Mark Sumner (10/22/2008)

---

1. Assuming the memory limit has not been reached the setting will come into effect immediately. There is no requirement to restart the SQL server service to set...

I remembered having this problem on x64 machines, but never bothered to figure it out

However, today, I installed (from CodePlex) on my SQL 2008 RTM box

SQL2008.AdventureWorks_OLTP_DB_v2008.x86.msi

and chose the "Restore DB...

See if this does it, I put in 50 percent (so half will be swapped)

DECLARE @test-2 TABLE (

FirstName VARCHAR(MAX),

LastName VARCHAR(MAX),

ID INT IDENTITY(1,1)

)

INSERT INTO @test-2

SELECT '1','2' UNION ALL

SELECT '1','2' UNION ALL

SELECT...

cheap, may not be efficient way

DECLARE @test-2 TABLE (yr CHAR(2))

INSERT INTO @test-2

SELECT '99' UNION ALL

SELECT '00' UNION ALL

SELECT '01' UNION ALL

SELECT '02'

SELECT YearRange = yr + '-' + new

FROM (

SELECT...

search for SPLIT functions, or pass in parameters as Arrays

or inline UDF functions that convert a Comma-Separated parameter into a table

quick (but may not be fast) solution is to use...

2005 SE to 2008 SE = not worth it if you don't need 2008 features (such as Spatial, FILESTREAM)

As for developers or DBA's, 2008 provides cool features

Developer: IntelliSense, MERGE (instead...

As far as I know, SQL 2008 RTM requires .Net 3.5 SP1 (not just 3.5) and will install for you if not present

Glad you found the problem (from the log)

2008-10-18 13:51:59.28 Server The SQL Server failed to initialize VIA support library [QLVipl.dll]. This normally indicates the VIA...

Give this a read

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=337816&SiteID=1

and check the SQL Logs for more detailed logging

typically found under C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG