Viewing 15 posts - 35,266 through 35,280 (of 49,552 total)
deanrjohnson (12/15/2009)
Thats one of the issues 🙂
Actually doing it is not hard, if there's a simple rule as to which row to keep. I'm sure once the schema's posted there'll...
December 15, 2009 at 2:18 pm
Something for you to think about.
If two rows have duplicate values for those 4 columns, but different values for the other three, which row would you want to keep and...
December 15, 2009 at 1:39 pm
Do note that snapshots cannot be backed up. If one runs out of space it immediately becomes suspect and has to be dropped. Also, they're not free, there's an IO...
December 15, 2009 at 1:16 pm
That's a problem. The heap can't be rebuilt, except by putting a cluster on it, and if there are pages partially used in the heap they'll stay partially used until...
December 15, 2009 at 1:10 pm
Hang one, just noticed what you said in the first post. "fetch hundreds of rows one by one"
Are you indeed retrieving one row, then doing something with it, then the...
December 15, 2009 at 1:10 pm
wimark (12/15/2009)
The select is not part of a transaction nor do I want to lock the records during a the slow printer output.
Unless you're using read uncommitted, you are locking...
December 15, 2009 at 1:08 pm
If you look at the script that management studio GUI runs, you'll notice that it's dropping and recreating the table for changes like that. It doesn't just alter the table,...
December 15, 2009 at 10:57 am
Are you doing the select WITH NOLOCK or are you explicitly setting the READ UNCOMMITTED isolation level?
December 15, 2009 at 10:55 am
How did you change the length/type of the columns? ALTER TABLE or via the management studio GUI?
December 15, 2009 at 10:00 am
The GO is not necessary and, if this is for a stored proc, shouldn't be used.
December 15, 2009 at 9:29 am
Well, think about it logically.
If you put the create table before the drop table, then you'll be dropping the table that you just created.
If you put the create inside the...
December 15, 2009 at 8:45 am
amoericke (12/15/2009)
December 15, 2009 at 8:42 am
Clustered index, yes. Primary key, Unique constraint, don't know. Maybe.
December 15, 2009 at 8:40 am
Bhuvnesh (12/15/2009)
how can i avoidkey lookup
Start by only returning the columns that you really need. No SELECT *
December 15, 2009 at 8:07 am
Viewing 15 posts - 35,266 through 35,280 (of 49,552 total)