21-35 of 35
Previous
Next |
Turn Off the Index Maintenance of DataTable when you Load Data
by Srinath M S
Language: .NET, Expertise: Intermediate - Learn how to turn indexing on and off when loading data.
|
Encrypting and Decrypting a Database Connection String
by Hannes du Preez
Language: .NET, Expertise: Intermediate — Learn to encrypt your connection string to a database
|
Using the SET NOCOUNT SQL Method
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how to use the NOCOUNT method to switch off the DONE_IN_PROC messages and boost the performance of queries and network traffic.
|
Built-in JSON Functions in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Did you know that SQL has some very handy built-in JSON functions?
|
Using the SQL LCASE Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
|
Get a List of all Tables In Oracle SQL
by Ben Brumm
|
Understanding OFFSET in MySQL
by M S Sridhar
Language: SQL, Level: Intermediate: - Learn an easy way to fetch the next 10 records from a given point.
|
Using DATEFROMPARTS SQL Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
|
Convert Oracle Queries into Microsoft SQL Format
by Andrew Kuprianov
Language: SQL||Expertise: Intermediate
|
Doing Upserts with the Help of MERGE
by Hannes du Preez
Language: SQL||Expertise: Intermediate
|
Get All Tables and Views Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
|
Find out When the Last Full Backup was Taken
by Hannes du Preez
SQL query that displays the last time a full backup was taken, as well as the user who took the last backup.
|
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
|
Quick Script Monitors Application-generated SQL
by Jason Bramsden
This script was written to monitor a program whose process life was only a few seconds. It runs forever and only outputs that SQL which is generated by the program as it's running.
|
Graphical Tools for MSDE
by John Joseph
MSDE's small-footprint SQL Server compatible database has now been retooled as SQL Server and it does not include graphical tools.
|
21-35 of 35
Previous
Next |