Viewing 15 posts - 45,346 through 45,360 (of 49,552 total)
Then that should have only affected your local machine, not the server.
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
July 30, 2008 at 7:42 am
Mayank Khatri (7/30/2008)
By Acessing you mean r they just Selecting(DDL Statements) or modifying it too(DML statements)?
Selects are also classified DML statements. DDL are data definition statements, things like create table,...
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
July 30, 2008 at 7:35 am
The first step to solving deadlocks is finding the cause. Two ways to do that, you can set up a trace and monitor the deadlock graph events, second you can...
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
July 30, 2008 at 7:30 am
SQL defers to the OS for knowing date, time and timezone. You can't set it within SQL Server.
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
July 30, 2008 at 7:11 am
Why do you think it's related to the buffer pool?
You increase the buffer pool by increasing the amount of memory allocated to SQL server. The amount of memory specified 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
July 30, 2008 at 7:04 am
Shrinking databases is not recommended at all, not just shrinking of TempDB. Why are you shrinking your databases every day? If you're not rebuilding all indexes after the shrink you...
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
July 30, 2008 at 6:59 am
Has anyone dropped or changed an index?
Are any of the indexes fragmented?
Are the statistics up to date?
What does the execution plan of that query show?
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
July 30, 2008 at 6:44 am
A clustered index scan is a table scan. It's a full and complete read of all of the data pages in the table. You see the operation as a table...
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
July 30, 2008 at 6:40 am
Preferably an index seek. An index scan isn't that much better than a table scan.
Most of the time I prefer a nonclustered index, but there may be some cases where...
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
July 30, 2008 at 6:27 am
Dependencies are entered when dependant items are creates. So if you create a stored proc that uses a particular table, when you create the proc, the relevant entries are added...
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
July 30, 2008 at 1:36 am
You don't need any proof of experience to write or to get the cert.
How are you studying for the exam if you don't have all the relevant experience?
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
July 30, 2008 at 1:33 am
Downside is that snapshot isolation puts extra load on your TempDB
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
July 30, 2008 at 1:20 am
I generally prefer to keep two fulll backups (weekly), the diffs made against them (daily) and and of the log backups going back to the first of the fulls. That...
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
July 30, 2008 at 1:19 am
What do you mean by 'memory consumption issues'?
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
July 30, 2008 at 1:12 am
Since everyone's beaten me to the 'don't shrink', I'll just touch on other areas
You said the DBs are in full recovery. Do you have log backups running and, if so,...
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
July 30, 2008 at 1:10 am
Viewing 15 posts - 45,346 through 45,360 (of 49,552 total)