Viewing 15 posts - 36,736 through 36,750 (of 49,562 total)
gmamata7 (8/29/2009)
So could please tell me what to modify in order to Exclude Reorganize logic & it should work for all the databases in an instance.
ps has already told you,...
August 30, 2009 at 2:15 am
Tell your client that this is a really, really, really bad idea. Yes it's possible, but most implementations are either very slow as you need to ensure that there's only...
August 30, 2009 at 2:14 am
Ever since I started working from home I've found that weekends don't mean quite as much. It matters to no one whether I work on Wednesday and go shopping and...
August 29, 2009 at 2:01 pm
Clive Strong (8/29/2009)
I did read that you should not perform any online rebuilds and I would imagine this would extend to reorganize operations whilst BizTalk is processing.
I would like to...
August 29, 2009 at 10:46 am
This looks very much like homework. Is it?
We don't solve people's homework problems for them, they learn nothing if we do. Have a go at them yourself, if you get...
August 29, 2009 at 9:29 am
Paresh Prajapati (8/29/2009)
So, is those column are eligible for index?Or, can you tell, how much minimum rows require for eligibility for creating index?
They're certainly eligible for indexes, nothing's stopping you...
August 29, 2009 at 9:15 am
Paresh Prajapati (8/29/2009)
create index IC_Col1 on table(id) include (name, city)
create index IC_Col2 on table(id)
1. which of above index is used for
select name...
August 29, 2009 at 9:14 am
Sourav (8/28/2009)
Clustered index never contain any NULL values as Primary key is imposed to it.
Clustered indexes are not primary keys and primary keys are not clustered indexes. A clustered index...
August 29, 2009 at 7:21 am
Can you make the column an identity? That let's SQL handle the incrementing and you can be sure that it will work.
August 29, 2009 at 7:20 am
Don't know about case 1, but case 2 has irreparable corruption. There's some damage that's preventing CheckDB from running and there is no way that it will be able to...
August 29, 2009 at 7:19 am
Roy Ernest (8/28/2009)
Thanks Grant, I am hoping it will continue like this.
Don't be worried if it doesn't. I'm only now, almost a year later, getting the same attendance I...
August 29, 2009 at 7:14 am
There's no real use. It's just that within unique indexes is the only place where nulls are considered the same. Unique indexes and unique constraints only allow a single null....
August 29, 2009 at 7:12 am
Ed (8/28/2009)
Since these db's are never written to again, is it still necessary to run CHECKDB on them?
Yes it it. SQL doesn't corrupt it's own databases while writing...
August 28, 2009 at 3:53 pm
CAn you please post the exec plan from the SQL 2005 server as detailed in the article I referenced above. You're missing indexes, I can't tell which ones without seeing...
August 28, 2009 at 3:42 pm
Execution plan please. Just the SQL 2005 one is fine.
August 28, 2009 at 1:17 pm
Viewing 15 posts - 36,736 through 36,750 (of 49,562 total)