Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Harsha Majety

SQLServerCentral.com profile

   Items 1 to 20 of 26    Older >>
 

Generate N numbers

Reursive CTE Script to generate n numbers  Read more...
By Harsha Majety 2013/04/17 | Source: SQLServerCentral.com | Category: recursion
Rating: |  Discuss |   Briefcase | 1,376 reads

Get List of tables with no identity columns

Get list of tables with no identity fields  Read more...
By Harsha Majety 2013/03/19 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 966 reads

Reorganize indexes for all tables in all user databases

Script to reorganize all indexes on all tables in user databases  Read more...
By Harsha Majety 2013/02/14 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,467 reads

Get Detach or Attach all user databases script

Script to generate script to detach or attach user databases   Read more...
By Harsha Majety 2013/02/15 | Source: SQLServerCentral.com | Category: attach database
Rating: |  Discuss |   Briefcase | 1,009 reads

Change database compatability level of all databases

Changes the database compatibility level of all databases to the given level.  Read more...
By Harsha Majety 2013/01/31 | Source: SQLServerCentral.com | Category: compatibility level
Rating: |  Discuss |   Briefcase | 699 reads

Script to see Table Row Counts

Script to get #rows in each table  Read more...
By Harsha Majety 2013/02/06 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,453 reads

Get space used by queries in tempdb

See what is taking up space in tempdb.  Read more...
By Harsha Majety 2012/12/03 | Source: SQLServerCentral.com | Category: tempdb
Rating: |  Discuss |   Briefcase | 1,759 reads

Get String between two delimiters

Get string between two delimiters   Read more...
By Harsha Majety 2012/07/25 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,675 reads

Start Job and Wait

Start a job in SQL and wait for it to finish.  Read more...
By Harsha Majety 2012/06/26 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 1,321 reads

Counting distinct periods of consecutive days

Count sequential days as 1 unit  Read more...
By Harsha Majety 2012/10/04 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,889 reads

Get next 1st thursday

Function to get the 1st thursday from the given day.  Read more...
By Harsha Majety 2012/01/20 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 971 reads

Ensure Table has only one row

Ensure a table has only one row.  Read more...
By Harsha Majety 2011/12/08 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,097 reads

Return CSV column in separate rows

This script can be used to return a csv column such emails in separate rows  Read more...
By Harsha Majety 2011/12/26 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,457 reads

Check status of active transactions

Script to check status of active transactions.  Read more...
By Harsha Majety 2011/08/04 | Source: SQLServerCentral.com | Category: status
Rating: |  Discuss |   Briefcase | 2,182 reads

Implementing Queuing Mechanism

Implementing a queue table in SQL server  Read more...
By Harsha Majety 2011/07/12 | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 1,055 reads

Function to get number of days in month

Function to get number of days in month  Read more...
By Harsha Majety 2011/04/27 | Source: SQLServerCentral.com | Category: date manipulation
Rating: |  Discuss |   Briefcase | 2,575 reads

Remove tab,line feed and carriage return frome text field

Remove tab,line feed and carriage return frome text field  Read more...
By Harsha Majety 2011/04/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,699 reads

Query to get tables with no clustered indexes

Query to get tables with no clustered indexes(2K5,2K8,2K8 R2)  Read more...
By Harsha Majety 2011/02/14 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,768 reads

Stored procedure to script out user permissions

Stored procedure to script out user permissions  Read more...
By Harsha Majety 2011/01/17 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 4,486 reads

Script to grant exec permission to all sps in a db

Script to grant exec permission to all sps in a db  Read more...
By Harsha Majety 2010/12/13 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,624 reads
   Items 1 to 20 of 26    Older >>