generates an runs a select statement to convert all th olumns of a certain datatype in apirticular table to another datatype:eg all columns of type int to varchar etc the sp takes three parameters namely the table name, source data type and detination data type generates a select query ad executes it eg: exec ConvertTableTypes […]
2007-07-10 (first published: 2006-10-10)
217 reads
This script lists all the foreign keys ,the referenced and the referencing tables , along with the column information.
2007-07-09 (first published: 2006-10-04)
343 reads
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
209 reads
One line results sp_spaceused script. Also includes:DB Size= Data + DB Free Space + Transaction LogDB Data Size= Data + DB Free Space with no TLog DB Space Available= DB Free SpaceAll values are expressed in MB
2007-07-06
363 reads
I mark my SQL with a 'Todo' symbol whenever I decide something needs work, but I don't have the time to do it right away. So I wrote this usp so that I can get a quick list of stored procedures, function and views that need some extra work.It also comes in handy whenever you […]
2007-07-06 (first published: 2006-10-03)
317 reads
It is a modified version of original script I found on net. This script creates conditional Update statements too.
2007-07-05 (first published: 2006-10-03)
597 reads
Clients asked me to show a more detailed and longer text which doesn't have to be edited. So I came up with the following solution/function.This function returns a varchar time value with a description containing how many days, hours and minutes. For example 100.25 returns :'100:15( 4 Days, 4 Hours, 15 Minutes )'.I hope somebody […]
2007-07-04 (first published: 2006-10-03)
159 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
115 reads
This procedure will maintain the sysproperties table by wrapping system procedures: • sp_addextendedproperty • sp_dropextendedproperty • sp_updateextendedproperty The parameters are: • @object -- primary name of the object being to be maintained. • @column -- column or parameter […]
2007-07-04
460 reads
This script combines functionality of sp_helpindex and sp_spaceused to list all tables with individual indexes, their keys and description (sp_spaceused cannot do that) and size in MB per individual index (sp_helpindex cannot do that either). Feel free to use and modify as you see fit. Hope it can help.
2007-07-03 (first published: 2006-09-25)
2,676 reads
This post shows you how to install containerd as the container runtime for Kubernetes...
In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...
By Steve Jones
This month I want to look at a few of the things I’ve seen...
Telp/Wa 628218200203 Jl. A. Yani No.656-658, Cicaheum, Kec. Kiaracondong, Kota Bandung, Jawa Barat 40282
Telp:Wa 62817825533 Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
Comments posted to this topic are about the item SQL Server Vector Support II
With regard to SQL Server 2025's Vector support, what is an embedding?
See possible answers