This query will give you the current job status of all scheduled jobs on sql server. Just by using sysJobs, and sysJobHistory table you will get to know the details about the last status of the scheduled jobs, irrespective of their status like failed, successful, or cancelled.Note: You must have admin right on MSDB database […]
2003-09-04
8,564 reads
This UDF is using in reporting where lots of durations are calculated, stored and then summed up and averaged for reports. By storing the durations as floats (which are similar to the fixed point numbers datetimes are stored as) math functions are simpler.The problem is that float-times are not human readable, and cast(@floatime as datetime) […]
2003-09-03
1,010 reads
With a dynamic sql script under 4000 chars use sp_executesql With under 8000 chars write it to a variable.For anything longer you can use this script. Use UpdateText and WriteText to write your dynamic sql to a text/ntext field in a table somewhere and then pass its location to this script.
2003-09-01
611 reads
I wrote this to allow me to send a priority list of int ids.This takes a "," seperated list of integers and puts them into a table, along with an [insorder] field that allows you to sort them.eg 2,6,3,1,7 becomesints insorder ---- --------1 72 13 56 37 9Depending on what […]
2003-09-01
89 reads
SQL2000 only.We use the attached script to schedule a SQL Agent job that sets up a Profile trace looking for long queries, and hourly imports them into a table. This way we can historically (but with some degree of real time) look to see what queries put a load on the system. We then allow […]
2003-08-23
1,484 reads
This a script to compare two parallel data streams, in my case production and QA. Two extracts were created and a mapping table was created as a look-up between old and new recordids. A final table TestResults was created to hold the results of the comparison. The comparison table names and join syntax are controlled […]
2003-08-21
163 reads
A stored procedure and two functions that given a path, a date and a file extension will do one of the following:-Delete all files of the supplied extension in that directory before a certain date.-Delete everything before the last full backup.I use this because disk space is tight and maintenance plans seem to delete old […]
2003-08-21
724 reads
This script will display the defragmentation of table(s) all indexes of selected tables and display a table/list of the DBCC SHOWCONTIG. It will aslo will report if there are tables in the list that can't be found in the current database. Run the script in the database where the tables you want to check are.Check […]
2003-08-21
797 reads
This script to designed to kill all connections for all users to a specified database. This is used in conjunction with an automated QA/Dev database restore/refresh process run as a DTS job.
2003-08-21
738 reads
This script will record all the rows in all tables of the database it's run on. Then, at each execution, it will compare the rows to what they originally were and display those that are different (inserts or deletes):
2003-08-20
305 reads
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
You kick off a distributed job expecting it to finish in minutes — but...
A while ago we suddenly had an error while trying to deploy one Fabric...
Tlp/Wa_Cs:0817-866-887 Jl. Veteran No.18-24, Krembangan Sel., Kec. Krembangan, Surabaya, Jawa Timur 60175 @BCA KCU...
Tlp/Wa_Cs:0817-866-887 Jl. Jend. Sudirman Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah...
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,...
Which types of currency does the money data type represent?
See possible answers