Hide SQL Server database engine instances from network discovery | Cluster instances | Availability Group Name

Hide SQL Server database engine instances from network discovery | Cluster Instances | Availability Groups nameSQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server...

Read More

SQL Server Working with NULL | Null Functions | Expressions | Comparisons | Examples

SQL Server Working with NULL | Null Functions | Expressions | Comparisons | Examples  What is a NULL value in SQL?  In SQL, a NULL value helps to identify that particular attribute/column data is not available in the table. As per BOL, "Null (or NULL) is a special marker used in Structured Query Language to indicate that...

Read More

SQL Server RAND() function | Generating random number within the specific range

SQL Server RAND() function | Generating random number in a range In this article, we will see RAND() function and also see how to generate a random number in a range using RAND() function. RAND() Function The RAND function can be used to return a random number. It will return a value between 0 and 1 such as value greater than 0 and less...

Read More

Difference between truncate table and delete table commands with examples

Difference between truncate and delete commands with examples Truncate Truncate is a DDL command. This command is used to delete all the records from the table permanently. Syntax: TRUNCATE TABLE <TABLE_NAME>; Delete ...

Read More

SSMS query editor adding line number | GOTO Line number | SQL Server Management studio

SSMS query editor adding line numbers and GOTO line numberAdding Line NumbersIn SQL Server management studio we have a provision to enable line number in the query editor. For long scripts, it can be helpful in referring to a particular...

Read More

SQL Server Heap Tables | Storage | Forwarding Pointers | Rebuild Heap

What is Heap Table? SQL Server stores a table as a heap or B-tree. If you create a table without index then it is stored as a heap. Similarly, If you create a table with a clustered index, then it is stored as a B-tree. A table can...

Read More

SQL Server accent-insensitive sorts and string comparisons | collation

SQL Server accent-insensitive sorts and string comparisons In general, SQL Server default collation is SQL_Latin1_General_CP1_CI_AS, So by default SQL Server database is always insensitive to the case(CI) and sensitive to the accent(AS) of the characters. In sometimes we need to do accent-insensitive comparisons and sorts. To do such...

Read More

SQL SERVER DBCC Commands | Database console commands | Documented List

DBCC Commands What is DBCC? DBCC stands for Database Console Commands / Database Consistency Checker.  DBCC commands are used for checking database integrity, troubleshooting issues, performance activity, and performing maintenance exercises on the database, tables, indexes, and filegroups, etc. DBCC commands help to understand...

Read More

SQL Server error logs | Intro | Configuration | Recycle | Querying

SQL SERVER ERROR LOGS Introduction In the general case, error logs are useful to troubleshoot system problems. Similarly, SQL Server Error Logs also useful in troubleshooting issues with the database server.   ...

Read More