For a production environment and depending on the reports and its users I would suggest using the Report viewer control in VS and creating a page to point to...

Most cases I have seen include full backups over the weekend due to low activity on the server and differential backups every night on week days with log backups depending...

Since your using 64 bit SQL Server you actually do not need to enable lock pages in memory to avoid paging , mainly since sql will be able to address...

Are you referring to the windows firewall in the OS ? Have you added an exception to the default port for sql server 1433 under the windows firewall ? What...

Don't really have many date based queries. I use ids since they have little scope for confusion such as date formats and precisions etc. However I would never use...

How fast does it return results when you replace the update with a select ?

Are there Nulls in the columns on which your joining the tables.

the below link gives an idea of the difference between the two collations

ie one for UK-en and one for us-en

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

Naturally for most cases collation affects sort order and how strings...

Thanks Jeff , couldn't have explained it better myself. However I have one deviation from whats mentioned in the above post , I prefer not to use a index on...

The paging is handled by the OS and any recommendation provided by the Operating system guide should be good enough.

http://support.microsoft.com/kb/889654

You can decide if you want more than 1 page...

Assuming the basics are taken care of such as proper indexes and updated stats , there could probably be problem with the distinct operation when dealing with huge tables. More...

A very crude answer to your question would be

Clustered index work better on tables which have a column that can be used to uniquely identify each row.

Non Clustered indexes...

Option 2 is not only easier to implement but also more robust as a solution. Use schema binding on the view to make sure future changes are caught properly. The...

GilaMonster (7/6/2011)

Not necessarily. There are a number of things that can...

Thanks Gail for being meticulous always

So this should happen only if sql was shut down during such a long running uncommitted transaction , and that too only because it performs a rollback of the said...