Use this script to find tables, views, stored procedures that directly reference a column in the SELECT statement or in a join. This script will also return stored procedure and view names that have SELECT * in them when the specified column exists in the table referenced by that SELECT statement.
2002-03-15
1,090 reads
SP_WASTED_SPACE will run through each column in your database and print a report of all the character columns. It will then print a report with :* The maximum length that a column is storing* The average length of data stored in each column* The amount of wasted space in each column* Hints on how to […]
2002-03-14
1,161 reads
This procedure will display the rows, reserved, data, index and unused space used in KB for all user tables in the database. The idea is to call sp_spaceused repeatedly. Limitation: certain versions of sp_spaceused will truncate the table name to 20 characters.Speed will depend on current activity level and locking in the database. It will […]
2002-03-14
425 reads
Drop all indexes, constraints and statistics for given table.
2002-03-14
1,222 reads
Generates a XML document containing metadata on a specified table. Table name is provided to the procedure.
2002-03-13
605 reads
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
609 reads
This short and simple script is a very fast way to count the rows in all your indexed tables. I ran it against a 2-gigabyte database containing large tables (some with over a million rows!), and it returned results in under a second.
2002-03-12
3,019 reads
Given a table name as the parameter, all the indexes on the table can be dropped. This script can be useful if you want to drop indexes on a table inside another procedure
2002-03-12
13,960 reads
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
601 reads
Returns the Owner, Table Name, Row count for all user tables in the current database.
2002-03-11
654 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
Comments posted to this topic are about the item Adding Bits I
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] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers