Re-blog – November 18 – November 24
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
888 reads
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
888 reads
I haven’t posted for a while but thought I’d dust off the blog and get a post out. I have...
2011-11-24
4,171 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
AdvertisementsMicrosoft’s SQL Server 2012 (AKA SQL Server code-name ‘Denali’), new details have been released http://www.microsoft.com/sqlserver/en/us/future-editions/sql2012-licensing.aspx.
1. What is new in SQL...
2011-11-24
4,450 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,022 reads
Part 1 of Question 5—The question.Part 2 of Question 5—The follow up to the question.This is a continuation of my...
2011-11-23
584 reads
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,749 reads
I have a lot of customers with some impressive SQL Server workloads, those databases
are several hundred GB large, with several...
2011-11-23
7,724 reads
I am going to be one of the speakers at the Spring 2012 SQL Server Connections Conference in Las Vegas,...
2011-11-23
1,075 reads
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes. I decided I really...
2011-11-23
1 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
There is a table tblItems with below structure ( i cannot change the below...
Invoke-Sqlcmd -Query "ALTER AVAILABILITY GROUP $AAG REMOVE DATABASE $DB " -ServerInstance $Instance Invoke-Sqlcmd :...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers