Your transaction should be essentially instantaneous so the likely hood of an error is minimal unless you are doing thousands of transactions per second. To specifically answer your questions:

1....

I think this query returns what you want:

[font="Courier New"]SELECT

   MEMBER.MEM_CONTACT,

   MEMBER.MEM_COMPANY,

   MEMBER.MEM_EMAIL,

   MEMBER.MEM_TIMESTAMP AS 'DATE REGISTERED',

   MAX(MEMBERLOGIN.MLO_TIMESTAMP) AS LAST_LOGIN_DATE

FROM

   *****.DBO.MEMBER MEMBER JOIN

   *****.DBO.WEBCOUNTRY WEBCOUNTRY ON

       MEMBER.MEM_WCT_WEBCOUNTRYID = WEBCOUNTRY.WCT_WEBCOUNTRYID LEFT...

Adding conditions to a WHERE clause can help or hinder performance. It all depends on indexing and selectivity. If you are using indexed columns then performance should be...

How are you backing up this database? Are you using Native SQL backups or a third party tool? Have you checked the locked files MMC snap-in to see...

I'm not sure you can do what you are asking. It would be easier to help if you included more information in your post. Is the balance column...

I'm not aware of any limit other than readability and practicality. I think the most I have had is 4 or 5 and, IMHO, once you start getting beyond...

Better to backup too much than not enough.

Been there, done that, and got the t-shirt.

susan smith (10/8/2008)

---

Hi, I am new for database backup. our existing backup plan is full DB and transaction log backup every night. The DB backup is immediately after transaction log...

jlp3630 (10/8/2008)

---

Are there any performance differences between EXCEPT and NOT EXISTS?

Currently, I'm using the following "simplified" query (omitting a bunch of joins):

DECLARE @data_date DATETIME;

DECLARE @compare_date DATETIME;

SET @compare_date = DATEADD(week, -2,...

Not being a Service Broker expert I can't give you a solution, but the Queue's used by Database Mail are not started so Database Mail doesn't send the emails. ...

The best way to find out is to test it. Write the query using both methods and check the execution plan and execution statistics.

These following queries all return the...

In a situation like this I would batch the process. Do you have a unique id you can use as part of the process? Something like PK_Table_1 and...

Start by checking who is in the sysadmin and serveradmin roles as you need to be one of those to make that change. You could also change the sa...

Also keep in mind that if your composite clustered index is not monotonically increasing then when you have changes you will more quickly introduce fragmentation of the index/table.