I would suggest as follows:

DECLARE @Count int

Select @Count = Count(ColID) from Table1 WHERE ColFlag = 1

if (@Count > 0)

Calls an exe.

Kimberly.Hahn (4/8/2009)

---

"meaning that there is a benefit to adding it"

Not really. SQL usually wants stats on anything that "might" have benefit. It wants the stats on the data...

I'm not sure how much it will help, but you could consider the following -

If the optimizer says that a stat is missing then it would have liked to...

It also depends on isolation level - assuming that you are using read committed and that the index is selective enough to identify just the records needing an update, then...

If you are auditing failed logins (which is the default) then you probably have errors in your SQL logs. You can also look at the default trace output in...

Mirroring is really a process of continually restoring a database from log entries, and as such it shouldn't matter whether the servers are 32bit or 64bit.

However - what are you...

It depends on your environment, but if data was generated under Windows you should use

LIKE ('%' + CHAR(13) + CHAR(10) + '%')

What kind of steps do you mean - automation? additional means of checking the tables?

Off the top of my head I would suggest looking into the CHECKSUM and CHECKSUM_AGG functions:

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

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

Note...

That screenshot is of the account settings. If you just want to send an email to multiple addresses then type each address on the recipient line in turn separated...

There is one other difference based on what you have told us - the primary key will be a unique index. This may be a reason why it is...

It really depends on whether you need to take distinct backups. If it's feasible to take one backup and then copy it to each location then you save on...

This is called ownership chaining, here is the BOL link:

http://msdn.microsoft.com/en-us/library/ms188676(SQL.90).aspx

The user has implicit access to the objects (via the procedure only) because the owner of the procedure matches the owner...

I haven't had to touch Access in about 15 years, so ultimately you should test for yourself. I can say that the trigger is part of an atomic transaction...

If you mean instead of deleting each individually, then you have 2 choices -

1) write a script

2) use the Object Explorer Details pane in SSMS to list the...

As a general rule you should try and backup the log so that you can restore as much data as possible, and not just to the last full/differential backup. ...