Find Largest size Tables in a Database
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,237 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,237 reads
This Function is written to split Multivalued Parameter passed by Reporting Services 2005.
2012-07-16 (first published: 2007-08-01)
2,778 reads
2009-10-05
3,976 reads
2008-08-15
6,027 reads
This is very simple query to find Nth Maximum number from a Table. For example, using this query, we can identify the 5th, 8th or Nth highest paid employee of an organization.
2007-09-06 (first published: 2007-04-29)
954 reads
I wrote this script to compare record counts between a live database and a restored copy to test backups, I thought people might find it useful. What You need is to just copy the script and run it against your database.
2007-08-21
1,391 reads
This is a generalised Function that will return a String in Proper Case [Camel Case]. Means Afetr every space, first later will be in UPPER Case.Example:Input String: 'microSoft sql server'Output String: 'Microsoft Sql Server'
2007-05-09 (first published: 2007-04-19)
9,769 reads
This function will return you the month-end date. Input parameter may be any date of that month for which you want to calculate month-end.Example:Input: '2-20-2004' Output: '2-29-2004'Input: '2-15-2004' Output: '2-29-2004'Input: '3-20-2004' Output: '3-31-2004'Input: '3-30-2004' Output: '3-31-2004'
2007-05-08 (first published: 2007-04-19)
1,310 reads
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I've set up replication but I'm having difficulties in my testing. I've changed 3...
Comments posted to this topic are about the item The Security of Source Code
Comments posted to this topic are about the item Running SSIS in ADF