2007-12-18 (first published: 2007-10-18)
2,679 reads
Scripts
2007-12-12 (first published: 2007-10-12)
3,554 reads
Max Actual datalength
This script returns the defined rowlength and the actual datalength for the longest row in a table.
2007-12-10 (first published: 2007-10-01)
932 reads
2007-12-05 (first published: 2007-10-17)
684 reads
Clear all the data from tables
This script will delete all rows from the database, except system tables.
2007-11-26 (first published: 2007-09-30)
1,702 reads
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,818 reads
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)
891 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,894 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)
725 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,512 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers