Truncate data from all tables in a database
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
471 reads
This script will truncate data from all tables in a database
2005-06-06 (first published: 2005-05-13)
471 reads
This procedure will assist in granting execute rights to a database user to all the stored procedures in a database The parameters to this procedure are the databasename and the username to whom EXECUTE rights need to be given to The assumption here is that the user already has access rights to the database mentioned […]
2005-05-05 (first published: 2005-04-19)
202 reads
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Hi all, Got a strange one here that I hope someone can help with....
What's the best way to get better at T-SQL Querying? Something like Read/do the...
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...