2010-07-19 (first published: 2009-11-16)
2,565 reads
Scripts
2010-07-15 (first published: 2010-06-16)
1,921 reads
Parsing / breaking character separated values in a table in one query
At times, we have situation to parse the character separated string in the table column.
2010-07-14 (first published: 2010-06-17)
2,224 reads
2010-07-08 (first published: 2010-06-17)
1,446 reads
Get concatenated value for a column without cursor
This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.
2010-07-06 (first published: 2010-06-14)
2,321 reads
How to output datafiles location using sp_helpdb?
This is a quick way of outputting the location of your database files/dbsize/date created on your instance.
2010-07-02 (first published: 2010-06-06)
1,378 reads
Restore All Backups
SCRIPT TO RESTORE BACKUP FOR ALL DATABASES, PLACED IN FOLDER CALLED
ORIGIN_FOLDER, WITH THE INITIALS 'DBVF' AND EXTENSION '.BAK'
2010-06-30 (first published: 2010-06-08)
2,836 reads
2010-06-29 (first published: 2010-06-09)
1,179 reads
Finding Ratio between two numbers
This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.
2010-06-23 (first published: 2010-06-01)
2,247 reads
Get default values of parameters in stored procedures
Helps to get the default value of parameters from stored procedures and functions.
2010-06-22 (first published: 2010-05-26)
3,432 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
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...
Forums
Alamat BCA KCP Dewi Sartika Tlp:08218200233
Telp/WA 62 8218200233 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta...
Alamat Kantor BCA KCP MT Haryono Tlp:08218200203
Telp/WA 62 8218200203 Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01...
Alamat BCA KCP Pondok Gede Tlp:08218200174
Telp/WA 62 8218200174 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota...
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