The article could be named, “How to use up all of your SQL Server available memory with a single CTE query.” Another name for the article could just be “SQL Server Bug Report” depending on how you look at it. When presenting unleashing Common Table Expressions at SQL Saturday a while back, I was asked a couple of great questions …
On my computer I run SQL Server 2012, and I use a number of test or development databases. I don’t run backups on these because I don’t care if they get destroyed since they are easy to replace. Recently I upgraded to a SSD, and now my C:\ drive which I am running SQL Server from is really fast, and …
Shrinking a Log File on a Test or Development Server Read more »
Today, the Database Health Reports had its 400th download. I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Here is a history of the Database Health Report project, http://databasehealth.com/about. My Goal: I would like to provide the Database Health Reports project for free to as many people …
Over 400 downloads of the database health reports. Read more »
The Database Health Reports application provided free of charge to the SQL Server community. Enjoy! Today I released Beta 5 of the Database Health Reports. Beta 5 is mostly bug fixes and performance improvements. There was one new feature added, the Big Clustered Indexes report. The Big Clustered Indexes report shows clustered indexes that may be larger than optimal. Give it a try with …
Database Health Reports – Beta 5 Released Today. Read more »
Throughout my career I have worked with different programming and database tools. Thinking back the tools that I enjoyed using were the tools that were easy to get the job done, and the tools that I hated using were the tools that were the most difficult to use. Being good at what I do means mastering the tools so that …
Today, the Database Health Reports had its 300th dowload. I would like to say thank you to everyone who is using the product, and an extra thank you to those who have provided me with feedback. Since I started planning the Database Health Reports a year and a half ago, until the latest download release on January 10th, 2013, it …
Over 300 Dowloads of the Database Health Reports Read more »
I am at SQL Saturday in Vancouver BC today. Here is the download of my presentation. Download zip file. Here is the presentation outline. OVER Clause Enhancements ROWS PRECEDING, FOLLOWING, UNBOUNDED RANGE PRECEDING, FOLLOWING, UNBOUNDED IIF – Immediate IF or Inline IF (from Access) CHOOSE (from Access) OFFSET / FETCH FORMAT CONCAT SEQUENCE (from Oracle) sp_describe_first_result_set New Date and Time …
Last month I posted another CTE blog entry Using a CTE to Split a String Into Rows with Line Numbers. Since then I have used it but, but realized that what I really needed was a diff tool to compare two strings similar to the command line diff tool. First we take a look the SplitWithLineNumber from the previous article. This …
Just a reminder, we are a couple weeks into beta 4 of the database health reports. If you haven’t tried it out, take a look at http://databasehealth.stevestedman.com. You can use the Database Health Reports to increase the overall health of your SQL Server from finding duplicate indexes to tracking down wait stats on your SQL server. Beta 4 has …
Last year while working on my CTE presentation for a SQL Saturday I added a blog post called “Using a CTE to Split a String Into Rows“, and since that posting I have used it many times. But as things go in development, eventually there is a need to do something more. Doing some complex string building to create files …
Using a CTE to Split a String Into Rows with Line Numbers Read more »