Viewing 15 posts - 34,051 through 34,065 (of 49,552 total)
1) Yes
2) The indexes that run against the table
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-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
February 12, 2010 at 12:23 pm
Mike Tutor (2/12/2010)
I was thinking I could re-assign the tables in question to another uid in sysobjects,
You can. dbo (uid 1) is best. You know how or...
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
February 12, 2010 at 12:08 pm
Do you know how to fix this, or do you need a hand?
Any idea who would have gone modifying the system 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
February 12, 2010 at 8:54 am
This is typically a result of direct updates to the system tables, dropping users that own the tables. Does the following produce any results?
SELECT name FROM sysobjects WHERE uid NOT...
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
February 12, 2010 at 8:08 am
Does running a stats update now help?
From the looks of the exec plan, it will fix this completely.
There are systems that need to run stats updates on specific 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
February 12, 2010 at 7:59 am
Try updating statistics on the table.
UPDATE STATISTICS PAIRHIST WITH FULLSCAN
The index is on a ascending date column, it's a common problem on larger tables for the stats to be sufficiently...
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
February 12, 2010 at 7:36 am
mvelusamy (2/12/2010)
Table should be partition if it has more than 2M records
Is that a hard-and-fast rule? If so, can you cite your source for that best practice?
What about people not...
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
February 12, 2010 at 7:22 am
ZeeAtl (2/12/2010)
In essence, can a non-Sysadmin, non-DBO, or non-db_owner role member create objects in the system databases?
Yes. Ddl_admin is more than sufficient.
Do note that TempDB is recreated completely...
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
February 12, 2010 at 7:18 am
Hang on...
Why dynamically generated temp table names? Why dynamic SQL? Looks like you're making your life difficult for no reason.
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
February 12, 2010 at 2:09 am
No. Nothing should be created by users in the Master database. That's what user databases are for.
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
February 12, 2010 at 2:07 am
ZeeAtl (2/11/2010)[hrSome of these apps through these users connections are creating objects in tempdb (e.g. User Defined Table).
Why? In general stuff like that is a bad idea with lots 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
February 12, 2010 at 2:07 am
Edwin-376531 (2/11/2010)
I am planning to develop a database DR high level plan.How to develop the baseline?
That's a very complex question and not one that we can answer form...
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
February 12, 2010 at 2:03 am
I'm sorry, I'm not sure what you're asking.
Do you want to know the maximum number that you can have?
Maximum number of columns?
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
February 12, 2010 at 1:54 am
Analyse the queries on the table, see what indexes they use, drop any that aren't used. Drop any that are true duplicates (same columns in same order) of any other...
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
February 12, 2010 at 1:37 am
No, you cannot move snapshots in any way, so there's no way to get it to the new server. They can't be backed up, they can't be detached.
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
February 12, 2010 at 1:36 am
Viewing 15 posts - 34,051 through 34,065 (of 49,552 total)