by nsadmin | Apr 17, 2025 | SQL coding, SQL Performance, Videos
The YouTube video by Andy Novick demonstrates using a large language model (specifically Grok-3 in April 2025) to generate T-SQL code for a simple ETL task. Novick, a SQL Server consultant, provides a scenario involving moving data between two similar tables with...
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...