System Reserved Partition and monitoring
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,026 reads
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step...
2011-12-02
1,026 reads
Table variables and Temporary tables are used interchangeably – but they were designed for different purposes.
Temporary tables were designed for storage...
2011-12-01
1,747 reads
Lazy writing , eager writing and checkpoint use asynchronous IO in writing pages to disk. The purpose of asynchronous IO is...
2011-11-28
12,237 reads
Bulk loading with large amounts of data requires strategy. The Data Loading Performance Guide for SQL Server 2008 and SQL...
2011-11-26
3,366 reads
A sql reindex command was being blocked by two active transactions in MS DTC. Use
sys.dm_tran_active_transactions to report more detail on...
2011-11-24
2,158 reads
Developers like to have some control over the development process. An example is index building. Asking aDBA repeatedly for changes ...
2011-11-23
1,018 reads
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity...
2011-11-22
1,426 reads
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...
2011-11-15
8,062 reads
Torn Pages \ Corrupt pages – all in a days work for a DBA. But can anyone tell me how to use...
2011-11-14
23,493 reads
DBAs find it easier to manage large Database Server environments when checklists are used. This Stored procedure checklist will stimulate...
2011-11-10
2,990 reads
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
By Rob Sewell
Make it easier for your audience to engage with you by connecting your site...
By Rayis Imayev
"Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Comments posted to this topic are about the item AI Sings the Blues
I want to disable an index so that it doesn't use any resources and isn't maintained. I am planning to drop this, but don't want to do it now. The index is named LoggerNCI and was created on the dbo.Logger table, on the LogID column. What code disables this?
See possible answers