Pro Members

Pro Members SQL Server Standard Members

Tips for using indexed views in SQL Server 2014

by

Tips for using indexed views in SQL Server 2014 Keep the indexes on the views as narrow as possible. Because each index takes up 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. Avoid creating indexes on a...

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

Information Organizations In Database Part 3

by

Information Organizations In Database – Part – 3 As stated in the last article that “In the forthcoming article we will be noticing particular fine points concerning Entity Centered Rational Replica’s – Associations, Natures of Associations, Attributes of An Entity and Sub-types & Super-types”, here is the article. Entity Centered Rational Replica:- There are numerous entities – grounded replicas. 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

Handling errors in T-SQL code

by

Handling errors in T-SQL code Author: Basit A. Farooq Like other programming languages, Transact-SQL provides a sophisticated mechanism that captures and handles errors during execution. The mechanism for handling errors during execution includes the Transact-SQL tradition error handling function @@ERROR and object-oriented-programming-style TRY…CATCH construct. In this article, you’ll examine both techniques. Traditional error handling Earlier versions of SQL Server supported...

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 Join Hints in SQL Server 2014

by

Tips for using Join Hints in SQL Server 2014 Use join hints very carefully. Because SQL Server 2014 query optimizer usually proposes the best execution plan, it is very unlikely that you can optimize your query by using join hints, more often, this will hurt performance. Try to rewrite the query to provide better execution plan. If your query is...

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

Information Organizations In Database Part 2

by

Information Organizations In Database – Part – 2 As stated in the last article that “In the forthcoming article we will be noticing particular fine points concerning Entity Centered Rational Replica’s – The Entity Relationship (ER) Model and Entities”, here is the article. Entity Centered Rational Replica:- There are numerous entities – grounded replicas. The generally used is the Entity...

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

Gearing up the Business for Data Analytics–Part II

by

Gearing up the Business for Data Analytics—Part II In the previous article we touched upon a number of steps in Data Analytics. In this article and the subsequent articles let us dig a little deeper into each step. To recap on the article, the first step in data analytics is creating the “Statement of purpose” or rather a list of...

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

Memory management for In-Memory OLTP Server – Part 1

by

Memory management for In-Memory OLTP Server Part-1 Microsoft introduced a new functionality in SQL 2014 namely memory optimized objects. As the name implies, this technology is about having tables reside in memory. This means that the memory usage on your database will be much higher. In this series of articles we will see how we can manage the memory in...

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

What’s the best way to handle uncomfortable networking events

by

The Best Way to Handle Uncomfortable Networking Events 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...

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

Memory management for In-Memory OLTP Server – Part 2

by

Memory management for In-Memory OLTP Server – Part II In my previous article, we saw how to calculate the memory needed for memory based objects when using In-Memory technology that was introduced in SQL Server 2014 version. We also saw how we can monitor the memory usage by these objects. In this article we will see how we can make...

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 Reporting Services Optimization Tips

by

SQL Server 2014 Reporting Services Optimization Tips Consider using the Google Chrome browser to run the Reporting Services native mode Report Manager. SQL Server 2014 release of Reporting Services adds support for the Google Chrome browser. So, you can use the Google Chrome browser to run the Reporting Services native mode Report Manager to manage reports and the report server....

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 … 65 66 67 68 69 … 110