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    Next 20 >>
 

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,121 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 | 778 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,152 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 | 647 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 | 561 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,197 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,482 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,453 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,224 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,788 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 | 933 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,063 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,363 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 | 1,955 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 | 997 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,462 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,606 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,695 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 | 3,840 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,559 reads
   Items 1 to 20 of 26    Next 20 >>
 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.