SQL Server 2014: User Views – (Part-2) Author: Basit A. Farooq Editor’s Note: In this second part, you’ll learn about the SCHEMABINDING requirement for creating indexed views, which are persisted views. You’ll also learn that local partitioned views are being deprecated, though partitioned views based on federated servers are still commonly used. Creating views by using SQL […]
SQL Server
Troubleshooting problems with DBCC commands in SQL Server 2014
Troubleshooting problems with DBCC commands in SQL Server 2014 If you have problems with SQL Server 2014 DBCC commands, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 DBCC bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At […]
Applying Index, View, As Well As Full – Text Search Part 2
Applying Index, View, As Well As Full – Text Search Part – 2 What Is Clustered Index? The Clustered Index is an index which categories plus saves the information rows or tuples in the table or relation grounded on their respective key values. Thus, the information is substantially organized in the table or relation as soon as a clustered index […]
SQL Server security – (Part 7)
SQL Server security – (Part 7) Author: Basit A. Farooq In this part, you’ll first learn how SQL Server manages ownership chaining and learned how to change an object’s owner. You changed the security context for a session. Then, you’ll learn how to manage security for CLR assemblies. Finally, you’ll learn when to use SAFE, EXTERNAL_ACCESS, and UNSAFE permissions sets. […]
Troubleshooting SQL Server 2014 Bulk Copy Problems
Troubleshooting SQL Server 2014 Bulk Copy Problems If you have problems with SQL Server 2014 bulk copy, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 bulk copy bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the […]
Applying Index, View, As Well As Full – Text Search Part 1
Applying Index, View, As Well As Full – Text Search Part – 1 Introduction As a database designer it is regularly needed to upgrade the query performance in the database. SQL Server permits an individual to apply Index to decrease the run time of the quires. Additionally, an individual can control the sight of information to various employers or end […]
SQL Server security – (Part 6)
SQL Server security – (Part 6) Author: Basit A. Farooq Editor’s note: In this part, you’ll learn how to create and manage application roles. Application roles You create an application role when you want an application to have a specific level of access, regardless of who’s using the application. You can use an application role to ensure that certain functions […]
Troubleshooting SQL Server 2014 backup/restore problems
Troubleshooting SQL Server 2014 backup/restore problems If you have problems with SQL Server 2014 backup or restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]
Applying Batches, Stored Procedures and Functions Part 6
Applying Batches, Stored Procedures and Functions Part – 6 Applying Functions Alike to the stored procedure, an individual can form functions to save a group of T – SQL commands lastingly too. These functions are mentioned to as user – defined functions (UDFs) too. A User – Defined Function (UDF) is a database item which covers a group of T […]
SQL Server security – (Part 5)
SQL Server security – (Part 5) Author: Basit A. Farooq Editor’s note: In this part, you’ll learn how to manage securables at the database and schema scope. You’ll learn how to use fixed database roles and how to create custom database roles to manage permissions. Database and schema securables – Overview Each database has a number of securables that inherit […]