That's fine.  SQL Server will take as much memory as it needs.  If the operating system or another application needs more, SQL Server will give some back.  If you have...

Mitesh

You haven't posted your original query, but I'm guessing you used an INNER JOIN to join the Employee table to the InvoiceTable totals.  Try using a LEFT OUTER JOIN, and...

Sounds like either your statistics are out of date (unlikely since they will have been updated when you reindexed) or you are using an out-of-date cached execution plan.  Try running...

Umesh

To see what the recovery mode is, right-click on the database in Enterprise Manager, choose Properties, and click on the Options tab.

Backing up the entire database doesn't truncate the transaction...

Umesh

Large transaction logs aren't necessarily bad in themselves in an OLTP database.  Are your databases in Full or Simple recovery mode?  How often do you back up the transaction logs?

John

Robert

If you want to be alerted when someone is trying to enter invalid data, then you'll need to create a trigger on the table.  Otherwise, you can create a check...

Robert

If you want to be alerted when someone is trying to enter invalid data, then you'll need to create a trigger on the table.  Otherwise, you can create a check...

Only if the server is shared with another application that grabs memory like SQL Server does.  If your box is dedicated to SQL Server, let SQL Server manage memory dynamically,...

John

The best way to recover from a torn page is to restore the database from a good backup.  If you don't have that option (and if you don't then you...

No.  Let SQL Server use as much memory it wants.  Otherwise there's no point in using the /3GB setting.

John

I assume you're using Enterprise Edition?  Otherwise the /3GB setting will have no effect.  You don't need to take any further action - SQL Server will manage the memory dynamically.

John

Mark

By reading the posts on this site, I think!

John

James

Sergiy is right - you should look at normalising your database by splitting distinct data from your text field into separate columns.  However, to answer your question... look up the...

Dan-Ketil

Yes.  Use the DBCC SHRINKDATABASE statement.  You'll find the syntax in Books Online.

John

John

I've taken the liberty of making the following the Sunday the end date of the week, rather than the Monday that starts the next week, as you have in your...