Run the following query, which will generate the SQL to change the permissions all at once.  Be careful, because if you have any DENYs on any of the views, they...

If I understand your requirement correctly, you're looking for a query that will return all TransBaskets that contain the specified two items.  This should do it for you:

--Create the table...

Mitesh

This part of your query worries me:

((ISNULL(SUM(InvoiceTotals.[Total Net]), 0) -

ISNULL(SUM(InvoiceTotals.[Total CostBC]), 0)) /

ISNULL(SUM(InvoiceTotals.[Total Net]), 0)) * 100

If all the values in [Total Net] are NULL, then you're going to have a...

The REPLACE statement is what you are looking for.  You can replace certain characters with an empty string to get rid of them.  Also, you can nest the statements to...

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