List DB Backup Summary
Basic summary of all successful backups to date in descending date and ascending DB name order.
2002-01-03
555 reads
Scripts
Port from Oracle's TRANSLATE Function
Here is a port from the Oracle's TRANSLATE function to T-SQL. It gets three arguments: a string to be searched, a string with a set of characters to be found and replaced, and another set of characters as the replacements. Example: SELECT dbo.TRANSLATE('ABCDE', 'BD', 'CE') It will return 'ACCEE'.
2002-01-03
487 reads
Reset Identity Columns for Tables Using Them
For all tables in the current database, it will script the DBCC command to reset the identity seed to 1 for all columns using them. Very handy for data migration.
2002-01-01
858 reads
Script to Show All Failed Jobs in Specified Period
This script will allow you to create a stored procedure that will check a server for any jobs that have failed in a specified number of days. It has proven valuable to me, since I have servers with lots of jobs that run frequently; I got tired of checking the history of each job to […]
2002-01-01
4,488 reads
sp_dba_checkblocked fix for sp_NotifyBlock
Problems with error 512 more than 1 result returned due to the operator outside of the query. Found this when tested with multiple blocks going on at once. It worked fine when there was only 1 block. Depending on the type of server there can be a "whole lot of blocking going on "Replaced with […]
2002-01-01
827 reads
Table Space for Each Table
This uses sp_MStablespace from an article on this site and a cursor to run against all tables in the context of the db it is called in. One catch is it does not like table names with spaces.
2001-12-30
778 reads
Determine Who Has SA Access
This simple view will return the name, loginname,hasaccess,dbname and create date and updatedate where sysadmin or serveradmin is set to 1 from the syslogin table. If the hasaccess column is set to 1 the access is granted.
2001-12-28
1,332 reads
Monitor File Growth - Set Based sp_MSforeachdb
This is a script, similar to some you have seen in the past, that will monitor file growth on all databases for the given server. This script is not a fancy solution that has a tons of bells and whistles but, it is efficient. The script is a concantanation of the create table / populate […]
2001-12-21
3,382 reads
Cascade Delete
Having two tables Parent and Derived in ont-to-many relations we want to realize a cascade delete so that for a certain list of parent to delete all the coresponding items from Derived I use a INSTEAD OF DELETE.
2001-12-18
893 reads
Granting Access Permissions...
Usually when we recreate or rename a table we need to give the appropriate access permissions to the SQL users...this is very common in database under development environment where frequently table structure changes and we have to recreate it....we can accomplish this with Enterprise Manager but what will you do if Enterprise Manager fails to […]
2001-12-18
846 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCU VETERAN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175 @BCA KCU...
BCA KCU SALATIGA | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
BCA KCP Iskandar Muda | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Sultan Iskandar Muda No.Kav. 80/1-2, RT.2/RW.3, Kby. Lama Utara, Kec. Kebayoran Lama,...
Question of the Day
Representing Money
Which types of currency does the money data type represent?
See possible answers