if the interviewer asked "which book" then he probably is not the best person to interview candidates but on ther other hand if he just wanted to know if you...

seems fairly simple , i would personally use partitioning since it handles the whole process with far less stress on the DB but it would be just as easy to...

I assume the issue your trying to avoid is the sort order problem with unicode as mentioned in the below link.

http://www.olcot.co.uk/sql-blogs/revised-difference-between-collation-sql_latin1_general_cp1_ci_as-and-latin1_general_ci_as

else there should be little need to change the collation...

it seems your using OPENquery in the select statement , what kind of performance does the second server have , are the two machines on the same network?

have you tried...

In a cluster the storage system is the single point of failure so i wouldnt overlook the warnings. It seems to a simple firmware upgrade and not worth risking your...

Have you checked the compile time using SHOW STATISTICS TIME ON?

Its very rare for the complile time to be affected by the amount of RAM since SQL internally reallocates space...

you need the latest SP , always on is available in windows 2008 r2 sp1 and above.

If you know you have three fixed tables and three fixed flat files , which part of your SSIS package are you expecting to be dynamic? is it the rows...

How big is the table ?

How do you plan to use the backup?

@Op instead of using temptables , you could try using recompile hint and see if the performance improves. Using a temptable just to avoid problems with the base table when...

As Gail said if you have the lastest backup that's the only way to prevent data issues. If you have only a mdf file and no ldf file then you...

execl and access use the JET provider

Since timetrack is returning fewer rows , my guess its the other table tha has a duplicate userid , you really should add a PK or atleast a Unq constraint...

You might want to make sure you have MS office and power view plugins as well. A key part of the MS BI plan is to enabled self service via...

Your research is right , HA is done using cluster and DR is done using Backup and restore. Reprocessing is not required if the backup is taken after the...