Viewing 15 posts - 36,346 through 36,360 (of 49,562 total)
Krasavita (10/12/2009)
What is your suggestion? Thank you
GilaMonster (10/12/2009)
October 12, 2009 at 10:59 am
Bob Hovious 24601 (10/12/2009)
Adding "urgent" or "please help me" strikes me as being fairly immature, which leads me to believe that they are issues related to homework assignments.
Or a project...
October 12, 2009 at 10:59 am
First read this http://www.sqlservercentral.com/articles/65804/
Once you have read that...
Run the following and post the full output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have a backup from before running repair?...
October 12, 2009 at 10:42 am
tvanharp (10/12/2009)
October 12, 2009 at 10:42 am
You need to use dynamic SQL here.
Extract of code that needs to change
...
SET @sSQL = 'ALTER INDEX [' + @ndxnm + '] ON [' + @tblnm + '] REBUILD PARTITION...
October 12, 2009 at 10:38 am
Silverfox (10/12/2009)
Bob Hovious 24601 (10/12/2009)
Because his homework assignment is due in the morning?LOL, do you have something against software engineers 😛
Only lazy ones.
p.s. I was a software developer, I still...
October 12, 2009 at 10:33 am
Krasavita (10/12/2009)
What do you mean...
October 12, 2009 at 10:32 am
Why are you casting to varchar in the first place if you're going to match the values too another table?
This is very urgent? Why?
October 12, 2009 at 6:24 am
p.s. you are trying to attach them back to the SQL 2008 instance?
October 12, 2009 at 6:22 am
Beginer (10/11/2009)
As per my understannding the autocheckpoint should happen when the log file becomes 70% full.
No, that's for TempDB. For user databases it runs regularly to keep the expected recovery...
October 12, 2009 at 6:20 am
Operating system error 5 is Access Denied. It means that the SQL Server service account does not have full permission on the directory or the SQL Server Service account does...
October 12, 2009 at 6:18 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic801495-391-1.aspx
October 12, 2009 at 6:16 am
Are you talking about the transaction logs?
Try backing the tran logs up more often than once a day. Try switching the DB to bulk-logged recovery for the duration of the...
October 12, 2009 at 6:14 am
Eric1208 (10/11/2009)
I receive a 150GB (maybe more) flat file from customer regularly. And It will take me 2 or 3 days to import into DB.
2-3 days to import 150GB?...
October 12, 2009 at 2:16 am
imSQrLy (10/10/2009)
I am trying to help the client and do not have 230 GB available to me and nor do they.
Tell the client that if they can buy a 250GB...
October 10, 2009 at 12:52 pm
Viewing 15 posts - 36,346 through 36,360 (of 49,562 total)