Viewing 15 posts - 44,386 through 44,400 (of 49,552 total)
In 2005 and higher the system tables are no longer visible and cannot be queried.
Objects like sysobjects, sysdepends, etc are known as compatibility views and are only included 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
September 19, 2008 at 6:48 am
It's not possible. All data modifications are logged and the log entries cannot be discarded from the log until the transaction has committed and the data pages changed by 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
September 19, 2008 at 6:46 am
Yup. sysdepends is as inaccurate as ever in 2008, and deprecated to boot. It hasn't been fixed, it's been replaced
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
September 19, 2008 at 5:59 am
Can you open the services manager and try to start the SQL Service. If it gives an error, please note exactly what error it gave. Also check the SQL error...
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
September 19, 2008 at 5:56 am
Ok, the deadlock is occurring in the procedure "dbTest.tsuser.jxc_158". It looks like both processes are running the same proc.
It looks like there's an update (line 10) (UPDATE "timesheet_cache" SET...
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
September 19, 2008 at 5:52 am
harsha.bhagat1 (9/19/2008)
I anybody have any dml statments that while deleting the records it does not goes into the log or the moment 1 delete is complete it should truncate 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
September 19, 2008 at 5:39 am
Ok, so if Node 1 is active you can see S drive and it has a whole directory structure, if node 2 is active you can see S drive but...
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
September 19, 2008 at 3:48 am
Hang on, you can see S drive from both nodes?
If so, that means that different 'drives' are getting mapped as S on the two nodes. You should be able to...
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
September 19, 2008 at 3:31 am
fizzleme (8/20/2007)
We do full backups on a daily basis. That is sufficient for our needs. Truncating the log was acceptable.
Then set the DB into simple recovery mode so that 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
September 19, 2008 at 3:28 am
salmanucit (9/19/2008)
Thanks ShawCan you, or anyone else explain three questions i asked?
I did. It depends on the number of rows affected by the query and the amount of lock memory...
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
September 19, 2008 at 3:15 am
If you log onto node 2 (remote desktop), can you see drive S in windows explorer?
If you open cluster administrator, is drive S a dependency of the SQL group (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
September 19, 2008 at 3:07 am
Depends on how many rows your query affects and how much lock memory SQL has available.
If both are switched off, then you'll probably be getting table locks.
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
September 19, 2008 at 3:06 am
Is S a shared drive? Is it available to Node 2?
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
September 19, 2008 at 2:30 am
Consider using a timestamp (aka rowversion). It's got nothing to do with time despite the name. It's a binary number that changes every time the row is updated is unique...
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
September 19, 2008 at 2:09 am
They affect what logs are allowed on the indexes. SQL can take locks at various granularities depending on the amount of rows affected. It can lock at the row, page,...
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
September 19, 2008 at 2:01 am
Viewing 15 posts - 44,386 through 44,400 (of 49,552 total)