Viewing 15 posts - 36,421 through 36,435 (of 49,562 total)
gupta1282 (10/8/2009)
Can somebody guide me to solve this issue.
Find the slow queries (or the ones consuming lots of CPU). Optimise the queries. This may involve rewriting the code, it may...
October 8, 2009 at 5:43 am
guptaajay1985 (10/8/2009)
one transaction log filesize 11.6 GB (before) now 1MB
recovery mode full
daily backup at 9:00 pm
So no log backups?
In full recovery you have to do log backups. If you...
October 8, 2009 at 5:31 am
dreamthebest (10/8/2009)
I think allow update work for SQL Server 2005 as well.
No it doesn't. The system tables are hidden in SQL 2005 and higher and Allow Update does not...
October 8, 2009 at 5:29 am
Can you answer my questions and explain exactly what you're trying to do and why.
Please read through this as well - Managing Transaction Logs[/url]
October 8, 2009 at 3:22 am
guptaajay1985 (10/8/2009)
Hi Gilla Actually my servers are full of logs and in near future I have to make space on drive....
That didn't answer anything.
You're talking about transaction log files (.ldf)?...
October 8, 2009 at 3:19 am
Silverfox (10/8/2009)
I take it that you have additional files in your filegroup, because that is exactly what you have done using that option
He's shrinking the log, so no filegroups. I...
October 8, 2009 at 3:16 am
ItalianOlgi (10/8/2009)
*It IS possible!*
Yes, if the company has no DBA staff to do the interview and/or the interviewer was incompetent. Question is, can you do what you claimed to be...
October 8, 2009 at 2:52 am
Why are you trying to shrink (empty) a log. What's the goal here, what's the reasoning?
October 8, 2009 at 2:21 am
October 8, 2009 at 2:19 am
dreamthebest (10/8/2009)
October 8, 2009 at 2:18 am
wodom (10/7/2009)
October 7, 2009 at 3:23 pm
Does the directory F:\SQLData exist?
Does the SQL Service account have full rights to it?
Is this a clustered SQL Server?
October 7, 2009 at 10:02 am
jflzc (10/7/2009)
jflzc (10/7/2009)
And what about the oposite, when you have high scans and look seeks like in this:
Then either the indexes aren't appropriate for the queries been run against the...
October 7, 2009 at 9:56 am
tallapaneni_rao (10/7/2009)
hi i am using sql server rtm what patches i need to apply
Apply SP3
October 7, 2009 at 9:47 am
wodom (10/7/2009)
OK, so from that aspect it looks like DROP is safer (and faster) than TRUNCATE, especially for very large tables. (And being faster makes it safer still.)
They do pretty...
October 7, 2009 at 9:46 am
Viewing 15 posts - 36,421 through 36,435 (of 49,562 total)