Tables with more than 30 columns (wide tables)
This query returns list of tables which contains more than 30 columns. Other References:
July 2020
View server roles and permissions per Login
SQL Server provides server-level roles to help you manage the permissions on a server. These roles are security principals that group other principals. Server-level roles are server-wide in their permissions scope. (Roles are like groups in the Windows operating system.) server_principals: Contains a row for every server-level principal. Other Useful Query Returns a description of the built in …
Re-assign the identity of all the tables.
If the alignment of Identity matters to your business logic then you go with this script. However, keep in mind the cases when you may have the Lost Identity especially when there is often switching in the clustered /replication environments. Reference: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-identity-columns-transact-sql?view=sql-server-ver15
Find SQL Server collation
Collations in SQL Server provide sorting rules, case, and accent sensitivity properties for your data. Collations that are used with character data types, such as char and varchar, dictate the code page and corresponding characters that can be represented for that data type. Case sensitivity If A and a, B and b, etc. are treated in the same …
Tables with Identity columns
How to find table which use identity column in SQL Server using TSQL. To list all identity column To list all identity column with table name, last value, seeding value incremental value, replication stetting, etc.
Tables dependency order
There are several ways to list dependency here is one simple way to do this. sp_MSdependencies There are several undocumented systems stored procedures and extended stored procedures in SQL Server 2005 which can be of enormous use. name: name or null (all objects of type)type: type number (see below) or nullif both are null, get …
Database property
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 …
Server OS information
To find information where SQL server is installed using TSQL.
Tables with at least one LOB (max) column
Returns a table list which have maximum length of column.
SQL Server Q/A (high availability)
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 …
