This script is actually based on a script by epol29. That was titled 'Script to count the number of Yes/No in the string', which I found to be an awsome script.Anyway, this script uses the same logic to deterimine if all of the characters in a field are the same. For example, 1111111, aaaaaaaa, 4444, […]
2003-05-19
156 reads
This script will list all the databases on your server (SQL2000 only) as well as their sizes and some key properties. Very useful for keeping rogue developers under control 🙂
2003-05-17
804 reads
This script forms a temporary table containing database and object names and IDS as well as object types for all databases for the server on which this scrip is executed. It is intended to serve as an interim step for additional server wide analysis.
2003-05-16
160 reads
This simple script shows how to easely grant rights to user objects (tables,stored procedure,user-defined functions) to a role (public in example), in SQL Server 2000.The script can be used to grant rights to a specific NT /sql login account by replacing [public] with the desired name.
2003-05-16
463 reads
This script obtains the fragmentation in all databases on a SQL Server 2000 database server.You must firt create a table(Fragmentacion) on a database (Sistemas) to store the information obtained.
2003-05-16
447 reads
This function will evaluate an input string and convert it to title-case format. It uses the delimchars parameter to determine what are the triggering characters to indicate capitalization of the subsequent character.I am using it in a DTS package to convert data in CAPS to Title/Proper case as I output the data to an Excel […]
2003-05-15
443 reads
This script takes 2 samples over a 10 second period to identify what spids are using most resources. It's probably not 100% accurate but it's helped me out a few times.
2003-05-15
522 reads
If you have environment where you restrict access to database objects based on user roles and if you have a lot of databases on different servers in the same domain. The following script can generate roles from a given database in a format that can be used to create roles on different servers where the […]
2003-05-14
205 reads
Mod to Find the Nth Occurence of a characterFixes when you are looking for the third character and there is only one, was setting @pos back to 0 if there was only 1 of the characters. Also provided for the @occurence to be 0.
2003-05-13
383 reads
This script identifies the blocking locks at the top of the blocking chain and kills them. Specifically, it reports what the top blocking spids are doing, kills them, waits three seconds and then reports on current blocking status. If you have a situation where single connections are causing a huge blocking chain and you want […]
2003-05-12
4,471 reads
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
WA:08218154393 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk 02, RT.3/RW.2,...
WA:08218154393 Jl. Wolter Monginsidi No.54, RT.2/RW.4, Petogogan, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Comments posted to this topic are about the item Have you done a Mid...
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers