Viewing 15 posts - 36,721 through 36,735 (of 49,552 total)
espanolanthony (8/30/2009)
where a.job_id = b.job_id
and b.name like 'JOB NAME'
order by run_date desc , run_time desc
(no modifications were made to 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
August 30, 2009 at 10:54 am
None whatsoever, providing ClientID is the leading column in the index.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
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
August 30, 2009 at 10:38 am
Those are the actual logs. MSDB is where SQL Agent writes all job-related logs. If there's nothing in the table, it means that either somone's deleted them or SQL Agent...
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
August 30, 2009 at 10:33 am
PaulB (8/30/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
August 30, 2009 at 10:30 am
It's not going to be trivial to change that to run over all databases. dm_db_index_physical_stats can easily report on all the indexes on the entire server, but the second part,...
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
August 30, 2009 at 3:45 am
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,...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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...
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
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.
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
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...
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
August 29, 2009 at 7:19 am
Viewing 15 posts - 36,721 through 36,735 (of 49,552 total)