Search results

Anyone! I've gone and downloaded a white paper from Quest Software that apparently allows me to identify locks. I've typed it out and gone over it again and again but I don't have the experience to work out what's wrong with it. As follows: *************************** declare @qs_blocking_list...

Now you see there's things you've explained here that just aren't in the instruction book! I ran the DBCC SHOWCONTIG yesterday although it was late and I had no clue what the results meant. After following your link it appears that my problem DB is fragmented, or rather three of the tables are...

Dear Hell, Have removed indexes and it's a bit better. I've found my real problem are deadlocks! This is quite a big topic so may have to wait a day or two. I will however change the timeouts as you have suggested. Many thanks indeed,

All, After upsizing quite a few tables we're now using a SQL backend with Access at the front. Works fine. Well it did. Now we're getting timeouts and I haven't a clue why. It seems to happen when a new record has been added to a table via the front end and the user clicks the 'arrow' in...

Many thanks to you both. I've decided to take the easy route however. I'm getting a guru in for a couple of hours to go through it first! Testing on the spare server went well though. Just using Paragon hard disk manager (that can cope with Raid 1) enabled me to move the data/log files around...

PDX, I've been thinking along those lines and it's probably the option I'll go for, i.e. relocating the data and log files. I guess my brain likes to have everything in it's own space - access databases on one drive, sql on another and documents etc on another. This said it's daft and if I can...

Mr Hell! Thanks very much for your reply. After stewing on it for a while the only other thing I can come up with is if somewhere deep in the registry is a setting that tells SQL which piece of physical hardware the drive is. I.e. I'm moving to another drive of the same letter but it'll be a...

Hi all, I've done a bit of searching on this one and I reckon it might be quite easy, however... Some reassurance from people who use this particular forum would be much appreciated! I've got a primary partition 'K' on a physical drive and then an extended partition with a logical drive 'J'...

Hell, I kind of got the information second hand and what the guy told me was that Msoft had said SP4 'could' have some issues with 'flaky' VB programs. However - and this will probably be good news for you - we have 3 SQL databases from outside vendors. Two have said it would make no...

All, In my continuing quest for speed (anything faster than a racing snail) I've come across some odd information. A friend with a much larger SQL DB than myself, but also an 8 processor server as oposed to my dual Xeon, has been having speed related issues as well. After a couple of weeks...

Many thanks for that info' FoFa - I could have made things a whole lot worse! Kind regards :D

All, I'm searching like a mad person and will continue BUT!!! Does anyone know anything about the options to 'Boost SQL Server priority on windows' and 'Use Windows NT Fibers'? (located in the server properties/processor tab) I've a relatively small database size wise, at just less than a...

Dimwit Apparently it takes 6 minutes. Obviously this generated extra pressure to fix the problem and I've managed it using a simple unmatched query and then a quick append. None of the IN(select rubbish. I may need to think about a change of career! OR A HOLIDAY...

All, I'm not sure how well I've managed to search on this as I'm not too sure where to start! I have an append query as follows: INSERT INTO tbl_Employee ( Company_No ) SELECT tbl_Co_Data.Company_No FROM tbl_Co_Data WHERE (((tbl_Co_Data.Company_No) Not In (select Company_No from...

Pretty good! Many thanks RG - that worked perfectly. I had a sneaking suspicion DateSerial was the way to go but was just about to start a procedure that took the number of days in the first two characters of the date from the total number of days in the month and then use DateAdd to add that...

All, This is proving tricky! I've got a date - say 21/07/2006. What I want is to be able to return 31/07/2007 - i.e. whatever the date go to the end of the month and then add one year on to that value. Adding the year on is easy (even for me) but getting to the end of the month... Some more...

That did it! Many thanks and please accept my apologies for such a late reply.

All, I promise I have searched before posting (I've even been to utteraccess). It all looks so easy but isn't quite doing what it should... I've got a form with quite a few fields on - it's bound to a table. One of the form controls is AccountNo - this is probably the most frequently used...

Sorry RM, I was replying to the previous post by Mcirvine. It turned out to be a recordset that I wanted the first record from. This was ordered by date and was giving me the second record as there were two records with the same date - the 'second' being a complete record and the first being...

Continued... Basically I had a recordset and a loop as mentioned in the first post. It turned out that when I ran the code straight thru the recordset was populating with x number of records. However if I set a breakpoint it would still populate with the same number of records, but in the...