Just an FYI on adding the where clause for pay_week. Do it in both of the subqueries as well as the outside part of the UPDATE for best performance.

So something...

We found that putting the text and image stuff in it's own data file would correct this issue. I seem to remember and MS article on it somewhere but I...

On your maintainence plan what is the point at which a shrink will occurr in MBs. The index rebuild will leave a lot of free space many times, I am...

Actually it can be a NULL. Consider with a char datatype object or any fixed length object. The length of the data is still stored even if the value is...

You might consdier using a Data Driven Query task instead so you can use the lookup functionality or build the check and choice of Update/Insert into the SP.

I think this is the rough equalivilant to you cursor. I have not optimized too much so could be a better version of this that could be built. And it...

Frist let's verify what you're trying to do here. I made notes after the issues.

declare @glov_id varchar(10)

declare @ult_id varchar(10)

declare @diff decimal(10,2)

declare @pweek datetime

declare @emp varchar(6)

declare @Ttl_Hrs decimal(10,2)

declare @Ttl_ProHrs decimal(10,2)

DECLARE mod1...

Sounds to me you just wants to validate the existance of data however I am not sure you want to do

select * FROM dbo.main_yoel WHERE (NOT (mafname1 IN (0))

for sure...

Unfortunately you will need to restore to the point before you made the mistake from backup to another database then import the right data back in. Make sure you change...

The wording left me with a question of what you are meaning. nytime autogrow occurrs it may not lock the process from occurring but it does have some effect on...

"TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes and so on remain. The counter used by an identity for new rows...

Reindexing will cause log file and databse growth while occurring. Do it first then DB and file shirink next.

Sorry I know of no tool that can do that kind of fuzzy logic. Might be a cool tool but you might be able to do in the background a...

There can be changes to the db strucutre without notice. This is why you have to backup are each SP ot Hotfix. Then when you restore you install SQL Server,...

Create stats occurrs based on the significant number of times a column appears in submitted queries sorry don't have the threshold.

Update stats is based on the number of data changes...