Yes, using a table level constraint:

-- With this table:

create table test2 (

YesNo char(1) check (YesNo in ( 'Y', 'N')),

otherStuff char(10) null,

constraint nullSometimes check ( ( YesNo = 'Y' and not(otherStuff...

I think you need to use the Case method to make a cross-tab sum. Check out

http://www.aspfaq.com/show.asp?id=2462

Colin - also note that indexes don't speed everything up -- they actually can slow inserts and updates, as the content in each index needs to be brought in line...

Shooting in the dark here, but is it necessary to process the entire table, or when you "load new users" can you just run this update for those records that...

In addition to what's been suggested, some structural changes might help:

1. You could move phone numbers into another, related table. This has the advantage of allowing many or few phone...

what about

alter database yourdatabase set read_only

?

Are there any nulls hiding in the columns you are adding up?

e.g. select * from or51import where grosswgt is null?

The max is somewhere around 254, I think. If you even approach that, it seems like it might indicate a problem with your design, though...

It's a little more involved than that. If you did a back-up and restore, then

a. It was not necessary to create the DB beforehand (but no harm done 🙂

b....

Always a dilemma :-). Back in the day I was a 3D graphics and CAD/modelling guy, and there was one piece of software I liked above all others, which will...

Lee - in spite of Celko's ... er ... single-mindedness about certain things (or because of it? 🙂 he has published some very good books that are definitely worth studying,...

Here's a query that will show the CPU utilisation, if that helps (adjust for your hardware):

/* This query will measure SQL server CPU utilization over a brief timespan. */

declare @timespan...

Yes, put a TOP clause in the query to limit the number of rows.

Also, we use Idera SQL Diagnostic Manager, and like it a lot. It's great for monitoring, and...

OK, I'll bite. Learn one of the .NET languages, VB.NET or C#. They are fun, and useful, and capable. 🙂

Agreed!

But, though my While/Looping answer was tongue-in-cheek, here's a more serious question: what about locking? Does a Declare Cursor on (stuff) lock more (stuff) than would a While loop that...