By
This article is a part 4 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS). Getting…
By
Question 281 – How to Select an Authentication Mode in SQL Server? Microsoft’s best practice recommendation is that you use Windows authentication mode whenever possible. The main benefit is…
By
Question 271 – What are the Cursor Alternatives? Set based logic SQL Server Integration Services (SSIS) or Data Transformation Services (DTS) WHILE loop COALSCE sp_MSforeachdb – Run The Same…
By
Question 261 – What are the Types of VIEW? Standard Views – Combining data from one or more tables through a standard view. Focus on specific data and simplifying…
By
Question 251 – What are the Advantages of User Defined Functions? UDF can be used in a Select, Where, or Case statement. UDF can be used in join T-SQL Statements…
By
Question 241 – What is Normalization in SQL Server? In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a…