Viewing 15 posts - 39,016 through 39,030 (of 49,552 total)
What are the names of those files?
SQL wouldn't be writing to that directory unless something was configured to write there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 9:02 am
Lynn Pettis (5/19/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 8:25 am
TheSQLGuru (5/19/2009)
GilaMonster (5/19/2009)
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.I almost hope it is.
I wish it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 7:58 am
linhdkl (5/18/2009)
it's very very simple .... because I don't want anything more than a solution...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 7:54 am
Chris (5/19/2009)
Forgive me if I'm stating the obvious, but I suspect this was an interview question/homework assignment rather than a "real" problem.
I almost hope it is.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 7:50 am
Please run the following and post the full results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Take a look at this article. http://www.sqlservercentral.com/articles/65804/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:43 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/Topic719574-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:41 am
Does the SQL Server Service account have rights to the directory where the backup file is?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:39 am
OpenTran just looks for open transactions, but any connection, even if it's not running a query will prevent an exclusive DB lock.
Why are you running checkDB with the TABLOCK option?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:38 am
You don't prepare the execution plan. When you run the query, SQL generates an exec plan as part of the execution.
If you're trying to see the exec plan, there's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:37 am
What reply are you waiting for?
It sounds like you need to carry out a generic performance tuning exercise on your platform.
I would concentrate on identifying the specific queries that are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:33 am
Then make sure that you have good indexes that support the queries that are being run. If you're not sure what constitutes a good index for a query, post the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 19, 2009 at 5:29 am
dakshinamurthy (5/18/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2009 at 11:40 pm
http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2009 at 11:34 pm
It's got nothing to do with compat mode.
If you're seeing repeated cases where you run UpdateUsage, the error goes away and then later comes back, and you're on SQL 2005...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 18, 2009 at 3:48 pm
Viewing 15 posts - 39,016 through 39,030 (of 49,552 total)