| Topic 1: | How to create linked server in SQL server 2008 R2? |
| Solution: | In an application there is a 'SSRS' report which is fetching data from 'SSAS Cube'. The cube refresh is happened every morning in the week. Once cube is refreshed then latest data is available to 'SSRS' reports. For user interface, this 'SSRS' report is integrated with .Net page, contains few filters. |
| See more... | |
| Topic 2: | Convert table data in Pivot in SQL server! |
| Solution: | Hi All, I got the scenario where i need to present the row data as column header in SQL server 2008. My scenario might be bit different. |
| See more... | |
| Topic 3: | Describe NTILE function is SQL server? |
| Solution: | NTILE is one of the ranking function in sql server. It displays the rows in an ordered partition into a specified number of groups. Number of groups can be decided by passing arguments values in NTILE function. If total number of rows are not divisible by passing number of groups in argument area then first group always contains more rows than later groups. |
| See more... | |
| Topic 4: | Describe components of database engine in SQL server? |
| Solution: | The relational database server in SQL server has two main components: Relational and Storage engine. From SQL server 7.0 onwards Microsoft made an important change and used 'OLEDB' API to made communication between them. |
| See more... | |
| Topic 5: | Describe different type of keys in SQL server? |
| Solution: | There are following type of keys available In SQL server – 1. Super key 2. Candidate key 3. Primary key 4. Alternate key 5. Composite/Compound key 6. Unique key 7. Foreign key |
| See more... | |
| Topic 6: | How to delete the records from a table by using inner join and without using "in" condition? |
| Solution: | Apply delete on join query Delete TableA from TableA inner join TableB on TableA.Id=TableB.Id |
| See more... | |
| Topic 7: | How to calculate last date of the month in SQL server? |
| Solution: | Select DATEADD(DD,-1,DATEADD(MM,DATEDIFF(MM,0,GETDATE())+1,0)) |
| See more... | |
| Topic 8: | SQL Server Reporting Services: Schedule printing of the PDF file. |
| Solution: | I faced one situation in which it was recommended to implement the mechanism for scheduled printing of a PDF file which is captured through the SSRS Windows share subscription. |
| See more... | |
| Topic 9: | Scheduled process to print and delete of a PDF file using VBScript. |
| Solution: | Batch file does,'t work properly as it is unable to close the adobe reader editor window after the completion of the printing process. |
| See more... | |
| Topic 10: | SET ANSI_NULLS ON/OFF Setting in Sql Server. |
| Solution: | This option is useful for NULL values comparison. When we set it to ON it follows the ISO standard and according to it NULL values can be compared only with IS or IS NOT keywords. |
| See more... | |
0 Comments