by nsadmin | Apr 28, 2015 | Past Events, SQL coding, Talks and Seminars
PDF From Seacoast SQL 2015-04-27 Improving SQL Server Performance by Writing Faster T-SQL Code SeaCoast SQL UG 2015-04-27 Download file with Examples: Writing-Faster-T-SQL-Andy_Novick-Examples-2015-04-27 Recorded Webinar September 2014: Video Stored procedures and...
by nsadmin | Aug 20, 2014 | SQL Performance
This article is a copy if a enhancement request that I have submitted on the feedback section of the Microsoft Connect web site. Here’s a link to the item: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=273443 You may have to log...
by nsadmin | Aug 20, 2014 | SQL Storage Management
Solid State Disks (SSDs) are devices that take advantage of the high speed nature of flash memory chips to provide fast persistent data storage. SSD’s come in a variety of forms that are suitable for different purposes. The most common forms of SSD are: 2.5” disk...
by nsadmin | Aug 20, 2014 | SQL Storage Management
Status = Version 1 Download the procedure script from here: sp_storage-procedure-creation-script If you can use the CLR add this script for the drive_info routine Download the bare (no procedure creation) script here: sp_storage-non-procedure-script (the bare script...
by nsadmin | Aug 13, 2014 | Problems Solved
Problem: Level 16 Errors Can’t always be handled by User Code The Books-OnLine (BOL) is wrong. It says that errors with Level 16 and below can be handled by user code. In particular by examining @@Error. Unfortunately, level 16 errors can not always be...
