Standard Members Archives - Page 57 of 110

Standard Members

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

by Basit Aalishan Masood-Al-Farooq

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 Alexander Chigrik

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...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

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

by Sunny Singh

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...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How to delegate when you lean toward micromanaging

by Laura Lee Rose

How to delegate when you lean toward micromanaging Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 Database Console Commands

by Alexander Chigrik

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...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

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

by Sunny Singh

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...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How to be Productive When Your Boss is Not

by Laura Lee Rose

How to be Productive When Your Boss is Not Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t...

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 Alexander Chigrik

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...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

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

by Basit Aalishan Masood-Al-Farooq

Top 20 tips to optimize your T-SQL code (Part-1) Author: Basit A. Farooq Troubleshooting the database performance bottlenecks is not an easy task, since it can be influenced by a lot of different factors. However, common symptoms of SQL Server database performance bottlenecks are related to bad Transact-SQL (T-SQL) code. This is because, the core database application logic is done...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

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

by Sunny Singh

Application of Triggers and Understanding the Transaction Procedures in Database Part – 1 Introduction In the cutting – edge technology of Relational Database Management System (RDBMS), the information in a table / relation is connected to some additional tables / relations too. For that reason, every time an individual alters the information in one table / relation or another, the...

Already a member? Log in here

Continue Reading →