Viewing 15 posts - 38,296 through 38,310 (of 49,552 total)
If you type in the local machine name can you connect?
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
June 20, 2009 at 3:46 pm
Jeffrey Williams (6/20/2009)
The maintenance plan plug-in uses UPDATE STATISTICS.
So if you're using the default maint plans, updating stats after rebuilding indexes will (I think) lead to a sampled...
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
June 20, 2009 at 3:45 pm
jeet_personal (6/20/2009)
But Is there any automated way or a stored procedure(scripts) to resolve this issue?
Regular scheduled log backups.
If you don't need point in time recovery (ie, if you're sure...
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
June 20, 2009 at 3:11 pm
Do you know offhand if maint plans use sp_updatestats or UPDATE STATISTICS?
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
June 20, 2009 at 3:10 pm
Can you maybe explain the problem in more detail? I'm not sure I understand what's wrong.
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
June 20, 2009 at 2:57 pm
Updating stats after an index rebuild is a poor idea. A rebuild of an index automatically updates stats on that index with full scan. If you then do a sampled...
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
June 20, 2009 at 2:16 pm
Are these interview questions or homework questions. They sound like the former.
May I suggest that you start by reading through books online? You'll probably find quite a few of...
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
June 20, 2009 at 2:06 pm
SO, if I'm understanding correctly, you have no transactional replication configured? Please can you run the following?
select * from syspublications -- run in the database in question
Is log_reuse_wait_descr still...
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
June 20, 2009 at 1:52 pm
Check that the log reader's running. Either the log reader's failed or it's slow in getting the transactions out of the log. Either way, the log cannot be truncated by...
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
June 20, 2009 at 3:46 am
JamesNZ (6/20/2009)
The value is 6 for log_reuse_wait. What does that mean?
Check the column log_reuse_wait_descr. It give the text description. log_reuse_wait just gives the numeric code.
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
June 20, 2009 at 3:37 am
What's the value of log_reuse_wait_descr in sys.databases? That'll tell you what's preventing log truncation (ie keeping the log records active)
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
June 20, 2009 at 3:27 am
SELECT BENCAT,
SUM(CASE Gender WHEN 'M' THEN 1 ELSE 0 END) AS NumMales,
SUM(CASE Gender WHEN 'F' THEN 1 ELSE 0 END) AS NumFemales
FROM [dbo].[masterenroll]
WHERE DMIS = '0005'
GROUP BY BENCAT
The distinct'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
June 19, 2009 at 1:49 pm
No. In fact, only the moderator can lock a topic and there's no mechanism to close a topic.
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
June 19, 2009 at 1:28 pm
YSLGuru (6/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
June 19, 2009 at 12:14 pm
YSLGuru (6/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
June 19, 2009 at 11:59 am
Viewing 15 posts - 38,296 through 38,310 (of 49,552 total)