File create/modified/accessed date w/out scripting
This script demonstrates a simple way to query a files create, modified or last accessed date without using a scripting and is availble in TSQL using xp_cmdshell.
2002-04-11
420 reads
Scripts
2002-04-11
358 reads
How to get last restore date and orginal DBName.
This script will output the Orignal DB Name, Destination DB Name and Last Restore date for the databases. You get a specific database just add a where clause against the appropriate field. It makes use of the restorehistory and backupset tables in the MSDB database.
2002-04-11
2,578 reads
Output all figures of the tables' usage
This store procedure outputs the tables' usage figures in a usable (I hope) format. If you create in the master database it will show the information for the database that it runs against.
2002-04-11
389 reads
Permissions Crosstab
This procedure takes the results of sp_helprotect and converts it into a crosstab -- all permissions for a user/table combination are listed in a single row
2002-04-11
454 reads
Database structure queries
Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]
2002-04-08
3,062 reads
DateDiff2 Function
A Modified Version of dateDiff. DateDiff Fucntion checks the "datepart" only of the dates. This modified function returns how many "date part" is exactly passed.
2002-04-08
1,069 reads
Get All Tables Where Column Exist With Column Info
This procedure will get all tables with column information where column exist.There is an option to search for exact or "like" name. By default it's exact name
2002-04-08
847 reads
Get week information (beginning, end) for the date
This procedure will get week information ( number,day start-day finish) for requested date. By default output dates are in 'mm/dd/yyyy' format.Format of the output dates could be changed (see 'style' info in the SQL HelpFile for 'Convert' function)
2002-04-08
988 reads
spAllTables
Script that will show a method of replacing a cursor with a temporary table. This script will loop through all the databases on a server and run sp_spaceused on all user tables.
2002-04-08
643 reads
Blogs
SQL Server instance metadata inventory with PowerShell and SMO
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
5 SQL Tricks Worth Remembering Before You Close the Laptop
Disclosure: this post may contain links to books as an affiliate link. If you...
Claude Context Window
By Arun Sirpal
Every Claude conversation has a context window. It is the total amount of text...
Forums
Celebrating 30 years of PostgreSQL, A Thank you message
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
provisioning sql server via VMware Cloud Foundation
Hello, has anyone here ever provisioned and actually used an MS SQL Server with...
No More Deadlocks
Comments posted to this topic are about the item No More Deadlocks
Question of the Day
No More Deadlocks
After detecting deadlocks in SQL Server 2025 and lowering the time threshold for detecting future issues, when does the Database Engine return to the 5s default interval?
See possible answers