Articles by tarun_j200 (Tip/Tricks: 4)

Tip/Tricks: 4

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.94

Database Development
	Record Count of Tables in SQL Server [Tip/Trick] 26 Aug 2010 Updated: 26 Aug 2010 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 5,780 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. Also use either this one:SELECT OBJECT_NAME(SYSINDEXES.id), SYSINDEXES.rowcntFROM SYSINDEXES INNER JOIN SYSOBJECTS ON SYSINDEXES.id = SYSOBJECTS.idWHERE SYSINDEXES.indid < 2 AND SYSOBJECTS.xtype = 'U'or this one:SELECT OBJECT_NAME(id),rowcnt FROM SYSINDEXES WHERE...
	How to get the details of Open Transaction in SQL Server [Tip/Trick] 2 Sep 2010 Updated: 2 Sep 2010 Rating: 4.75/5 Votes: 3 Popularity: 2.27 Licence: CPOL Views: 62,043 Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote.
SQL Server	Find particular word or text from the entire stored procedure [Tip/Trick] 9 May 2011 Updated: 26 Jan 2012 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: CPOL Views: 7,240 Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE definition LIKE '%GetEmployee%'
	Generate Script with Data from Database [Tip/Trick] 8 Nov 2010 Updated: 13 Nov 2010 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: CPOL Views: 11,770 Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. SSMS also provides the option to generate SQL script file which contains both schema and data.Right click the database and select Generate Scripts under Tasks Menu.Click Set Scripting Options on the left hand menu (in SQL Server 2008 R2) then click Advanced button, there is an option under...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

tarun_j200

India

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.