Viewing 15 posts - 38,191 through 38,205 (of 49,552 total)
It's a good idea if you're expecting inserts into the middle of the index and you want to minimise fragmentation. That's certainly a possibility with the index you have defined...
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
June 25, 2009 at 9:41 am
Tim Walker (6/25/2009)
Additionally I am guessing it uses the index based on the varchar(3) column because it occupies less pages than the varchar(15) one.
Depending, of course, on the size of...
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
June 25, 2009 at 9:38 am
Grant Fritchey (6/25/2009)
Gianluca Sartori (6/25/2009)
I don't' remember such a rainy and (relatively)...
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
June 25, 2009 at 6:50 am
Eswin (6/25/2009)
How to avoid clustered and non-clustered index Scan's and also table scans.
Indexes that support the queries.
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
June 25, 2009 at 6:47 am
Those two queries are not equivalent. In the second one, only rows from bbb or ccc that satisfy the condition are presented for the join. Now, in an inner join,...
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
June 25, 2009 at 6:15 am
hi_abhay78 (6/25/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
June 25, 2009 at 6:02 am
Tim Walker (6/25/2009)
I wouldn't recommend testing behaviour on empty tables either, because I think it can produce misleading results.
Indeed. Reading 0 pages is pretty quick no matter what index.
Load...
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
June 25, 2009 at 5:36 am
Haver you checked that the script hasn't been truncated? Job steps only allow so much text in them.
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
June 25, 2009 at 5:32 am
Those aren't object_ids. Way too long to be an object id. It's partition id. Query sys.partitions with that to get the object and index id.
p.s. can you please edit your...
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
June 25, 2009 at 5:29 am
vrabhadram (6/25/2009)
please provider suggetions.
Don't truncate the transaction log. Don't shrink the transaction log. Both are not recommended for regular maintenance. Only time you should be shrinking the transaction log is...
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
June 25, 2009 at 4:26 am
Or you could restore the backup, add clustered indexes to the tables that are heaps and drop the clustered indexes straight after. That'll remove extent fragmentation.
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
June 25, 2009 at 4:18 am
saidwarak01 (6/24/2009)
HI ALL,I CREATED A TABLE AND APPLIED CHECK CONSTRAINT USING IN AND LATER I AM ENTERING DATA WHY CHECK CONSTRAINT IS ACCEPTING ALL THE INSERT STATEMENTS.
Please don't post in...
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
June 25, 2009 at 2:36 am
As far as I can tell (http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx), pad_index is not a valid option for ALTER TABLE ... ADD CONSTRAINT, only for CREATE INDEX
Why do you want to pad the 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
June 25, 2009 at 2:34 am
Because the last nonclustered index that you added is covering (contains all the columns that the query needs) and is smaller than the cluster (because the cluster is 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
June 25, 2009 at 2:25 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic741584-148-1.aspx
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
June 25, 2009 at 2:23 am
Viewing 15 posts - 38,191 through 38,205 (of 49,552 total)