Disk space Notification by Email
As per Threshold value DBA will get notified about the Disk Drive usage.
2007-11-23 (first published: 2007-10-08)
1,830 reads
Scripts
Table-valued function FTParsedINT
This tabled valued function can be used to parse a comma seperated list of IDs so you can pass a parameter to use in a in clause without having to use dynamic SQL.
2007-11-22 (first published: 2007-10-04)
911 reads
CPU Performance Check.
Script will Provide us about the person who is running query and from where and why it is slowing down your CPU.
2007-11-20 (first published: 2007-08-28)
2,905 reads
create log tables and trigger modyfied
i was trying to use the script 'create log tables and trigger' by well0549 it was very helpfull but at some tables it just didnt work ..later i find out that these tables have an identity columns but they were tinyint or small int .. i didnt do much but i did add less than […]
2007-11-14 (first published: 2007-09-03)
736 reads
This SP will be create C# classes using all table
This SP will be create C# classes using all table in the specified Database
2007-11-13 (first published: 2007-09-04)
2,527 reads
Welcome To the World of ANSI compliant Occult :)
Warning: This script has no DBA value, but is useful for DBAs who have inclination towards occultƒº.Yesterday I had to decide the name of my new website. Since I wanted the name to be numerological correct. I wrote a T-SQL script for the same.For those of you who are not familiar with Numerology let me […]
2007-11-12 (first published: 2007-09-04)
629 reads
sp_displaylogin - sybase style
this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com
2007-11-09 (first published: 2007-08-31)
1,233 reads
Collation Checker
this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation
2007-11-06 (first published: 2007-07-27)
2,384 reads
Reseeding Identity values
This Script inturn generates Script to Reseed the values of identity column
2007-11-02 (first published: 2007-08-03)
749 reads
How to insert and update from remote linked server
Please read the how to use. unfortunately the orignal document i submitted was truncated 🙁
and i dont have time to remember what i said
2007-10-30 (first published: 2007-08-07)
2,653 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers