Delete files older than n-days via T-SQL
Delete files on a fileshare leaving behind files not older than n-days.
2011-09-13 (first published: 2008-04-02)
9,942 reads
Scripts
2011-09-12 (first published: 2011-09-02)
1,489 reads
2011-09-09 (first published: 2007-11-19)
8,922 reads
Script a Database Role
Script one or all roles in a database. Includes users, obect permissions and column permissions.
2011-09-08 (first published: 2008-01-08)
5,257 reads
Generate Scripts to Compare Tables
Generate the scripts that will allow you to compare tables pass/fail.
2011-09-07 (first published: 2007-12-28)
12,465 reads
2011-09-05 (first published: 2007-01-25)
3,821 reads
2011-08-31 (first published: 2011-08-24)
2,483 reads
List all tables without LOB columns
Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml).
Useful when rebuilding indexes online.
2011-08-30 (first published: 2011-08-25)
750 reads
2011-08-24 (first published: 2011-08-12)
1,141 reads
Consultando LDAP via SSMS
A query tem o objetivo de consultar o status do usuario AD via Management Studio.
2011-08-22
396 reads
Blogs
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Tools for MySQL memory estimations and optimization?
Hi all! I’ve been using MySQLCalculator.com for memory calculations, but I’m looking for alternatives...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers