I find myself refacoring an existing database which has some inefficient code, like cursors in stored procedures and triggers ...Wanting to figure out which objects contained this "poor" code, I made myself a little script to list all the objects which contain a search string.Just change the value that @search is set to and run […]
2007-03-01 (first published: 2007-02-07)
1,235 reads
sometime I need to kill an program which does not continue to process data, and i sheduled a job to do that. After lots of times' try, I made it at last.This script add a shedule to the sheduled task list, one minutes later then the current system time. You can change it by edit […]
2007-02-28 (first published: 2004-09-19)
294 reads
Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result
2007-02-27 (first published: 2004-09-30)
252 reads
This procedure is intended for single column primary key relationships.First we will create two table functions. The first finds a list of all tables with their primary key columns. The second finds all existing foreign key relationships with their table and column names. Finally we find all tables with primary key column names that do […]
2007-02-26 (first published: 2006-11-17)
1,003 reads
I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.The limitation of not being able to pass arrays to Stored procedure or functions was the […]
2007-02-23 (first published: 2006-10-30)
689 reads
This script changes the physical, logical and file names of a database. It stores the current database until the next time the script is run, and creates a dummy database for the next update. The intent was to have minimal downtime even though the load (import, snapshot, etc.) may take a long time. Three copies […]
2007-02-22 (first published: 2006-10-17)
711 reads
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,265 reads
Revise note: 1. reformat the result into HTML page.2. added script to find sql server service account, sqlserver agent account.3. added script to find sql server authentication mode.4. added script to find sql server startup parameters5. added table of contents and hyperlinks.6. add DOS batch script to run the script on all servers. TRY […]
2007-02-20 (first published: 2006-11-10)
1,466 reads
Useful for Idera SQLSafe backups. Great software but the GUI and maintenance plan generation are a little quirky. You can easily modify this for Full, Log, Encryption, etc. - Example:EXEC usp_SS_FullBackup @dbsvrname='YOURSERVERNAME',@dbname='Northwind',@path='C:\Northwind_Full_',@description='Full Backups for Northwind'
2007-02-19 (first published: 2005-10-10)
501 reads
This function was originally contributed by another visitor and I corrected the logic to return the max position of the character if occurrence is greater than the max.I hope everyone finds it useful.
2007-02-16 (first published: 2006-09-03)
175 reads
By Steve Jones
I have a few Azure subscriptions, which are fairly small and not used that...
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...
Gg. Tengah No.88, Kranggan, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50137
Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta Barat, Daerah...
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