This little utility comes in handy if you do a lot of SQL coding. Given a table name, it'll return four results: The names of the columns, the names with their datatypes, the list of columns with each one set to an identically-named variable, and a list of variables with the same names as the […]
2003-08-12
212 reads
Takes a simple string of delimited values, and returns a table type of the values stripped out. This can be easily incorporated in existing SQL statements utilising standard joins. Classic example of a UDF returning the TABLE data type.
2003-08-10
432 reads
The server goes down and you are scrambling to remember settings, file names, locations, etc. about your databases on that server. This script captures that useful information before a serious problem occurs. I run it as an OSQL (ISQL) job and send the output file to my backup folder so the infomation goes to tape […]
2003-08-07
680 reads
It is sometimes necessary to have information regarding the database objects like stored procedures and triggers for e.g. we need to get information about a stored procedure like what paramters it has and so on.The sp_help system stored procedure comes in handy.What this store procedure does is that it returns result set. The result will […]
2003-08-07
191 reads
Purpose: To create a User Defined SQL Function that can convert a string into a Proper Case string.Installation: Run the Create Function First then run the Alter Function Statement directly after.
2003-08-07
202 reads
This script will output an estimate for the space required for a given number of rows for a specified table; the estimated size is based on the data produced by the "sp_spaceused" stored procedure.The script is written as stand alone, though it also lends itself to creation as a stored procedure, and can be run […]
2003-08-07
4,798 reads
UDF Random Password GeneratorYou can not use the RAND function directly from a User Defined Function. So the UDF I wrote "fn_RandomPassword" uses the view "view_RandomPassword8" to get the random charaters.Having the random password generator is useful if you need to insert a large number of users into a table with random passwords assigned.For example […]
2003-08-07
390 reads
This VBS function will convert a string into Proper Case (i.e. This Is Proper Case) during the execution of the DTS package. Wrap the DTSSource function with the PropCase function and the result is a Proper Case transformationexampleFunction Main() DTSDestination("Field1") = PropCase(DTSSource("Col019")) Main = DTSTransformStat_OKEnd Function
2003-08-05
217 reads
This script will find all foreign key contraints in the database it is run on. Includes.Name of Foreign KeyName of table FK is onName of column FK is onName of table FK referencesName of column FK references
2003-08-01
146 reads
Purpose : This routine will dump the transaction logs based on the percentage on how full the transaction logs are based on parmeter from the logthres table […]
2003-08-01
259 reads
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Recently, our dev teams approach me for advice on improving their huge heap table...
After upgrading 2 Merge Replicated databases to SQL 2022 and re-establishing the Merge Replication...
Comments posted to this topic are about the item Why Your Index Isn't Being...
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers