You can use source control such as Subversion to store all your SP code and use this to keep track of changes

what i would do is;

Import the csv file as set all the fields to import a string,

do some transformation on the suspect dates to set them to a similar format

Convert...

It is really hard to say without more information.

Is there anything unsual about the 28 rows that were left out?

Do you have a lot of transformations that could be dropping...

why would you want to shrink a 184kb datafile? that...

yes this is something that you will have to do manualy, it is different from the AUTO-SHRINK option.

But be aware that unless you have had a lot of ...

straight from BOL

DBCC SHRINKDATABASE

( 'database_name' | database_id | 0

[ ,target_percent ]

[ , { NOTRUNCATE | TRUNCATEONLY }...

Right Click on databases node on...

To generate your scripts right click on the db in SSMS (2005) and click Tasks --> Generate Scripts..

This will give you the scripts that are required to...

You may want to have a look at your noise word list, Now is a common word and may be in the noise word list so it is...

How many images are there?

Are these images stored on a drive anywhere?

This isn't really a 'bug' with SQL.

The problem is SQL server getting the blame for bad application design and coding.

What situation do they need 33millions rows, must be a...

Do they need to select ALL rows?

Are they also selecting all columns? (select *)

SELECT * FROM sys.database_principals

WHERE TYPE = 's'

You can turn on simple recovery and shrink the transacation log, or you can shrink the database file.

Though neither of these are really recomended as SQL server uses as...

to do a count(*) for each table you can use;

sp_MSforeach table

create table #rowcount (tablename varchar(128), rowcnt int)

exec sp_MSforeachtable

'insert into #rowcount select ''?'', count(*) from ?'

select *...