Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files
2015-12-15 (first published: 2015-12-07)
1,199 reads
Use this script to generate RESTORE DATABASE scripts for all .BAK backup files from backup location during Instance or Database migration.
2016-08-31 (first published: 2014-12-10)
3,546 reads
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,166 reads
The table names are in the dtproperties table, but they're hard to get at.This is a crude attempt. I tried to filter out the table names, but sometimes they have an extra garbage character as a prefix. This code assumes that all table names are made up of regular ASCII characters, and that all dtproperties tables in […]
2004-09-02
It always annoys me when I see a newsgroup thread somewhere about a problem I am having, and the conversation stops before the problem is found or the resolution is posted. I will say that I recieved much better support and ideas from this forum than the MSDN Managed discussion groups. Thanks for trying everyone!
2004-08-20
If you want to remove all the data from a table, use TRUNCATE TABLE because its damn fast. The transaction log will just contain the TRUNCATE TABLE command.If you use DELETE FROM then the transaction log contains a record for EVERY ROW in the table, a slower process.
2004-08-20
Hello to all. I have a DTS job that creates a flat text file including an amout field (money) when the column is written into the text file it has to be maked as follows:1. Amonut 25.23 or 485.562. Mask should be: 0000002523 (ten characters with leading zeros and no decimal point) or 0000048556I did masked […]
2004-06-08
1 reads
Hello AllI have been SELECT_ed the new SQL Admin. for the office.I need help finding licence info. on 6 server running Sybase SQL 4(I think), SQL6.5, 7 and 2000.I need to know the Licence number, type of Licence(CAL, Per Processor), and the amount I have. Once I have this info. I can assess the amount of new […]
2004-06-08
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers