vinay.inkeysolutions.com
...juggling with .net & sql: August 2013
http://vinay.inkeysolutions.com/2013_08_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Wednesday, 7 August 2013. SSRS – Download all RDL files from Report Server in one go. Uses SQL Server to store it’s details as a backend and the Catalog. Table is used to store the report file in binary form. The below script simply pulls the report definition from the Catalog table and uses BCP. Utility to export the same at a pre-defined path as a .rdl. The ReportManager 's Re...
vinay.inkeysolutions.com
...juggling with .net & sql: July 2011
http://vinay.inkeysolutions.com/2011_07_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Friday, 29 July 2011. Lookup functions in SSRS 2008 R2 - III. This is the final post to discuss the last Lookup function Multilookup(). The other two – Lookup(). Have already been discussed in my previous posts. Multilookup(source expression, destination expression, result expression, dataset). Source expression –. Destination expression –. Result expression –. A VariantArray, or.
vinay.inkeysolutions.com
...juggling with .net & sql: SQL Server – Generate Calendar using TSQL
http://vinay.inkeysolutions.com/2013/04/sql-server-generate-calendar-using-tsql_8.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Monday, 8 April 2013. SQL Server – Generate Calendar using TSQL. Recently, I was asked to develop a SSRS. Based report for the Event Management module in MS Dynamics CRM 2011. The idea was to show a Calendar. For the selected month and each cell of the calendar should display the scheduled events of that day. Below is the TSQL which I came up with to generate the Calendar -.
vinay.inkeysolutions.com
...juggling with .net & sql: SSRS – Download all RDL files from Report Server in one go.
http://vinay.inkeysolutions.com/2013/08/ssrs-download-all-rdl-files-from-report.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Wednesday, 7 August 2013. SSRS – Download all RDL files from Report Server in one go. Uses SQL Server to store it’s details as a backend and the Catalog. Table is used to store the report file in binary form. The below script simply pulls the report definition from the Catalog table and uses BCP. Utility to export the same at a pre-defined path as a .rdl. The ReportManager 's Re...
vinay.inkeysolutions.com
...juggling with .net & sql: December 2011
http://vinay.inkeysolutions.com/2011_12_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Friday, 30 December 2011. Wishing all my followers a very happy and prosperous new year! Links to this post. Monday, 26 December 2011. Dynamic Sorting in SSRS. Many times while developing any report we come across a situation where we need to SORT. Define 3 Report parameters. Say - @SortCol1Name,@SortCol2Name and @SortCol3Name of STRING type. OR any preferred order. With this tr...
vinay.inkeysolutions.com
...juggling with .net & sql: September 2011
http://vinay.inkeysolutions.com/2011_09_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Friday, 30 September 2011. How to find a string value in all the string columns of a table/view in SQL Server? I am sure many times we all might have come across situations where we need to search/find a string value in all the string columns of a given table/view in SQL Server and return the matching rows from that table. DBName - Replace with. IS NULLABLE = 'YES'. MS SQL Serve...
vinay.inkeysolutions.com
...juggling with .net & sql: February 2012
http://vinay.inkeysolutions.com/2012_02_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Friday, 10 February 2012. How to hide Placeholder in SSRS 2008? For the ones who are working with SSRS, Placeholder. Let’s first try to understand the problem I am talking about. Please have a look at Diag: 1. But the main issue here is the BLANK SPACE CREATED. Refer Diag: 1 . There is not direct property available to Hide the Placeholder. The expected output is -. This was the ...
vinay.inkeysolutions.com
...juggling with .net & sql: January 2012
http://vinay.inkeysolutions.com/2012_01_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Thursday, 12 January 2012. Fragmented Index – Rebuild or Reorganize? In past, many times I have written on. Them You can find some related articles at -. T-SQL to find Fragmented Indexes. What is the best value for Fill Factor in SQL Server? Rebuild all the indexes of a table and Indexed views in a Database. Rebuild all the Indexes of a SQL Database in one go. When to use what?
vinay.inkeysolutions.com
...juggling with .net & sql: August 2011
http://vinay.inkeysolutions.com/2011_08_01_archive.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Monday, 22 August 2011. T-SQL to find Fragmented Indexes. Is one of the reason for low performing queries resulting in a poor application performance. Today, I will present a simple script which will help in identifying the level of fragmentation in a Database. Which we want to. 70 - A acceptable value. PSOBJECT ID ObjectID,. Tname,V.name) ObjectName,. PSindex id = I.index id.
vinay.inkeysolutions.com
...juggling with .net & sql: SQL Server – Generating PERMUTATIONS using T-Sql
http://vinay.inkeysolutions.com/2013/03/sql-server-generating-permutations.html
Juggling with .net and sql. Net and SQL Samples, programming tips and tricks, performance tips, guidelines, and best practices. Monday, 11 March 2013. SQL Server – Generating PERMUTATIONS using T-Sql. Were you ever asked to generate string Permutations. I was recently asked to do so, and the logic which I could manage to come up at that point is shared in the below script. Mention the text which is. 20) - Make sure the size. String length (@ Value. Persist the Separated characters. Labels: MS SQL Server.