I find myself refacoring an existing database which has some inefficient code, like cursors in stored procedures and triggers ...Wanting to figure out which objects contained this "poor" code, I made myself a little script to list all the objects which contain a search string.Just change the value that @search is set to and run […]
2007-03-01 (first published: 2007-02-07)
1,236 reads
sometime I need to kill an program which does not continue to process data, and i sheduled a job to do that. After lots of times' try, I made it at last.This script add a shedule to the sheduled task list, one minutes later then the current system time. You can change it by edit […]
2007-02-28 (first published: 2004-09-19)
296 reads
Get the last date of the month for the given date. Algorithm is:1. Transform given date in “first day of the month” 2. Add a month to result 3. Subtract a day from second result
2007-02-27 (first published: 2004-09-30)
254 reads
This procedure is intended for single column primary key relationships.First we will create two table functions. The first finds a list of all tables with their primary key columns. The second finds all existing foreign key relationships with their table and column names. Finally we find all tables with primary key column names that do […]
2007-02-26 (first published: 2006-11-17)
1,003 reads
I wrote this to calculate the median on a record set. All you need to pass is the table name and column name. If you would like to filter the record set, create a view that displays the correct record.The limitation of not being able to pass arrays to Stored procedure or functions was the […]
2007-02-23 (first published: 2006-10-30)
689 reads
This script changes the physical, logical and file names of a database. It stores the current database until the next time the script is run, and creates a dummy database for the next update. The intent was to have minimal downtime even though the load (import, snapshot, etc.) may take a long time. Three copies […]
2007-02-22 (first published: 2006-10-17)
713 reads
The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.
2007-02-21 (first published: 2006-10-23)
1,267 reads
Revise note: 1. reformat the result into HTML page.2. added script to find sql server service account, sqlserver agent account.3. added script to find sql server authentication mode.4. added script to find sql server startup parameters5. added table of contents and hyperlinks.6. add DOS batch script to run the script on all servers. TRY […]
2007-02-20 (first published: 2006-11-10)
1,467 reads
Useful for Idera SQLSafe backups. Great software but the GUI and maintenance plan generation are a little quirky. You can easily modify this for Full, Log, Encryption, etc. - Example:EXEC usp_SS_FullBackup @dbsvrname='YOURSERVERNAME',@dbname='Northwind',@path='C:\Northwind_Full_',@description='Full Backups for Northwind'
2007-02-19 (first published: 2005-10-10)
502 reads
This function was originally contributed by another visitor and I corrected the logic to return the max position of the character if occurrence is greater than the max.I hope everyone finds it useful.
2007-02-16 (first published: 2006-09-03)
175 reads
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Palantir is an American software platform that brings together business data from different sources...
Comments posted to this topic are about the item Pay for Performance, which is...
Whatsapp:628218200203 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat 43111
Whatsapp:628218200233 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang, Jawa Barat...
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers