SQL Server

Pro Members SQL Server Standard Members

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

by

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

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

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

by

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 […]

Continue Reading →
Pro Members SQL Server Standard Members

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

by

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

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 1)

by

Tips for using indexes in SQL Server 2014 (Part 1) Keep your indexes as narrow as possible. Because each index takes disk space try to minimize the index key’s size to avoid using superfluous disk space. This reduces the number of reads required to read the index and boost overall index performance. Use the WAIT_AT_LOW_PRIORITY option with ALTER INDEX statement....

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 Interview Questions and Answers for DBAs and Developers – (Part-4)

by

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-4) Author: Basit A. Farooq This article outlines the interview questions that you should ask to SQL Server DBA. These questions will help you to assess the candidate’s knowledge in relation to SQL Server instance-wide properties, settings and databases. Question Difficulty = Moderate Question 1: In the Server Properties...

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

Applying Managed Programming – Part 5

by

Applying Managed Programming Part – V Forming Managed User – Defined Types An individual can form a data type description in any of the .NET supported languages as well as practice it as a data type inside the SQL Server. This data type can be an amalgamation of any additional prevailing data type with more alterations smeared on it. An...

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

Some tips for designing SQL Server 2014 tables

by

Some tips for designing SQL Server 2014 tables Create the table’s columns as narrow as possible. This can reduce the table’s size and improve performance of your queries as well as some maintenance tasks (such as backup, restore and so on). Try to reduce the number of columns in a table. The fewer the number of columns in a table,...

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

Implementing Reliable ETL Processes with SQL Server Integration Services

by

Implementing Reliable ETL Processes with SQL Server Integration Services Author: Basit A. Farooq In our previous three-part article series “Incorporating logging, error handling, and reliability into your SQL Server Integration Services (SSIS) package design”, we have focused on logging and error handling both vital considerations to ensure long-term reliability of your SQL Server Integration Services packages. However, there are other...

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

Applying Managed Programming – Part 4

by

Applying Managed Programming – Part IV Forming Managed Trigger The managed triggers assistance in applying improved trigger sense which cannot be completed by means of T-SQL. An individual can form a managed trigger by means of the CREATE TRIGGER statement, as presented in the subsequent syntax:- CREATE TRIGGER < My_Trigger_Name > ON < My_Table or My_View > < FOR |...

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

Some tips for using Very Large Databases in SQL Server 2014

by

Some tips for using Very Large Databases in SQL Server 2014 Consider using table and index partitioning. In SQL Server 2014 tables and indexes can be divided into partitions based on value ranges. By using partitioning, you can transfer blocks of data within the database schema more efficiently because maintenance operations can be performed against single partitions instead of an...

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 … 77 78 79 80 81 … 115