patrickkeisler.com
Everyday SQL: The Case of the NULL Query_Plan
http://www.patrickkeisler.com/2013/09/the-case-of-null-queryplan.html
Tuesday, September 3, 2013. The Case of the NULL Query Plan. As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at our disposal is the query execution plan cached in memory by SQL Server. Once we have the query plan, we can dissect what SQL Server is doing and hopefully find some places for improvement. Grabbing the actual XML query plan for a stored procedure from the cache is fairly easy using the following query. For the query plan? SELEC...
patrickkeisler.com
Everyday SQL: February 2015
http://www.patrickkeisler.com/2015_02_01_archive.html
Tuesday, February 24, 2015. SQL Cruise Caribbean 2015 Recap. Don't just take my word. Read the feedback from others. SQL Cruise Caribbean 2015: More Than A Cruise With Classes. Much More. SQL Cruise Caribbean 2015 Wrap Up. Caribbean: The Final Sql Frontier. I wish I could just re-post my article from last year. About SQL Cruise and change the dates and pictures.The event is just that good. Last year I met Andrew Kelly ( b. And Argenis Fernandez ( b. I’m guessing not too many. And Kevin Kline (. Now of co...
patrickkeisler.com
Everyday SQL: Use Trace Flag 902 to Recover from a Cumulative Update Failure
http://www.patrickkeisler.com/2015/07/use-trace-flag-902-to-recover-from.html
Tuesday, July 7, 2015. Use Trace Flag 902 to Recover from a Cumulative Update Failure. Recently, I ran into a critical error while I was helping a customer troubleshoot an issue in SQL Server. That may not sound like a big deal, but we were installing Cumulative Update 6 for SQL Server 2012 SP2 to fix our initial problem when we encountered the following error. What gives SQL Server? We just upgraded several other instances on this same server. Why does this one have to fail right now? This is definitely...
patrickkeisler.com
Everyday SQL: April 2015
http://www.patrickkeisler.com/2015_04_01_archive.html
Tuesday, April 28, 2015. Use PsPing When Working in Azure IaaS. Recently I’ve been learning more about how Azure functions and how it can help my customers. One of the best ways for me to learn about Azure was to build out my own environment using VMs, or Infrastructure as a Service (IaaS). All of that was easy; however, once the VMs were built I soon learned that Azure functions differently than an On-Premise solution. For example, when I setup a SQL Server instance on one VM, I had difficulty establish...
patrickkeisler.com
Everyday SQL: August 2014
http://www.patrickkeisler.com/2014_08_01_archive.html
Thursday, August 21, 2014. Monitor the Number of Deleted Rows in a Clustered Columnstore Index. In some of my previous posts. I have talked about how to create Columnstore indexes. Now I’d like to discuss one maintenance detail that you need to keep an eye on. I’m talking specifically about the number of “deleted rows” in a clustered Columnstore index. What SQL Server does under the covers is create a Columnstore index for the data that already resides in the table and marks it as read-only. The Delt...
patrickkeisler.com
Everyday SQL: June 2015
http://www.patrickkeisler.com/2015_06_01_archive.html
Tuesday, June 23, 2015. Exams 70-457 and 70-458 - Transition Your MCTS on SQL Server 2008 to MCSA: SQL Server 2012. This past week I finally completed the 70-458 exam to upgrade my certification to MSCA: SQL Server 2012. I never thought it would take me over a year to pass two upgrade exams, but sometimes life just gets in the way. I will say this is probably the hardest SQL Server exam I've taken so far. Subscribe to: Posts (Atom). 169; 2015 Patrick Keisler. View my complete profile.
patrickkeisler.com
Everyday SQL: March 2015
http://www.patrickkeisler.com/2015_03_01_archive.html
Tuesday, March 10, 2015. SQL Nexus Might Just Save Your Bacon. SQL Nexus does not require you to install anything on the server that you intend to monitor, but you will need to copy some data collector files to it. The collector files just run SQLDIAG and some other TSQL scripts to collect data from your monitored server. Below is a list of some of the data that is collected. Windows Performance Monitor counters. Windows event logs (system, application, and security logs). SQL Server trace events. The Da...
patrickkeisler.com
Everyday SQL: July 2015
http://www.patrickkeisler.com/2015_07_01_archive.html
Tuesday, July 21, 2015. PSSDiag Configuration Manager – A Companion for SQLNexus. Have you ever called Microsoft Customer Support for help with a SQL Server performance issue? The answer is PSSDiag Configuration Manager, or simply DiagManager. DiagManager is just a tool that you use to configure which performance items are to be collected by the SQLDIAG utility. The configuration files that come with SQLNexus (see my previous post. The first thing you’ll likely notice is a line of tabs across the t...
patrickkeisler.com
Everyday SQL: July 2014
http://www.patrickkeisler.com/2014_07_01_archive.html
Tuesday, July 29, 2014. How to Edit Read-Only Non-clustered Columnstore Data. As I've discussed in some of my previous posts. To get started, we need to create a test table and insert a few rows. Next, we'll add a non-clustered Columnstore index to the table. CREATE NONCLUSTERED COLUMNSTORE INDEX nci Table1 ON dbo.Table1(col1,col2); GO. At this point, we have effectively made this table read-only. We can read from it all day long, but if we attempt to update a value, we will get an error. SET XACT ABORT ...
SOCIAL ENGAGEMENT