Latest Blog Posts for rdineshkumar

• SSAS : Cube Metadata – Documentation
  on Sep 20, 2013 in SSAS T-SQL Automating SSAS cube documentation Cube Document Cube Documentation cube specification document Documenting SSAS CUBE SSAS Cube Document SSAS Cube Metadata SSAS cube metadata documentation ssas cube specifications ssas specifications Tips and tricks for SSAS cube documentation
  We all are seeing a continuous importance for documentation in any project work that we do. I can see a common factor in developers that they all hate to do documentations, we are comfortable to develop anything but its not the case when it comes...
• T-SQL : Gaps and Islands Problem – 2
  on Aug 2, 2013 in T-SQL Gaps and Island Problem in sql server sql puzzles Sql query Tsql challenge
  There are lot of ways to find the gaps in a sequential numbers, and some of them are listed below. I have posted some 3 methods to achieve the expected. The goal is to find the gaps between the sequential number. The query should return the Gap start...
• T-SQL : Gaps and Islands Problem – 2
  on Aug 2, 2013 in T-SQL Gaps and Island Problem in sql server sql puzzles Sql query Tsql challenge
  There are lot of ways to find the gaps in a sequential numbers, and some of them are listed below. I have posted some 3 methods to achieve the expected. The goal is to find the gaps between the sequential number. The query should return the Gap start...
• T-SQL : Delete duplicates in a table using Query
  on Jul 29, 2013 in T-SQL delete duplicates get unique rows in a table how to delete duplicate records in a table how to remove duplicates in a table in sql server unique rows
  Following are the queries that will delete all available duplicates in a table, please refer the query below Before deletion: Output: Alternatively, the same operation can be done using a CTE as shown below...
• T-SQL : Delete duplicates in a table using Query
  on Jul 29, 2013 in T-SQL delete duplicates get unique rows in a table how to delete duplicate records in a table how to remove duplicates in a table in sql server unique rows
  Following are the queries that will delete all available duplicates in a table, please refer the query below Before deletion: Output: Alternatively, the same operation can be done using a CTE as shown below...
• T-SQL : Query to fetch report subscription details from SSRS
  on Jun 28, 2013 in T-SQL
  In SSRS, the users who create the subscription can only have rights to modify the same. Other users will not even see the list of reports subscribed. In that scenario, to find who has created and what is report is subscribed, the following query can...
• T-SQL : Query to fetch report subscription details from SSRS
  on Jun 28, 2013 in T-SQL
  In SSRS, the users who create the subscription can only have rights to modify the same. Other users will not even see the list of reports subscribed. In that scenario, to find who has created and what is report is subscribed, the following query can...
• T-SQL : Get all folder names from SSRS Reports Manager/Server
  on May 4, 2013 in T-SQL folders how to fetch folders from ssrs how to get folders from report manager How to get the folder names from ssrs report server query query to fetch folder names from ssrs reportserver database SSRS
  We all know, we can query the report server database and get very useful information, such as reports details, directory and schedules etc. This particular thread belongs to one such category, this query will provide you all available folders from a...
• T-SQL : Get all folder names from SSRS Reports Manager/Server
  on May 4, 2013 in T-SQL folders how to fetch folders from ssrs how to get folders from report manager How to get the folder names from ssrs report server query query to fetch folder names from ssrs reportserver database SSRS
  We all know, we can query the report server database and get very useful information, such as reports details, directory and schedules etc. This particular thread belongs to one such category, this query will provide you all available folders from a...
• T-SQL : Get count of all tables in a database
  on Apr 16, 2013 in T-SQL count of all tables get count of all tables in sql server
  The following query will list the count of records in all tables of a database. These queries are based on CURSORS, Query 1: Query to get individual results, Query 2: Results stored in singe temp table, Happy Querying ;)...

{pvComments::user_name}

{pvComments::date}

Delete 

{pvComments::comment}

Post a Comment