Viewing 15 posts - 31,531 through 31,545 (of 49,552 total)
Sounds like someone's been playing with the system tables, and I don't mean in a good way.
Was this database upgraded from SQL 2000? If so, was there a chance 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
July 31, 2010 at 3:22 am
dhaval_dsa (7/30/2010)
Full recovery model.no i dont have log backups
Are there explicit log truncations happening (backup log ... with truncate only)? Check the backup jobs, it's likely where this would 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
July 31, 2010 at 3:18 am
What recovery model is the database in? Do you have log backups?
Just to be clear, latest diff backup on tuesday morning?
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
July 30, 2010 at 9:59 am
Same thing. Backups aren't backward compatible. You can't restore a backup taken on SQL 2008 onto SQL 2005.
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
July 30, 2010 at 9:57 am
This may be of use...
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-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
July 30, 2010 at 9:52 am
Ask for it? Or ask the DBA to set up the traces for you. That's about the only way you're going to get what you need.
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
July 30, 2010 at 8:45 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic960965-360-1.aspx
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
July 30, 2010 at 8:44 am
Neither a lock nor a connection problem is going to give you a permission denied error. The only thing that's going to give you a permission denied error is exactly...
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
July 30, 2010 at 8:38 am
How about the query I wrote for you? It's different to either of the ones listed there...
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
July 30, 2010 at 8:35 am
If they're ints, why are you using LIKE and wildcards?
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
July 30, 2010 at 7:18 am
RichardDouglas (7/30/2010)
Real world database errors on a SQL forum - you gotta love that 😀
It's not a database error. The search results aren't kept around long (for space reasons I...
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
July 30, 2010 at 7:17 am
Avoid what? Taking locks?
Taking locks is normal and expected and without taking locks SQL would be risking violating the requirements of isolation and consistency. Locks are NOT a problem.
Excessive...
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
July 30, 2010 at 7:08 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic961290-338-1.aspx
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
July 30, 2010 at 6:49 am
The exact problem is that the login you are using does not have insert permission on the table mentioned in the error message. Ask the DBA to grant the necessary...
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
July 30, 2010 at 6:44 am
Your exists query does not reference the outer table (the table being updated) at all. Sure, it mentions wce_contact, but since it joins that table in and gives it an...
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
July 30, 2010 at 6:37 am
Viewing 15 posts - 31,531 through 31,545 (of 49,552 total)