Table design best practice Avoid using special characters and space in table name column name and another object name like view, procedures, etc. Avoid using binary data in the table. Should avoid files store as binary data. Always define Primary key Avoid using data types NTEXT, TEXT, and IMAGE. Avoid using the primary key on …
Dynamic data masking (DDM) limits sensitive data exposure by masking it to non-privileged users. It can be used to greatly simplify the design and coding of security in your application. Permission You do not need any special permission to create a table with a dynamic data mask, only the standard CREATE TABLE and ALTER on schema permissions. Adding, replacing, …
SQL Server 2016 introduced support for temporal tables (also known as system-versioned temporal tables) as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature …
List all SQL server table that do not have primary key
Using TSQL we can find all dependent objects from all databases including remote server linked objects (sql_expression_dependencies is ) Contains one row for each by-name dependency on a user-defined entity in the current database. This includes dependencies between natively compiled, scalar user-defined functions, and other SQL Server modules. https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-expression-dependencies-transact-sql?view=sql-server-ver15
To retrieve the SQL Server Installation date, we have to check the login “NT Authority\System” creation date which gets created at the time of SQL Server installation.
Contains one row per database in the instance of SQL Server. If a database is not ONLINE, or AUTO_CLOSE is set to ON and the database is closed, the values of some columns may be NULL. If a database is OFFLINE, the corresponding row is not visible to low-privileged users. To see the corresponding row if the database is OFFLINE, a user must …
SQL server Interview Questions for SQL DBA Q: What is the Listener? A: The Listener (sometimes referred to as the Virtual Network Name [VNN]) is similar to the network name and IP address(es) created when you install a FCI. Instead of connecting to the nodes, you would connect to the name or IP of the …
Using system objects we can find tables inflammations like no of row, indexes, key columns, etc. sys.tables: Returns a row for each user table in SQL Server. sys.partitions: Contains a row for each partition of all the tables and most types of indexes in the database. sys.dm_db_partition_stats: Returns page and row-count information for every partition …
