Split String Function
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
5,223 reads
Scripts
A script to answer: Should I use SPARSE?
A brief introduction to the sparse option and script to help decide when to use it
2016-08-25 (first published: 2015-04-10)
1,754 reads
Query to find the Job Output file location at each job step
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2016-08-24 (first published: 2015-04-24)
3,345 reads
2016-08-23 (first published: 2015-05-01)
1,503 reads
Dynamic sql for convert table to flat file using bcp
I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql
2016-08-22 (first published: 2015-05-07)
2,230 reads
2016-08-19 (first published: 2015-05-13)
2,082 reads
Check Up Size Of Each Folder In a Path
If you have any requirement to check the size of each sub-folders in a path, you can use my script.
2016-08-18 (first published: 2015-05-20)
1,684 reads
Alter database owner to SA from any user details on all user databases
Alter database owner to SA from any other user details against all user databases
2016-08-17 (first published: 2015-01-13)
1,882 reads
SQL Database Migration: Lower to Higher Version
Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.
2016-08-16 (first published: 2015-01-29)
7,068 reads
Delete SQL Instance name from default backup location
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2016-08-15 (first published: 2015-03-23)
732 reads
Blogs
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Forums
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Collecting Data Is Hard
Comments posted to this topic are about the item Collecting Data Is Hard
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers