Jon, I believe we call them 'Contractors' I know I have picked up the remains of 'in-out' coders before and I'm...

When I took 431 I must admit I found it pretty easy. But it has such a wide scope it means you need to know a lot. ...

Yes,

You will also pick up which are the new features and then get infuriated being unable to use them to solve problems

How large is very large?

How much new data do you get daily?

Transactional Replication load depends on the number of changes not the size of the db and the servers and...

Instead of using Shrinkdatabase you can use dbcc shrinkfile.

This allows you to shrink specific files.

First look in taskpad view in Enterprise Manager at your DBs and see...

The main thing about an album as opposed to a collection of songs is it needs to flow.

Pink Floyd - Dark side of the moon is the best example I...

Totally agree on the dependence on MS products for the user of this site. Most products built on dbs are not likely to jump from one DB to...

My understanding of your initial problem is that you have some rows which had productCondtionId = 0 and some productCondtionId = 1

But both mean "damaged"

try:

update tblReturnProducts

set...

Totally agree with the earlier comment on Indexes with no real ideal candidate. However I believe this does actually capture the spirit of the role. You...

insert the following into the script:

declare @var varchar(30)

declare c1 cursor for

select mychar from mytable where mychar = 'abc'

open c1

fetch next from c1 into @var

WHILE @@FETCH_STATUS = 0

BEGIN

select '@var =...

I think this is because SQL ignores trailing white space when comparing strings.

edit the script with

insert mytable select 'abc '

insert mytable select 'abc'

select * from mytable...

Four weeks holiday is a legal minimum in the UK, 5 is considered more normal and anything over 25 days is generous. Plus we get about 9 bank...

I would recommend the MCITP on the basis that it is more current and has less exams.

If you can use 2005 you should be able to use...

Jambu,

Never really thought about southern England as being remote due to all the towns, motorways, planes etc.

However from your perspective it probably seems more like that.

However from reading...

I agree with Michael,

I was in the cape for New Year a couple of years ago and it was 27 degrees when I stepped off the plane.

They apologised...