Viewing 15 posts - 39,496 through 39,510 (of 49,552 total)
Backup/restore is probably easiest. Put a backup on the CD with instructions on how to restore. You'll also have to explain how to relink the access tables, as they refer...
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
April 25, 2009 at 3:51 am
Does this work?
DELETE d
FROM DAO...fnb_debtor_branchmapping d INNER JOIN fnb_debtor_branchmapping_sync AS a ON d.debtor_code=a.debtor_code
AND d.branch_code=a.branch_code
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
April 25, 2009 at 3:42 am
Ken Simmons (4/24/2009)
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
April 25, 2009 at 3:29 am
GilaMonster (4/24/2009)
Please post some existing sample data from the table. The very first link that I gave you shows how to do that easily.Why can't you change the table structure?
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
April 25, 2009 at 3:27 am
WayneS (4/24/2009)
GilaMonster (4/24/2009)
Unless you had a trace active, no way to tell.or a DLL trigger?
SQL 2000
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
April 25, 2009 at 3:24 am
Unless you had a trace active, no way to tell.
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
April 24, 2009 at 3:02 pm
In that case, I would suggest that you drop that unique clustered index and create a primary key on the columns ([Lock_RecordId], [Lock_TableId]) (In that order!)
That at least will stop...
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
April 24, 2009 at 3:00 pm
Michael Valentine Jones (4/24/2009)
/********************************QUERY 2*******************************/
(@1 int,@2 tinyint,@3 nvarchar(4000))
DELETE [LOCKS]
WHERE coalesce([Lock_TableId],@1)=@2
AND [Lock_RecordId]=@3
Since column [Lock_TableId] cannot be null, there is no...
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
April 24, 2009 at 1:51 pm
Grant Fritchey (4/24/2009)
Yeah, it actually would be fun just to tear through the servers running the install software everywhere and then watch the phone light up like a Christmas tree.
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
April 24, 2009 at 1:10 pm
Jeffrey Williams (4/24/2009)
Or preferably test it before you upgrade, by setting up the DB on a test server with 2005 on.
Though, I must admit, there's little that gets adrenaline pumping...
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
April 24, 2009 at 1:08 pm
The other thing I could suggest is that you dig out some of the queries that often get blocked as well as the queries that are typically the cause 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
April 24, 2009 at 1:05 pm
usman.tanveer (4/24/2009)
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
April 24, 2009 at 1:02 pm
Is it all sorted out now?
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
April 24, 2009 at 11:48 am
No odd characters, I checked, deleted and retyped pieces by hand. There's just a new line between the two (CR LF). I was wondering if I was missing a batch...
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
April 24, 2009 at 11:44 am
Integrity checks of the system databases (master, model, msdb) are highly recommended. Corruption in those can be very hard to fix if you don't have a clean backup, and without...
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
April 24, 2009 at 11:30 am
Viewing 15 posts - 39,496 through 39,510 (of 49,552 total)