Viewing 15 posts - 36,271 through 36,285 (of 49,562 total)
The auto-close is the cause. Why is it enabled?
When autoclose is true, SQL will shut the database down as soon as the last user disconnects. Next time someone wants the...
October 16, 2009 at 9:08 am
Then find the latest backup that's not corrupt and restore that. Look in Books Online for the procedure for restoring MSDB. It's not quite the same as for user databases.
October 16, 2009 at 9:06 am
Go and rebuild all your indexes on staging as well. Do it after the stats update.
October 16, 2009 at 9:01 am
jordon.shaw (10/16/2009)
October 16, 2009 at 9:00 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 16, 2009 at 6:16 am
Ninja's_RGR'us (10/16/2009)
1 - Do you think the exec plans could be saved into trace? I think I remember someone talking about that in PASS 2007.
Yes, look for the Showplan...
October 16, 2009 at 4:44 am
tabrez.test (10/16/2009)
is there any query to get the below result
You want the 4th highest salary to sort first, then the rest of the rows, ordered by salary ascending? That can...
October 16, 2009 at 4:24 am
tabrez.test (10/16/2009)
(order means as they are entered in database)
So you've got a column that stores the datetime that the row was inserted? Or an identity column?
If you have neither,...
October 16, 2009 at 4:11 am
What's the relationship between applicant and program? Eiher a direct relationship or one via other tables?
October 16, 2009 at 4:09 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 16, 2009 at 1:46 am
bcp is only necessary when you have irreparable corruption and no clean backups. The best way to recover from corruption (depending on the severity) is to restore a clean backup.
Take...
October 16, 2009 at 1:01 am
Does the table applicant have a column named intakeid?
p.s. do you realise you have a cross join here?
FROM applicant a,program p
That will return a Cartesian product of the rows in...
October 16, 2009 at 1:00 am
San-847017 (10/15/2009)
If you leave out either step 1 or step 3, the DB will be suspect when it's brought online.
Gila, Infact it's not coming online at all. Getting the error...
October 16, 2009 at 12:50 am
Ninja's_RGR'us (10/15/2009)
GilaMonster (10/15/2009)
Ninja's_RGR'us (10/15/2009)
We I mean slowly I mean 10 seconds to record 1 record on a "supposed" index seek, his words not mine.
Can you find/get vendor to find the...
October 16, 2009 at 12:44 am
jordon.shaw (10/15/2009)
How do I make this add 1 to ASSETINDEX for each record using the insert statement the way y'all have suggested?
Make the column identity and let SQL handle it....
October 15, 2009 at 4:17 pm
Viewing 15 posts - 36,271 through 36,285 (of 49,562 total)