Row count of all tables
Quick and accurate method to get the row count of each table in a given database. Execution time is dependent on the number of rows in each table.-- Girish (gvphubli)
2007-07-20
1,363 reads
Scripts
Finding missing indexes in sql server 2005
the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005
2007-07-19 (first published: 2006-10-23)
5,382 reads
Delete Duplicate Records without using Cursor
This script will delete the duplicate records without using cursor
2007-07-18
667 reads
Show Line of Code Executing in Procedure
Show line of code executing - more details than dbcc inputbuffer
2007-07-18 (first published: 2006-10-16)
910 reads
2007-07-17 (first published: 2006-10-12)
462 reads
Performance problem in SQL Server 2005
I have written stored procedure which simply read each row one by one and update the some column in same table.SP is running fine in SQL Server 2000 and completed within 5 minutes (around 5 million rows)But same SP in SQL Server 2005, its taking around more than one hour (for same number of rows)Note: […]
2007-07-16
521 reads
Running Sum Query
Sometimes you need to calculate a running sum. Uses of this include adding a Month-To-Date column to a query of recent orders. I haven't seen anyone publish how to do this before (using this method).This query works by using the Row_Number() function and recursive query capability of SQL 2005.
2007-07-16
547 reads
User Tables with Size all DBs (SQL 2005 Only)
Hope this is helpful to someone. This script will create a table and a stored procedure in the master database to gather and store table info for all datbases. The sp uses a temp table to hold the results returned by sp_spaceused, then transfers the information to the permanent table DatabaseTableSizes and adds the database […]
2007-07-16 (first published: 2006-10-11)
289 reads
2007-07-13 (first published: 2006-10-11)
133 reads
Analyse tables for replication ( sql 2000 )
I have a requirement deploy transactional replication for an existing database which wasn't designed with replication in mind. I need to script/deploy based upon PK's, identity columns and timestamp columns. This query allows me to gather and save the information enabling me to generate the various scripts to replicate my database, replication through T SQL […]
2007-07-12 (first published: 2006-10-10)
796 reads
Blogs
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Forums
Alamat Bank BCA KCU MENARA BCA Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1 Lt. 28, RT.1/RW.5,...
Alamat Bank BCA KCU THAMRIN Telp:0817839777
Wa: +62 817-839-777 Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec....
cons for a dev machine in a different version of sql from our prod server
hi, im not a dba. For a couple of years our dev sql server...
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers