Viewing 15 posts - 16,471 through 16,485 (of 49,552 total)
runal_jagtap (9/25/2012)
I want to perform this just as a Good Prectise..
But it's not good practice. Other than the index rebuild and maybe the stats update, the rest of the steps...
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
September 25, 2012 at 5:02 am
SQL* (9/25/2012)
Q. How many pages will be fetched to Memory?
As many as are needed for the query
Q2. How does server knows that the pages are related to a...
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
September 25, 2012 at 4:36 am
No I can't, because what you're suggesting is incredibly harmful.
Read the article and blog post that I referenced. Especially read the article.
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
September 25, 2012 at 4:34 am
Absolutely. Has to be, otherwise the nonclustered indexes don't match the table (and that's called corruption). Could be more than that if there is an index on that column as...
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
September 25, 2012 at 4:18 am
Ow, ow, ow, ow...
First you want to rebuild the indexes, then you want to break the log chain (no more point in time recovery), shrink the log file, ensuring 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
September 25, 2012 at 4:15 am
The transaction log records aren't committed to data pages. The data modification is made to the data pages (in memory) and then logged into the transaction log. The only time...
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
September 25, 2012 at 2:52 am
During the execution of the insert/update/delete always. A nonclustered index is never out of date.
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
September 25, 2012 at 1:19 am
Your query returns the size of the data cache, which is one component of the buffer pool. There are a lot of other caches including the plan cache also within...
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
September 25, 2012 at 12:40 am
Any member of the sysadmin role has all permissions across the instance, is implicitly db_owner of all databases and cannot be denied anything.
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
September 25, 2012 at 12:39 am
55 sec to fetch, process and display 2.3 million rows isn't all that bad.
It's not necessarily that function that's the problem, it's the usage of that function in complex queries...
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
September 24, 2012 at 4:30 pm
Have a read through chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Unfortunately there isn't an answer that always works everywhere. I like to leave maxdop at 0, raise cost threshold (I'll test queries and see...
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
September 24, 2012 at 3:47 pm
Leeland (9/24/2012)
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
September 24, 2012 at 3:32 pm
Ignoring the stats question for a moment...
Your indexes are redundant and unnecessary. You've got a clustered index on a column, then two nonclustered indexes on the same column. 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
September 24, 2012 at 2:08 pm
Are you sure that query returned the logical name, not the physical? If so, then you need to use what it returned (ie 'SPGSAMLLog.ldf') in the shrink command.
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
September 24, 2012 at 2:01 pm
The study guide is incorrect. Not only are reader-writer deadlocks possible, they're actually very common forms of deadlocks
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
September 24, 2012 at 10:19 am
Viewing 15 posts - 16,471 through 16,485 (of 49,552 total)