SQL Server

Pro Members SQL Server Standard Members

Top 20 tips to optimize your T-SQL code (Part-2)

by

Top 20 tips to optimize your T-SQL code (Part-2) Author: Basit A. Farooq In this second of the two part article series, I will share the last 10 tips that you can follow to optimize T-SQL code. Tip#11: Avoid overindexing tables Indexes are the solution to many performance problems, but too many indexes on tables affect the performance of INSERT,...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

SQL Server 2014 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

SQL Server 2014 Transact-SQL Optimization Tips (Part 1)

by

SQL Server 2014 Transact-SQL Optimization Tips (Part 1) Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict user access […]

Continue Reading →
Pro Members SQL Server Standard Members

Application of Triggers and Understanding the Transaction Procedures in Database Part – 3

by

Application of Triggers and Understanding the Transaction Procedures in Database Part – 3 Forming Trigger An individual should make practice of the CREATE TRIGGER commands to form a trigger. The code of the CREATE TRIGGER command is as follows:- CREATE TRIGGER My_Trigger_Name ON { My_Table_Name or My_View_Name } { FOR | AFTER | INSTEAD OF } { INSERT | UPDATE...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 Database Console Commands

by

Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Tips for using SQL Server 2014 Database Console Commands

by

Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains […]

Continue Reading →
Pro Members SQL Server Standard Members

Application of Triggers and Understanding the Transaction Procedures in Database Part – 2

by

Application of Triggers and Understanding the Transaction Procedures in Database Part – 2 Data Definition Language (DDL) Trigger The Data Definition Language (DDL) trigger is executed in reply to Data Definition Language (DDL) commands, for an instance ‘CREATE TABLE, ALTER TABLE or DELETE TABLE’. Data Definition Language (DDL) triggers can be castoff to complete managerial jobs, for an instance database...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Tips for using indexes in SQL Server 2014 (Part 2)

by

Tips for using indexes in SQL Server 2014 (Part 2) Create a clustered index for each table. If you create a table without clustered index, the data rows will not be stored in any particular order. This structure is called a heap. Every time data is inserted into this table, the row will be added to the end of the...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
1 … 76 77 78 79 80 … 115