dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

Sql Server

1-20 of 754     Previous     Next
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.
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.
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.
Enumerating all SQL Servers
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how easy it is to enumerate (list) all the possible SQL servers to which you want to connect.
The sp_MSforeachdb Stored Procedure
by Hannes du Preez
Language: SQL||Expertise: Intermediate
1-20 of 754     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date