Latest Blog Posts

• 0 Comments 178 Views

  Check out another Erland Sommarskog's utility: ABAPERLS Now public on Erland Sommarskog's website. Enjoy! Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it!... 15 hours, 9 minutes ago by Alexander Kuznetsov to Alexander Kuznetsov

• 1 Comments 261 Views

  2009 SQL Resolutions Every year I put out resolutions, but this year is a little different.  I will post my SQL only blog resolutions here, and my personal ones here . Every year I find my ability to put out stuff is limited by my desire for sleep and fun, and this year... 01-04-2009, 21:55 by drsql to Louis Davidson

• 4 Comments 243 Views

  5 Reasons why I think MDX is the Devil First, an up front apology to Mosha - this is half in jest, half real. MDX is a powerful and useful language, but I find that its very existence has made my life very difficult when it comes to developing a solid Analysis Services solution. That's not... 01-04-2009, 12:24 by James Luetkehoelter to James Luetkehoelter Filed under: MDX

• 1 Comments 712 Views

  Reproducing deadlocks involving only one table Although the best known deadlock scenario involves two connections modifying two tables in different order, there are also other deadlock scenarios involving only one table. Besides, in some scenarios each connection needs to issue only one statement,... 01-01-2009, 18:12 by Alexander Kuznetsov to Alexander Kuznetsov

• 6 Comments 406 Views

  Deep dive to MDX presentation - slides During SQL PASS 2008 summit , I gave full day preconference seminar “ Deep Dive to MDX ”. The evaluation forms now have arrived, and the scores for the content, relevance and depth portion of the seminar are very good. The scores are not as high, however,... 12-31-2008, 14:54 by mosha to Microsoft OLAP by Mosha Pasumansky

• 5 Comments 591 Views

  A year in review, The 31 best blog posts on SQLBlog for 2008 Wow, it has been already a year since I wrote A year in review, The 21 + 1 best blog posts on SQLBlog last year Here we are with another fascinating collection of links, some of them are chosen for their content and some of them for the great comments.... 12-31-2008, 10:36 by Denis Gobo to Denis Gobo Filed under: list, SQL Server 2008

• 6 Comments 750 Views

  A Gift of Script for 2009: Who is Active, Redux Last year on December 31 I posted part of a larger monitoring script that I had been working on for a few months . I received lots of great feedback on the little script in both the comments and from people I was working with, and over the course of the... 12-31-2008, 9:49 by Adam Machanic to Adam Machanic Filed under: activity, blocking, DMVs, monitoring, Performance, Scripts, who is active

• 5 Comments 742 Views

  Did You Know? You, too, can be a Geek! Danny Gould has a new (beta) version of his Internals Viewer, that you can download from Codeplex at http://www.codeplex.com/InternalsViewer I've just started playing around with it, and the coolest thing is that it integrates right with your Management... 12-30-2008, 22:33 by Kalen Delaney to Kalen Delaney Filed under: internals

• 3 Comments 535 Views

  Performance impact: file fragmentation and SAN - Part VI A script to fragment a test file Well, this post won't cover any actual test results and is not specific to SAN. But in the spirit of full disclosure, I've attached the script I used to control the fragmentation level of the test files mentioned in this... 12-30-2008, 16:19 by Linchi Shea to Linchi Shea Filed under: Disk I/O, Perl, Scripts, Storage, Tools

• 14 Comments 469 Views

  Restoring master database Disclaimer: I'm not an infrastructure DBA.Probably everything below is just bullshit. Recently our talented IT guys destroyed disk on a virtual machine. They chose the disk carefully - it was the one with master database. How do you restore master db... 12-30-2008, 12:03 by Michael Zilberstein to Michael Zilberstein Filed under: Internals, Misc

