Viewing 15 posts - 16,141 through 16,155 (of 49,552 total)
sys.indexes, not sysindexes
Could have given incorrect results due to how things changed since SQL 2000
SELECT
schema_name(t.schema_id) as schemaName
,object_name(p.object_id) as table_name
,i.[name] AS index_name
,f.name as fileGroupName
,p.used_page_count
,p.row_count
,p.used_page_count * 8192 / (1024 *...
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 13, 2012 at 8:58 am
Please read through this - Managing Transaction Logs[/url]
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 13, 2012 at 8:44 am
What do you mean by 'values'? One row from the table that has that column? List of distinct values from the table that has that column? something else?
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 13, 2012 at 7:28 am
Don't try to move system DBs across versions, it's just asking for all sorts of trouble. Script (or copy) all the objects, don't move the DBs.
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 13, 2012 at 7:27 am
Cannot be done. Databases can never be downgraded.
For log shipping with standby, the secondary must be the same version as the primary. If you're restoring with norecovery, the secondary can...
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 13, 2012 at 7:27 am
You cannot edit the system tables in SQL 2008 (besides, those aren't the system tables, they're views)
Try
GRANT SELECT on spt_values TO public
However, the lack of that permission will not be...
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 13, 2012 at 5:22 am
If you're sa, it won't be a permissions issue, sa has all permissions without needing any specific grants.
Is the table there (select name from master.sys.tables)?
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 12, 2012 at 4:50 pm
Were the IO stats you posted from the count or from the entire 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 12, 2012 at 2:59 pm
Evil Kraig F (10/12/2012)
GilaMonster (10/12/2012)
Doesn't sound like bad plans then, or at least not the type that can be fixed with a recompile. Considered gettign a consultant in?
No joy doing...
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 12, 2012 at 2:57 pm
Ow, nasty query...
Firstly, toss the nolocks unless you're happy with potentially inaccurate results. See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
Multiple subqueries all hitting the same table multiple times. I'm sure we can make that...
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 12, 2012 at 2:15 pm
A 4 byte vs 8 byte index shouldn't cause that much of an effect. Post the execution plans please.
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 12, 2012 at 1:11 pm
Lee Crain (10/12/2012)
For my own knowledge, I want to fully understand the cost of an UPDATE operation.
I would suggest you build a test table and experiment and see for yourself....
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 12, 2012 at 12:21 pm
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 12, 2012 at 12:18 pm
chudman (10/12/2012)
1. Is this a bad practice?
Generally, yes.
Are these single-use plans? The fact that they're ad-hoc is not a problem, if they're single use then there may be a...
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 12, 2012 at 12:16 pm
pooyan_pdm (10/12/2012)
GilaMonster (10/12/2012)
Low page density from fragmentation or deletes.p.s. The smaller index is redundant, it's unlikely to be needed.
you're right the fill factor is set to 80%.It's true the smaller...
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 12, 2012 at 12:04 pm
Viewing 15 posts - 16,141 through 16,155 (of 49,552 total)