Viewing 15 posts - 36,466 through 36,480 (of 49,552 total)
repent_kog_is_near (10/3/2009)
I'll wait for George is he is able to share the code to get the TempDB into 8 junior TempDBs!!
No need to wait for George. Use Books Online 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
October 4, 2009 at 5:33 am
Yes
You know, you could probably have tested it out and had an answer far faster than waiting for someone to notice your question.
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
October 4, 2009 at 5:32 am
The NOEXPAND hint is only valid for indexed views. Normal views have to be expanded because they don't actually stored any data, they're just saved select statements.
Remove all of 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
October 3, 2009 at 1:27 pm
With the exception of the heap (which can't be rebuilt because it's not an index), not one of those is over 20 pages in size. Rebuilding very small indexes 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
October 2, 2009 at 2:20 pm
Well, that output is for multiple tables (5 to be specific), not just the one that you're talking about.
Can you get the output just for the table that you're interested...
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
October 2, 2009 at 1:51 pm
spatnaik77 (10/2/2009)
I am thinking of using HINT in the query.
Why?
Do you want to see a query that uses an index seek or do you want the most efficient query...
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
October 2, 2009 at 1:48 pm
Please post results of this query for the table in question
select index_id, index_type_desc, avg_fragmentation_in_percent, page_count
from sys.dm_db_index_physical_stats(db_id(), object_id('Table Name'),null, null, 'limited')
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
October 2, 2009 at 10:21 am
Look up DATEADD in SQL's Books Online.
If you want to default to yesterday at midnight, then check this blog post out.
http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/
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
October 2, 2009 at 10:09 am
Please post the execution plan of the query in question, both where there are multiple single-column indexes and where there's one composite index.
I don't see any query in your posted...
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
October 2, 2009 at 9:56 am
spatnaik77 (10/2/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
October 2, 2009 at 9:30 am
dndaughtery (10/2/2009)
When I recreate the index are the primary constraints and unique constraints recreated as well or do I need to run a script to recreate them as well?
If 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
October 2, 2009 at 8:43 am
How large is the index in question? How many pages?
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
October 2, 2009 at 8:32 am
spatnaik77 (10/2/2009)
--Following query should pick the index IX_AGE but is not picking this...
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
October 2, 2009 at 8:28 am
dndaughtery (10/2/2009)
When loading data into a table and I drop the index in order to get better performance. Does this effect the constraints?
Foreign key constraints, no. Unique and primary key...
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
October 2, 2009 at 8:19 am
xyzt (10/1/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
October 1, 2009 at 2:15 pm
Viewing 15 posts - 36,466 through 36,480 (of 49,552 total)