2001-08-22
570 reads
Scripts
2001-08-22
729 reads
hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
427 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
681 reads
2001-08-22
392 reads
2001-08-22
740 reads
Idle Spid Time
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
1,006 reads
DBCC SHOWCONTIG in all Tables
Use this script to see showcontig for all tables in the context of the database in which its called. Very handy to schedule during off peak hours prior to any re-indexing to see how bad things are and re-build certain indexes sooner than you thought for peak performance.
2001-08-20
4,203 reads
Script to Zip a Backup File
A handy dandy proc that can be used to zip up a backup file to location specified. Also called from a backup script to automate the compression of all backups using PKZip command line utility. Make sure pkzip is in the path and found by the shell prior to using this script.
2001-08-20
3,735 reads
Script to Search SQL Error Log For a String
This script(sproc)uses xp_cmdshell from sql and FINDSTR from DOS to search the current errorlog for a specific string such as kernel or failed login. Compile this in the master db and if you do not pass an input parameter a example usage will display for you. ex: sp_dba_sqlerrorlog kernel Edward J Pochinski III
2001-08-13
1,934 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCP Karawaci | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Imam Bonjol No.18, RT.001/RW.003, Karawaci, Kec. Karawaci, Kota Tangerang, Banten 15115 @BCA...
BCA KCU BANDUNG | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261 @BCA...
Converting Money
Comments posted to this topic are about the item Converting Money
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers