Scripts

Technical Article

Find Text in Database Objects (triggers / stored procedures)

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-03-01 (first published: )

1,237 reads

Technical Article

how to start a program like Notepad.exe in a job

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-02-28 (first published: )

297 reads

Technical Article

Find possible missing foreign key relationships

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2007-02-26 (first published: )

1,006 reads

Technical Article

MEDIAN sp for SQL 2000

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-02-23 (first published: )

689 reads

Technical Article

Switch Databases

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-02-22 (first published: )

715 reads

Technical Article

FULL SERVER DOCUMENTATION -- HTML  and revised

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 […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-02-20 (first published: )

1,468 reads

Technical Article

Idera SQLSafe SP

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'

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-02-19 (first published: )

502 reads

Blogs

Word to the wise: don’t turn on SQL vulnerability checks on a blog about SQL

By

Recently, in an attempt to thwart leechers (1990s kids will know), I added some...

Dazzling Stuff in Databricks (SQL) – Qualify

By

Once upon a time I had a series about some cool stuff in Snowflake:...

Advice I Like: Overnight Success

By

“Most overnight successes – in fact any significant successes – take at least 5...

Read the latest Blogs

Forums

Why Successful SQL Server Backups Are Not Enough

By Almighty

Comments posted to this topic are about the item Why Successful SQL Server Backups...

Adding Bits II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding Bits II

An Unlimited Token Budget

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Unlimited Token Budget

Visit the forum

Question of the Day

Adding Bits II

I have a table, dbo.bittest, where I am testing an application response. This has this structure:

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code:
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, true)
GO

See possible answers