• 1 Comments 271 Views

  A response to Linchi Shea's excellent posts on fragmentation In case this is your first visit to SQLBlog.com, Linchi Shea does very methodical analysis of the performance and behaviour of disk arrays. His most recent listings specifically explore file fragmentation and its affects on performance on storage. The... 12-29-2008, 18:08 by James Luetkehoelter to James Luetkehoelter

• 4 Comments 385 Views

  Performance impact: file fragmentation and SAN – Part V SQL Server workloads So far, the discussions in all the previous posts ( 1 , 2 , 3 , and 4 ) on the performance impact of file fragmentation on a drive presented from a high-end enterprise-class disk array are related to disk I/O workloads. Ultimately,... 12-29-2008, 16:36 by Linchi Shea to Linchi Shea Filed under: Disk I/O, Performance, SAN, Storage

• 3 Comments 404 Views

  Season's Greetings! I was catching up on my blog reading and came across a very nice post on Ward Pond's blog ; he gives us some TSQL code that produces a holiday message. It's a few days late, but it's the thought that counts, right? I did have a few problems with the code... 12-29-2008, 13:50 by Kalen Delaney to Kalen Delaney

• 8 Comments 1011 Views

  LINQ to SQL: Does it have much of a future? Kevin Kline recently posted , wondering about the directions for LINQ. When people refer to LINQ, they're often referring to "LINQ to SQL" instead. LINQ as a language enhancement is pretty cool. It provides a way to easy navigate enumerable objects. The... 12-23-2008, 17:10 by Greg Low to The Bit Bucket (Greg Low)

• 1 Comments 590 Views

  More updates for SQL Server 2005 Service Pack 3 As promised, upon return from a trip to the frozen tundra of Northern Ontario, I am posting the latest updates from last week's release of SQL Server 2005 Service Pack 3. For those who have been waiting to test the service pack until the post-SP3 cumulative... 12-23-2008, 15:13 by AaronBertrand to Aaron Bertrand Filed under: patches, security, service pack 3, SP3, SQL Server 2005 SP3

• 8 Comments 1274 Views

  LINQ: Enabling or Entangling? There’s been a lot of positive press for LINQ, such as the article about LINQ by Mike Otey at http://www.sqlmag.com/Article/ArticleID/48759/sql_server_48759.html . You can also find lots of glowing reviews and info about LINQ by Troy Magennis at http://blog.aspiring-technology.com/... 12-23-2008, 14:49 by KKline to Kevin Kline Filed under: LINQ, SQL Programming

• 15 Comments 906 Views

  Did You Know? My Book Had Too Many Pages! Some of you are aware that I am writing an (almost) weekly commentary for a SQL Server Magazine e-newsletter called SQL Server Magazine UPDATE . I was told that I could write about anything related to SQL Server, but that turned out not to be true. There... 12-22-2008, 16:58 by Kalen Delaney to Kalen Delaney

• 9 Comments 983 Views

  Performance impact: file fragmentation and SAN – Part IV Lies, damned lies, and statistics! If you have read my three previous posts ( 1 , 2 , 3 ), you may walk away with an impression that on a drive presented from a high-end enterprise class disk array, Windows file fragmentation does not have a significant... 12-22-2008, 11:34 by Linchi Shea to Linchi Shea Filed under: Best Practices, Disk I/O, Performance, SAN, Storage, Testing

• 3 Comments 388 Views

  For better precision cast decimals before calculations I frequently do calculations against decimal values. In some cases casting decimal values to float ASAP, prior to any calculations, yields better accuracy. For example, in the following script both expressions should return 12100.0: SELECT POWER ( POWER... 12-20-2008, 22:38 by Alexander Kuznetsov to Alexander Kuznetsov

• 6 Comments 827 Views

  Geek City: Splitting a page into multiple pages You know about page splits... if a table has a clustered index, any new row has to be inserted into the appropriate page, based on the clustered index key order. However, if the page where the new row belongs is full, SQL Server will split the page into... 12-20-2008, 18:45 by Kalen Delaney to Kalen Delaney