Sql Server

1-20 of 52 Previous Next
Quickly Monitor Log Space in SQL Server by Hannes du Preez Language: Java, Expertise: Beginner: Learn how to easily monitor free space in your database log files.
Read All SQL Server Log Files by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn a script that allows you to read through all SQL Server Log files.
Using the STRING_AGG SQL Server 2017 Function by Hannes du Preez Language: SQL, Expertise: Beginner: Learn how to perform grouped string concatenation.
Get Current Precision Level Used by Numbers in SQL Server by Hannes du Preez Language: SQL, Expertise: Intermediate - See how to get the current precision by executing the following command.
Get Current Language of SQL Server by Hannes du Preez Language: SQL, Expertise: Beginner - Learn an easy query to get the current language in SQL Server.
Resize Your TempDB in SQL by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn how to resize the tempdb temporary database in SQL.
Using sys.dm_db_index_physical_stats by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn how to return size and fragmentation information for the data and indexes of the specified table or view in SQL Server.
Employing DBCC PINTABLE and DBCC UNPINTABLE Functions by Hannes du Preez Language: SQL, Expertise: Advanced - See how to ensure a table always stays available in SQL Server's cache. You can Pin the table and Unpin it when it is not needed anymore.
Preventing SQL from Running on a Testing SQL Server by Hannes Du Preez Language: SQL, Expertise: Intermediate - See the two ways to prevent your SQL code from running on a testing or production server.
Transfer Data with JSON in SQL Server by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn how to transfer data with JSON in SQL Server.
Compress and Decompress SQL Functions by Hannes Du Preez Language: SQL, Expertise: Intermediate - Learn how to use compress and decompress in SQL Server 2016.
SET ARITHABORT ON by Hannes du Preez Language: SQL, Expertise: Beginner - See why you should use SET ARITHABORT ON.
DateDiff_BIG Function by Hannes du Preez Language: SQL, Expertise: Beginner - See how to obtain date differences between larger date ranges in SQL Server 2016.
Using the STRING_SPLIT Function in SQL Server by Srinath M S Language: SQL, Expertise: Intermediate - Explore a way to split a string that is concatenated with a separator.
Enable SQL Server to Run Stored Procedures at Server Startup by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn the two-step process required to run stored procedures at startup.
Allow SQL Server to Silently Truncate Data by Hannes du Preez Language: SQL, Expertise: Beginner - See two ways to prevent SQL from throwing this error.
Secure Your Data in SQL 2016 with Row Level Security (RLS) by Srinath M S Language: SQL, Expertise: Advanced - Learn to implement restrictions on data row access in SQL 2016.
The sp rename SQL Stored Procedure by Hannes du Preez Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.
Identify All the Foreign Keys in Your Database by Hannes du Preez Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.
Get All Tables Referenced by at Least One View by Hannes du Preez Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.
1-20 of 52 Previous Next