VB is wrong.  1900 was not a leap year, so there should not be a 1900-02-29.

Each row in table1 where field1 = 'char 200' is being joined with all 17 rows in table2 where field3 = 'char 200'.  This is why you are getting 289...

It would help to see the DDL for the tables.

Interesting, SELECT ISNUMERIC('-') returns the value 1.  If you do the following, you see why:

SELECT ISNUMERIC('-'), cast('-' as int)

The cast returns 0 (zero).

Wouldn't select * from some_table where not isnumeric(some_column) give you what you were looking for?

If Auto-Shrink is on, it may.  It is better if auto-shrink is not on, and you can schedule a process to shrink the file during a time of less database...

Not necessarily the most elegant solution, but based on your sample data, it seems to work:

select distinct

    d1.hospital_id,

    d1.patient_id

from

    #diagnosis d1

where

    exists (select 1 from #diagnosis d2 where d1.hospital_id =...

An earlier post said to truncate the transaction log after running a full backup, I'd run the full backup immediately after truncating the transaction log.  This will then allow the...

We do the best we can with what we have.

Ninja,

I keep forgetting about the right() function.

Try something like this:

declare

@varStr varchar(255)

set

@varStr = 'Jones, Tom'

select

Indexing the money fields would only make sense if your queries are selecting on those fields.  For instance, you are looking for all products in inventory with a unit price...

You could consider those long running, but there also could be updates or loads that take several minutes to hours to complete as well depending on what type of database...

What is your current backup strategy?  If your database is in Full Recovery Mode, but you are only taking Full Backups, the transaction log will not be truncated.  This only...

Based on your simplified example, try this:

SELECT

* FROM tbl1 a

where

a.DataValue in