October 2011 SQL Server 2012 Diagnostic Information Queries
Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...
2011-10-19
816 reads
Since Microsoft released the official name for “SQL Server Code Named Denali” last week at the PASS 2011 Summit, it...
2011-10-19
816 reads
When you sometimes look at Execution Plans, you can see that the SELECT operator has
sometimes a so-called Memory Grant assigned....
2011-10-19
5,099 reads
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
647 reads
Last week, i posted about moving tables to different file groups by recreating indexes. However, this method does not *work*...
2011-10-19
2,668 reads
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,143 reads
Today I was planning on writing a summary post of PASS Summit experience but something happened last night that caused...
2011-10-19
1,137 reads
AdvertisementsAWE has removed from SQL server 2012
AWE has removed from SQL server Denali onwards. Say bye bye to 32 bit...
2011-10-18
1,038 reads
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2011-10-18
1,228 reads
G’day,
I think it’s a safe bet that everybody here has issued a DROP DATABASE statement and knows what to expect.
Well,...
2011-10-18
4,404 reads
This is a republish due to a last minute change!!! We had to reschedule the October meeting due to unforeseen circumstances. The only change is the date of the...
2011-10-18
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers