Browse by Tags
» SQL Server 2012 (RSS)
Showing page 2 of 15 (147 total posts)
Uh oh!So you're plugging along in SQL Server Management Studio (SSMS) when it suddenly goes belly up. Now you're staring at various dialog boxes telling you that SSMS crashed. Usually the first dialog box you get will ask you if you'd like to close OR the program. If you choose to close the program, you'll be presented with the opportunity ...
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #8.
KB Article: KB #2917531
Build # is 11.0.3401
Currently there are 32 public fixes (34 total); the most interesting to me are:
KB #2892741 - FIX: Query that you run against a partitioned table returns incorrect results in SQL Server 2008, SQL Server 2008 ...
I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014!
Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this ...
The SQL Server team has released CU #11 for SQL Server 2012 RTM.
KB article: http://support.microsoft.com/kb/2908007
Build # is 11.0.2424
This build has 15 fixes
NOTE: This is THE LAST CU for the RTM branch. This should still tell you two things: (1) SP2 is very likely on its way soon, and (2) if you're still on RTM, it's ...
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #7.
KB Article: KB #2894115
Build # is 11.0.3393
Currently there are 47 fixes (plus three undisclosed issues resolved); the most interesting to me are:
KB #2879373 - FIX: Threads are not scheduled evenly in SQL Server 2012 Standard Edition
KB #2894305 - ...
I had a great week last week. First at SQLRally Nordic, in Stockholm, where I presented a session on how improvements to the OVER clause can help you simplify queries in SQL Server 2012 enormously. And then I continued straight on into SQLRally Amsterdam, where I delivered a session on the performance implications of using user-defined functions ...
I whined about this recently on Facebook. After that, I did something practical: I searched for a solution.
I found a workaround at Connect:
Select "Tools", "Customize..."
- Click "Keyboard..."
- In the list window, scroll down and select "Window.ShowResultsPane"
- Under "Use ...
The SQL Server team has released CU #10 for SQL Server 2012 RTM.
KB article: http://support.microsoft.com/kb/2891666
Build # is 11.0.2420
This build has 4 fixes
For most customers, this cumulative update hardly justifies the download, never mind patching and regression testing, at least IMHO. Of the four fixes, two involve ...
Don't forget about the cool services from SQL
Sentry for Summiteers, like the free
area shuttle and the printed
area maps! Details are in a 5-part series by our CEO, Greg Gonzalez, at http://greg.blogs.sqlsentry.net/.
Are you coming to Charlotte next week for the PASS Summit? Let's connect! When ever it's open, ...
(Originally appearing at http://kevinekline.com/2013/10/09/wait-statistics-in-sql-server/).When it comes to troubleshooting in relational databases, there's no better place to start than wait statistics. In a nutshell, a wait statistic is an internal counter that tells you how long the database spent waiting for a particular ...