Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Database user and programming tips

Database User and Programming Tips

Setting Variables in Calling T-SQL Code While Using sp_executesql 05/04/2017

In this tip, Greg Larsen shows you how to set variables in your calling T-SQL code when using sp_execute sql.

Where is my SQL Server Configuration Manager? 05/04/2017

If you are running Windows 8 and above, you might have found out that you can’t find SQL Server Configuration Manager in the list of installed applications. Read on to learn how to locate it.

Displaying Backup or Restore Progress 04/03/2017

Have you ever started a database backup or a restore process that runs a long time then wanted to know when it will complete? Knowing when a database backup or restore operation will complete provides you valuable information, especially when you need to perform follow-on tasks that are waiting for the backup or restore process to complete.

How to Move a Table to a Different File Group 04/03/2017

There may be a time when you want to move a table from one file group to another. It's easy if it contains a clustered index. Read on to learn more.

Clean Your Buffers for Accurate Performance Testing 03/02/2017

In order to do accurate performance testing between multiple runs of a SQL Server command or scripts you need to remember to clean the buffer, procedure and system cache between each test run.

Who Changed My Database Schema? 03/02/2017

Have you ever wanted to know who made a schema change to your database?  If so, read on to learn how.

Finding the Worst Performing TSQL Statement 02/02/2017

Have you ever wondered how to find the worst performing TSQL queries on your instance?  If you have, you are not alone.

How to Programmatically Determine Which Edition of SQL Server is Installed 02/02/2017

Greg Larsen shows you how to determine if you are running the standard, enterprise, or developer edition of SQL Server.

Simple Row Level Security for SQL Server 2016 01/03/2017

Have you ever had a need to place some simple row level security on a SQL Server table? Well now you can do that in SQL Server 2016 by using row level security.

Using A Block Predicate to Restrict Row Updates and Inserts 01/03/2017

If you are using row level security in SQL Server 2016 you might find users are updating or inserting rows of data that keep them from seeing the row after they have performed the update or insert statement. If you want to prevent this from occurring, you can use a blocking predicate.

Identifying Last Night’s SQL Agent Job Failures 12/01/2016

Finding the nightly job failures is just one of a DBA's morning rituals. It is fairly easy to scan all the email with a number of creative search criteria, but what if you would like a more automated approach? Read on to learn how to find and report all job failures using a script.

Removing Email from msdb Database 12/01/2016

Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records from the msdb database. If you are sending email using database mail and you are not periodically purging email information, then you might find out this is one of the reasons your msdb database is growing bigger.

How to Get the Output of a Stored Procedure into a Table 11/03/2016

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.

Which Indexes are not Used? 11/03/2016

During the development cycle, indexes will be placed on SQL Server tables to speed up performance when searching for records. Lots of thought probably has gone into creating just the right mix of indexes based on how developers think customers will use the system. But how do you tell if all the indexes are being used once your database has been implemented into production?

Reading Backup History Information for a Database 10/03/2016

There are times when you might want to read backup/restore history information to identify a backup’s start and finish date/time, the location where the backup was written, the size of the database backup, etc. Greg Larsen shows you how to do this in SQL Server.

Database User and Programming Tips Archives