Viewing 15 posts - 47,446 through 47,460 (of 49,552 total)
Renaming the log file might work. It's also quite likely to leave you with a suspect database.
Suggestions.
Set the database to simple recovery mode.
Run DBCC openTran. Note the spid 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
February 5, 2008 at 11:24 pm
My take on this is that the database is responsible for the integrity of the data within it, regardless of the procedures/business layer/front end that's used.
It's often the case 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
February 5, 2008 at 11:11 pm
Can you post the code in question? It may be that it can be done without a cursor at all.
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 5, 2008 at 11:07 pm
You'd probably get more replies if you started a new thread in the correct forum (SQL 2000 -> Replication, seeing as you're using SQL 2000)
What about views do you want...
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 5, 2008 at 11:00 pm
I was actually listening to a podcast on that last night (SQLDownUnder - Interview with Kimberley Tripp, episode 15)
The index key (the main part of the index) are limited 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
February 5, 2008 at 6:21 am
Query analyser does not work like MS Access does. See the reply to your other post on this.
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 5, 2008 at 5:13 am
Don't shrink your databases. It causes index fragmentation. See my blog post on this[/url]
To rebuild your indexes on SQL 2000, look up DBCC DBReindex in Books Online.
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 5, 2008 at 5:10 am
sram24_mca (2/5/2008)
Can you please give the solution for the 2 scenarios?Thanx in advance:)
What 2 scenarios?
Can you explain where you're seeing performance problems 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
February 5, 2008 at 1:29 am
Rob Reid (2/5/2008)
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 5, 2008 at 1:28 am
By doesn't work, do you mean it gives an error, or doesn't get the rows you expect?
Try the following...
SELECT * FROM WO_Image WHERE EXISTS
(SELECT 1 FROM WO_Status
WHERE Status...
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 4, 2008 at 11:50 pm
I'm not sure what you mean by refreshing cache.
DBCC DROPCLEANBUFFERS will clear all unmodified pages out of the data cache.
DBCC FREEPROCCACHE will remove all entries from the stored...
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 4, 2008 at 11:44 pm
Not a bug.
Management studio has the same behaviour as enterprise manager did. No matter what change you make to a table, both of them drop and recreate the table,...
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 4, 2008 at 11:36 pm
Itzik's 2 books in the Inside SQL Server 2005 series are excellent. T-SQL Querying and T-SQL programming
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 4, 2008 at 11:27 pm
Could you give more details on the problem please?
Is the log reader slow in picking up transactions? Are the transactions taking time to get from the distributor to the subscriber?...
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 4, 2008 at 11:26 pm
Rob Reid (2/4/2008)
was not a good idea especially if the index is ordered...
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 4, 2008 at 11:18 pm
Viewing 15 posts - 47,446 through 47,460 (of 49,552 total)