Viewing 15 posts - 271 through 285 (of 984 total)
You say the key_txt field is a varchar(124), and yet the parent/child key thing expands by 16 characters each time... 16 isn't an integer multiple of 124...
Having said...
June 14, 2017 at 7:46 am
Hang on. You've got your test environment on the same hardware as your production environment?
June 14, 2017 at 4:23 am
June 14, 2017 at 2:37 am
June 8, 2017 at 9:59 am
June 8, 2017 at 9:32 am
Oh, man. I've just noticed this is a SQL7/2000 thread. I feel...dirty.
June 8, 2017 at 4:35 am
June 8, 2017 at 4:34 am
June 7, 2017 at 5:02 am
June 2, 2017 at 2:21 am
A couple of thoughts...
1. When you changed the Service account that the SQL Agent service uses, did you do this through the SQL Server Configuration Manager, or through...
June 1, 2017 at 6:14 am
What about those records where startdate is after enddate?
May 26, 2017 at 4:27 am
What's the storage subsystem like? Where are the database files themselves?
May 23, 2017 at 2:00 am
If you want to improve your performance on this sort of query, then there are a few options:
(1) Are you deleting all the data from the table? If...
May 18, 2017 at 3:12 am
Viewing 15 posts - 271 through 285 (of 984 total)