Viewing 15 posts - 1 through 15 (of 83 total)
Jon, I believe we call them 'Contractors' I know I have picked up the remains of 'in-out' coders before and I'm...
May 21, 2007 at 8:50 am
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. ...
May 8, 2007 at 8:15 am
You will also pick up which are the new features and then get infuriated being unable to use them to solve problems
February 15, 2007 at 9:03 am
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...
February 14, 2007 at 2:27 am
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...
February 13, 2007 at 9:35 am
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...
February 9, 2007 at 3:34 am
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...
January 21, 2007 at 2:45 pm
My understanding of your initial problem is that you have some rows which had productCondtionId = 0 and some productCondtionId = 1
But both mean "damaged"
December 19, 2006 at 10:46 am
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...
December 14, 2006 at 5:53 am
insert the following into the script:
declare @var varchar(30)
declare c1 cursor for
select mychar from mytable where mychar = 'abc'
fetch next from c1 into @var
WHILE @@FETCH_STATUS = 0
select '@var =...
December 12, 2006 at 5:32 am
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...
December 12, 2006 at 4:29 am
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...
December 11, 2006 at 3:35 am
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...
December 8, 2006 at 8:34 am
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...
December 8, 2006 at 8:22 am
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.
December 8, 2006 at 4:52 am