Standard Members

Development Pro Members Standard Members

How do you learn to let go when outsourcing to others?

by

How do you learn to let go when outsourcing to others? 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...

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 →
Development Pro Members Standard Members

Is it more important to possess hard skills or soft skills in an interview?

by

Is it more important to possess hard skills or soft skills in an interview? 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...

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 →
Pro Members SQL Server Standard Members

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-3)

by

SQL Server Interview Questions and Answers for DBAs and Developers – (Part-3) 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 and settings. Question Difficulty = Moderate Question 1: How you can view 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 … 56 57 58 59 60 … 110