Viewing 15 posts - 41,866 through 41,880 (of 49,562 total)
Mat Cottrell (1/9/2009)
Is there a way to get an idea on this?
How long is a piece of string?
It depends on the activity in your database, the frequency of your log...
January 9, 2009 at 8:22 am
Grant Fritchey (1/9/2009)
Oh heck yes. I've got no issues with heat. You sweat, what's the big deal?Cold hurts.
I'm actually the other way around. The heat just kills me. Day...
January 9, 2009 at 8:13 am
Please post table definitions, sample data, the query and show what you think you should be getting, and what you are. Read this to see the best way to post...
January 9, 2009 at 7:39 am
Grant Fritchey (1/9/2009)
There's about 3 inches of completely frozen snow in my yard and another 4-6 inches of the fluffy crap on the way tomorrow night.BLECH!
It's been 30+ degrees here...
January 9, 2009 at 7:31 am
jonas_granlund (1/9/2009)
January 9, 2009 at 7:27 am
jonas_granlund (1/9/2009)
Im not sure if you mean to store claims in a traditional (relational) way with each attribute for the claim in an own column?
Absolutely. SQL is a relational...
January 9, 2009 at 1:17 am
The first thing I would suggest is you try to split that up into smaller procedures. First, it'll make it more likely for the thing to get an optimal plan,...
January 9, 2009 at 1:03 am
langsoo (1/8/2009)
How should I go about optimizing to get rid of the deadlocks?
Please post the deadlock graph that traceflag 1222 produces.
January 9, 2009 at 12:38 am
foxjazz (1/8/2009)
yea, sorry I guess I meant lowest unused.if 1,2,4,5 are used, then 3 would be a result.
So you want the lowest unused value from an identity column? Not a...
January 8, 2009 at 3:17 pm
Can you describe your scenario in more detail please? Are you restoring a backup, trying to attach a database, something else?
Do you have a clean, uncorrupted backup of this database?
January 8, 2009 at 3:08 pm
Can you be more specific? Primary keys don't have to be sequential, so the concept of 'highest unused' isn't something that applies to all primary keys.
January 8, 2009 at 3:06 pm
kwoznica (1/8/2009)
WITH MOVE 'NAV5LIVE_DATA.MDF' TO 'E:\COPYDB\NAV5LIVE08_DATA.MDF',MOVE 'NAV5LIVE_1_DATA.NDF' TO 'E:\COPYDB\NAV5LIVE08_1_DATA.NDF',
MOVE 'NAV5LIVE_LOG.LDF' TO 'E:\COPYDB\NAV5LIVE08_LOG.LDF',
RECOVERY,
STATS = 5;
I believe the highlighted name should be the logical file names, not the...
January 8, 2009 at 2:57 pm
Ron Kunce (1/8/2009)
My options are to increase the .net timeout values or best to get the server upgrade made a top priority.
How about optimising the database query? That will...
January 8, 2009 at 2:49 pm
murrayd (1/8/2009)
Reorganize Indexes,
That'll do it.
If you're rebuilding all indexes on all tables than you are 'changing' every row in the database. Index rebuilds are fully logged in full...
January 8, 2009 at 2:28 pm
Ron Kunce (1/8/2009)
This leads me think that option may have deprecated some time ago as the user guide is from manuals.sybase.com/onlinebooks/. . ..
Sybase and SQL split...
January 8, 2009 at 11:56 am
Viewing 15 posts - 41,866 through 41,880 (of 49,562 total)