Viewing 8 posts - 1 through 9 (of 9 total)
I use sys.processes to see what the blocking was about. I also get the error message lock request time out period exceeded and can see the timeout in the profiler...
May 19, 2016 at 1:23 am
Thanks for your time, thoughts and warnings 🙂
I will consider your inputs and take a discussion with my colleuges if we shall do this or not. It seems like we...
September 13, 2011 at 11:48 am
Ninja's_RGR'us (9/13/2011)
Now you're starting to make a little more sense. But I still wouldn't do it...
September 13, 2011 at 11:22 am
Ninja's_RGR'us (9/13/2011)
September 13, 2011 at 11:05 am
Ninja's_RGR'us (9/13/2011)
Avalin (9/13/2011)
Ninja's_RGR'us (9/13/2011)
All you save is dbo.archive vs dbname.dbo.archive?You can use synonyms for that. The app upgrade would be far simpler.
Not sure if I know how you mean,...
September 13, 2011 at 10:46 am
Ninja's_RGR'us (9/13/2011)
All you save is dbo.archive vs dbname.dbo.archive?You can use synonyms for that. The app upgrade would be far simpler.
Not sure if I know how you mean, but we...
September 13, 2011 at 10:33 am
Ninja's_RGR'us (9/13/2011)
How big are the dbs?Making the history process is usually a big pita. I wouldn't destroy it if it works.
Well it depends, production is usaually some GB tops,...
September 13, 2011 at 10:15 am
Okey so if I got it right is IDENTITY best to use and if we need to export data beetween databases we can use GUID's to handle it? Sounds like...
April 7, 2011 at 5:57 am
Viewing 8 posts - 1 through 9 (of 9 total)