Viewing 15 posts - 22,981 through 22,995 (of 49,552 total)
Yup. Someone updated the system tables back on SQL 2000 and stuffed up the integrity of the system tables. There's no fix for this.
Script all objects, export all data, recreate...
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 11, 2011 at 2:31 pm
Please post any messages in the error log that relate to this DB.
Does this error persist over a SQL restart? Is the database giving any errors when accessing data?
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 11, 2011 at 10:12 am
Tim Walker. (10/11/2011)
It starts "A clustered index determines the physical order of data in a table".
This means that if...
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 11, 2011 at 9:32 am
Performace Guard (Shehap) (10/10/2011)
So if needed ,you could either :•Use just with (nolock) hints to avoid any locks or deadlocks resulted by select statements
Assuming that the process is such...
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 10, 2011 at 9:28 pm
Not sure I follow....
What you get when you pull a plan from cache is exactly the same as what you get if you ask for an estimated execution plan from...
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 10, 2011 at 2:16 pm
Nothing is wrong. The plans in cache have no run-time information (they get reused, which execution's stats will they use?'
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 10, 2011 at 10:19 am
Be nice.
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 10, 2011 at 10:13 am
Wait until the rollback finishes.
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 10, 2011 at 10:13 am
Clustered index enforces the logical order of the data, not the physical.
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 10, 2011 at 10:12 am
Ali Tailor (10/10/2011)
Does Clusterd index define the physical sort order?
No, it does not. It defines the logical sort order.
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 10, 2011 at 8:31 am
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
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 10, 2011 at 12:24 am
Because numbers don't have leading zeros. If I'm discussing a rugby match score, I'm not going to say it as 009 to 011. Talking about the number of people 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
October 9, 2011 at 11:20 pm
Performace Guard (Shehap) (10/9/2011)
As a generic commands for such cases, it should be like below:select guid
from TableB
where TableB.guid not in
(select distinct ISNULL( guid,0) from TableA)
No, not at all.
The distinct 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 9, 2011 at 11:17 pm
Sorry, no magic to make bad code good. Just have to get stuck in and fix it.
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 9, 2011 at 11:13 pm
zoushuangping (10/9/2011)
ALTER DATABASE dbname SET EMERGENCY;ALTER DATABASE dbname SET SINGLE_USER
DBCC CHECKDB (dbname, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
So you're advising that he's best off losing some unknown amount of data?
Repair is 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 9, 2011 at 9:51 am
Viewing 15 posts - 22,981 through 22,995 (of 49,552 total)