<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Scripts by Harsha Majety
SQLServerCentral.com profile
Items 1 to 17 of 17
Counting distinct periods of consecutive days
Count sequential days as 1 unit
Read more...
By
Harsha Majety
2012/05/01
|
Source:
SQLServerCentral.com
Rating:
|
Discuss
|
Briefcase
|
767 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
|
860 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
|
990 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,175 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,616 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
|
907 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,325 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,505 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,571 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,142 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,435 reads
Script to get a list of publications an article is in
Script to get a list of publications an article is in
Read more...
By
Harsha Majety
2010/12/17
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
653 reads
Script to find table sizes in a database
Script to find table sizes in a database
Read more...
By
Harsha Majety
2010/12/14
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
3,003 reads
Format Phone Number function
Function to format phone numbers entered as text.
Read more...
By
Harsha Majety
2010/12/07
|
Source:
SQLServerCentral.com
|
Category:
string manipulation
Rating:
|
Discuss
|
Briefcase
|
1,650 reads
Script to indentifty big replication transactions
Script to identify big replication transactions
Read more...
By
Harsha Majety
2010/12/03
|
Source:
SQLServerCentral.com
|
Category:
replication
Rating:
|
Discuss
|
Briefcase
|
1,097 reads
Get column names in a table
Script to get a table's columns
Read more...
By
Harsha Majety
2010/12/06
|
Source:
SQLServerCentral.com
|
Category:
t-sql
Rating:
|
Discuss
|
Briefcase
|
2,207 reads
Fix all orphaned users in a database
Fix orphaned users on a restored db
Read more...
By
Harsha Majety
2010/11/24
|
Source:
SQLServerCentral.com
|
Category:
orphaned users
Rating:
|
Discuss
|
Briefcase
|
2,280 reads
Items 1 to 17 of 17
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
