Retrieve the name of the current database for use with bcp and other procedures that require database name. This will help increase the portability of code and less maintenance required when migrating code to new database/server.
2003-05-22
228 reads
This script will create scripts for every database object. This makes it easy to check them in to VSS.Usage : DMOScriptDatabase 'Databasename','Directoryname'
2003-05-19
629 reads
This script will create scripts for every Table. This makes it easy to check them in to VSS.Usage : DMOScriptTables 'Databasename','Directoryname'
2003-05-19
915 reads
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
171 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
808 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
172 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
472 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
458 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
450 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
529 reads
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers