You can think of the schema as the container that objects belong to. I would recommend reviewing books online on the subject because there is much more to it.

When...

I setup separate maintenance plans for system databases and user databases. They are independent from each other.

Not sure about reporting services - but, you can try changing the windows identity in SQL Server Configuration Manager.

When the system was renamed, you probably have the old IUSR accounts...

Why is using all of the memory on a system bad? Well, you could answer that yourself couldn't you? 😉 You have to restart the system all...

You still need to add the new server in using sp_addserver 'new server name', 'local';

You should also take a look at fixing the Windows groups that SQL Server creates. ...

You should be aware of what using BACKUP LOG ... WITH TRUNCATE_ONLY is going to do. This is going to break your log chain, so you are going to...

When looking at the dynamic setting - does it show that you can set it to 16GB? What is the SQL Server version you are running - Standard or...

Start making it a habit to place a use statement before your create/alter statements for all objects. It will save you a lot of hassle in the future.

For example:

USE...

Before you can get very far with this type of query, you need to define 'previous row'. What is the relationship between the 'current row' and the 'previous row'.

The...

I'm sorry, but maybe I am missing something fundamental here.

Where is the lost revenue? If someone is going to purchase the audio version of the book, why...

If you have the list of accounts available in a table, you could alter your syntax to:

DELETE FROM Member

WHERE Email IN (SELECT Account FROM AccountTable);

If you have this list...

You can't schedule using SSIS - SSIS is not a scheduler product. You can use SSIS to process the stored procedure, or as Flo mentioned using the Execute SQL...

San (5/25/2009)

---

Thanks for your immeidate reply.

Wel, BTW wot if the number of transactions and also the size of the transactions as exatly same..? And maintenance jobs such as index rebuild...

Depends on where the Description field is - and whether or not it is related to the SortName. If not related, just add an AND to the where clause...

Kris (5/24/2009)

---

This is what I have so far.

SELECT Customer.Name AS SortName,

vcltAttrib4_364.ainTVal AS Client_Relationship_Partner,

vFEAttrib4.attInstName AS Partner,

Matter.mtrDesc AS Description,

Matter.mtrDateOpened AS Date_Opened,

Matter.mtrDateClosed AS Date_Closed

FROM ((((Customer LEFT OUTER...