Viewing 15 posts - 40,816 through 40,830 (of 49,552 total)
Please post table and index definitions as well.
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
February 23, 2009 at 9:54 am
Richard (2/23/2009)
What confuses me now is that they ever clear down, and they do.
There may be another process on another schedule that doesn't have the no_truncate, or maybe even...
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
February 23, 2009 at 9:25 am
Richard (2/23/2009)
The log file for this one database does grow huge, only when running a RE-INDEX. After I've cleared the log file down (by switching to "Simple" Recovery Model,...
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
February 23, 2009 at 8:54 am
No.
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
February 23, 2009 at 8:39 am
Ok, so let me see if I understand (ignoring details of virtual log files and statuses, which is just complicating the issue)
Your log file is constantly growing, despite running regular...
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
February 23, 2009 at 8:03 am
jakemike1 (2/23/2009)
Hi guys, I am quite new to SQL but need to be able to restore a database using the command line. Does anyone know how to accomplish this?
Look up...
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
February 23, 2009 at 7:50 am
Backing up across the network's not recommended for several reasons. Firstly the network speed may make your backups take longer. If there's a network glitch, the backup will fail and...
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
February 23, 2009 at 7:33 am
Suresh B. (2/23/2009)
If anyone has any idea now much time it takes for the databases to be available please share it.
Depends on how much work SQL has to do in...
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
February 23, 2009 at 7:31 am
Or, using the 2005/2008 system views
SELECT COUNT(*)
FROM sys.procedures
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
February 23, 2009 at 7:27 am
What traceflags do you have enabled? That doesn't look like the output from 1222. Looks more like 1204 or 1205
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
February 23, 2009 at 7:20 am
Ok, three steps back...
What's the problem, why are you worried and what issues are these 'status 2' files causing?
How many log files do you have, how many database is 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
February 23, 2009 at 7:20 am
What version of SQL do you have on your home PC? (run SELECT @@version)
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
February 23, 2009 at 7:18 am
ushasheokand (2/23/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
February 23, 2009 at 7:12 am
Job postings belong in the jobs forum please, not repeatedly posted all over the site.
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
February 23, 2009 at 12:53 am
Switch traceflag 1222 on. That will result in a deadlock graph been written to the error log every time a deadlock occurs. Post the result of that graph here.
DBCC TRACEON(1222,-1)
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
February 23, 2009 at 12:51 am
Viewing 15 posts - 40,816 through 40,830 (of 49,552 total)