SQLServerCentral Best Practices Clinic: Part 2
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
2011-04-13
5,057 reads
In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.
2011-04-13
5,057 reads
If you are thinking about attending SQL Server Connections (a part of DevConnections) in Orlando this March 27-30, take advantage...
2011-03-11
638 reads
Managing disk space is an important resposibility of the DBA, and there are many ways to perform this task. In...
2011-01-05
2,088 reads
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-12-02
1,630 reads
Database maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use...
2010-11-03
1,706 reads
There is a thriving world-wide DBA community that offers many opportunties meet other DBAs, to learn from others, and to...
2010-10-05
1,313 reads
Index fragmentation can cause problems with query performance. Indexes therefore need to be occasionally rebuilt. the Rebuild Index task of the SSMS Database Maintenance Wizard drops and rebuilds every index in a database. It is effective but an off-line activity that is resource-intensive, so it not always the best way of avoiding index fragmentation in a production database. Brad explains..
2010-09-06
3,710 reads
Sometimes, its just the smallest of details that can make all the difference. For example, on my test system (see...
2010-07-27
3,072 reads
For the past several weeks, I have been running a poll on www.bradmcgehee.com, asking visitors if they thought that DBAs...
2010-03-05
2,783 reads
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-03-03
1,465 reads
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
I'm tracing activity on one database and would like to include the client_app_name in...
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
I'm only processing 50,000 records not everything from the Table where there are 250,00...
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers