For each user database remove all the freespace and truncate the transaction log. The script will use the system catalog to produce a list of databases. If you want to excluce a database add the excluded db name to the 'not in' list below.
2003-05-07
1,583 reads
This SP take 0 or 1 parameters. Execute without any parms and you will the sp_attach_db statements for all db's on you server. Execute with a database name and it will generate statements for stated db.
2003-05-06
1,031 reads
I used to list from sysobjects to get this information, but found the INFORMATION_SCHEMA is a lot easier.
2003-05-05
187 reads
Not long ago I was in a forum discussion when someone presented another way to get the date with time value of midnight by doing similar to thisDATEADD(dd,DATEDIFF(dd,0,@DATE),0)Which I find is much cleaner than any other option I have seen or tried myself. Seeing this I realized there are many other dates that can be […]
2003-05-02
504 reads
This procedure will give you the list of tables in the current database along with total columns in the table, no. of rows and the primary key(s) defined for the table.Mohit NayyarMCP, MCAD (.Net), MCSD, MCDBA
2003-04-30
779 reads
Last year I pulished a function ,named fnArabToEnglish,which can convert a arabic number to english ,such as turn 1234.56 to 'one thousand two hundred thirty four and cents fifty six'.Mr Rick send me a message with a bug of thefunction today,I get rid of the bug and publish the second time.I hope you like this […]
2003-04-30
89 reads
Very frequently I used to use sp_help to find column names, datatypes and length of datatypes. Sp_help outputs a lot of data which i really don't require to see. so I devised this script
2003-04-30
126 reads
2003-04-29
416 reads
This script is intended for SQL Server professionals that needs to have a quick snapshot from an environment with all relevant information about the databases. It's a compilation from multiple scripts, and works in SQL Server 2000.I think that works on 7.0 too, but may have some compilation issues.Don´t forget to see the section MANUAL […]
2003-04-28
4,777 reads
to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
2003-04-28
101 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers