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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 10:57 am
Are you doing the select WITH NOLOCK or are you explicitly setting the READ UNCOMMITTED isolation level?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 10:00 am
The GO is not necessary and, if this is for a stored proc, shouldn't be used.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 8:45 am
amoericke (12/15/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 8:42 am
Clustered index, yes. Primary key, Unique constraint, don't know. Maybe.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 8:40 am
Edit: Removed incorrect info.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 8:39 am
Bhuvnesh (12/15/2009)
how can i avoidkey lookup
Start by only returning the columns that you really need. No SELECT *
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2009 at 8:07 am
Viewing 15 posts - 35,266 through 35,280 (of 49,552 total)