This stored procedure lets you retrieve the environment variables from the server. you can pass in a partial name to get the variables that start with the partial match, or bblank to retrieve all the environment variables.
2002-12-18
517 reads
The script is design to gather informations on the growth of the databases per server (except the system ones).It is collecting in the 'databases' table of the master database for current information and in 'histodatabases' for old ones.It is possible to schedule the stored procedure.The column Serveur is only for gathering information on one server […]
2002-12-17
332 reads
Came across a great script from Ken Kaufman on copying backups using xp_cmdshell. Thought I'd contribute a script I wrote that builds on that to restore the latest production backup to a testing or development server. In this case I routinely create all my production backups to a network share and then use that source […]
2002-12-16
657 reads
This script will backup all databases that are online and have a recovery property of 'SIMPLE' AND already have a full backup. This script is set to run Monday thru Saturday at our site.
2002-12-12
222 reads
This script will do a full backup of any new database(s) on the server that does not have a backup already. This script runs Monday thru Saturday at our site.
2002-12-12
244 reads
This UDF will validate a credit card number using Luhn's formula.For example 49927398716 will return 1:print dbo.luhn('49927398716')print dbo.luhn(49927398716)11based on:Credit cards, validation and the Luhn formulabyEduardo Chaveshttp://www.webdevelopersjournal.com/articles/validation.htmlAlgorithm converted to TSQL by Joseph Gama
2002-12-12
547 reads
This script will backup all databases that are online (sql 2000). So if a new database is added you will get a backup. This is setup as a weekly job at our site (Sunday night).
2002-12-12
365 reads
ASCII table and UNICODE tableYou can easily change the font of "SQL Query Analyzer":TOOLS/OPTIONS/FONTS
2002-12-11
504 reads
This SP will create an Access database from TSQL using ADOX.Instead of Access, the Provider can be changed so that it will create *any* kind of database from DBase 3, Oracle, Excel, etc...
2002-12-11
353 reads
This stored procedure takes four parameters1)file to ftp2)server name or IP3)ftp login4)ftp passwordSP will ensure that local file exists before continuing,it will create and execute a batch file in order to push the file to the remote FTP server.--exec exampleEXEC dbo.up_FTPPushFile 'c:\temp\test.txt', 'server', 'user', 'password'
2002-12-09
4,884 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