Ms Sql Data | Yazilim Ders

Where are SQL Server Usernames and Passwords Stored in the SQL Server ?

System Catalog Views, sys.server_principals and sys.sql_logins can show the various users in the system and...

60 Ms Sql

How is Auditing Different From Change Data Capture in SQL Server?

CDC was created to help ETL scenarios by providing support for incremental data load. It uses an asynchronous...

73 Ms Sql

What is a ROLLUP Clause in SQL Server ?

ROLLUP clause is used to do aggregate operation on multiple levels in a hierarchy. If we want to sum on different...

72 Ms Sql

What are Some Advantages of Using CTE in SQL Server ?

Using CTE improves the readability and enables easy maintenance of complex queries...

82 Ms Sql

What is CTE in SQL Server ?

CTE is the abbreviation for Common Table Expression. A CTE is an expression that can be thought of as a temporary...

66 Ms Sql

What is the Difference Between a Local and a Global Temporary Table in SQL Server ?

A local temporary table exists only for the duration of a connection, or if defined inside a compound statement...

61 Ms Sql

What are the Authentication Modes in SQL Server ?

There are two authentication modes in SQL Server...

72 Ms Sql

What is SQL Server Agent ?

The SQL Server agent plays an important role in the day-to-day tasks of a database administrator (DBA). It is...

66 Ms Sql

How is Deadlock Different From a Blocking Situation in SQL Server ?

A deadlock occurs when two or more tasks permanently block each other by having a lock on a resource that...

62 Ms Sql

What is Deadlock in SQL Server ?

Deadlocking occurs when two user processes have locks on separate objects and each process is trying to acquire...

89 Ms Sql

What are the Different Recovery Models Inside SQL Server ?

There are 3 different recovery models inside SQL Server...

54 Ms Sql

What is the Difference Between CHAR and VARCHAR Datatypes in SQL Server ?

VARCHARS are variable-length strings with a specified maximum length. If a string is less than the maximum...

86 Ms Sql

What is the Difference Between Clustered and a Non-clustered Index in SQL Server ?

A clustered index is a special type of index that reorders the way records in the table are physically stored...

60 Ms Sql

Which TCP/IP Port Does the SQL Server Run On ?

SQL Server runs on port 1433...

55 Ms Sql

What is an OUTPUT Clause Inside SQL Server ?

OUTPUT clause has accesses to inserted and deleted tables (virtual tables) just like triggers. OUTPUT clause...

78 Ms Sql

What are the Events On Default Trace in SQL Server ?

The default SQL Server trace from SQL Server 2005 onwards is a background trace that runs continuously and records...

63 Ms Sql

What is Data Collector in SQL Server ?

SQL Server introduced the concept of data collector - you can obtain and save data that is gathered from several sources about...

83 Ms Sql

What are the System Data Collection Sets Predefined Inside SQL Server ?

During the installation, there are 3 System Data Collection are made available to DBAs. These to be later configured...

67 Ms Sql

What are the Limitations of Indexed Views in SQL Server ?

Some of the limitations with Indexed views are...

84 Ms Sql

What are Isolation Levels in SQL Server ?

Transactions specify an isolation level that defines the degree to which one transaction must be isolated from...

80 Ms Sql

Total Result : 127