I personally do not trust users to know what a table or a column is let alone what they are called in the database.

I am also not...

Something like this?

http://www.mssqltips.com/sqlservertip/1764/steps-to-install-sql-server-2008-service-pack-1-sp1/

Sorry, just couldn't copy and paste as fast as Lynn. 🙂

CREATE TABLE #temp

(

[Friday1] CHAR(10) ,

[Friday2] CHAR(10) ,

[Friday3] CHAR(10)...

Way back when I used to program a lot of Access front end applications I found that using any kind of "bound" form or report would perform poorly due to...

As long as database backups are taken I would not backup up the MDF, NDF or LDF files. Its redundant and less usefull.

The OP asked if his plan to partition the table could improve performance and I stated a fact about what he was proposing. Was I wrong?

I...

Yes. The concept is called 'partition elimination'. Especially when scanning the table for a date range, the optimizer will realize it only has to scan the current year...

I believe the answer is Yes there is a performance difference.

The non-clustered index on a HEAP must find the page using the ROWID then find the row data...

My experience with Access is that anything done with GUI tools is unacceptably slow. Therfore, I always use unbound forms with VBA code that opens recordsets directly and places...

Some people think that SQL server 2008 and SQL server 2008 R2 are the same thing. And they are on different service packs.

When you launched setup.exe did you right-click and select 'run as administrator'? I have found that even though the account I am logged in with is a local admin,...

Your first method is close.

The AD group should be added to the SQL server and granted the level of permissions needed. DBA team probably needs sysadmin server...

This is a job for SSIS.

Youre windows account must be added to the logins on the SQL server. In order to do anything in addition to connecting you will also need permissions to access...