SQL Server

Pro Members SQL Server Standard Members

SQL Server Database Backups and Recovery Models – (Part 3)

by

SQL Server Database Backups and Recovery Models – (Part 3) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you learned about basics of SQL Server backup process and database recovery models. In the second part, you learned about various SQL Server backup types,...

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

Learning SSAS: Part VI – Creating Hierarchies

by

Learning SSAS: Part VI – Creating Hierarchies Hello and welcome to the latest article in the Learning SQL Server Analysis Services series. Till now you must be familiar with a lot of things in SQL Server Analysis Services. In the previous articles of this series I have shown you how to create dimensions, facts and more importantly a cube using...

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 2012 Table Hints

by

Tips for using SQL Server 2012 Table Hints One of the ways to increase the queries performance is using the SQL Server 2012 table hints. The table hints specify a locking method to be used by the query optimizer with this table, specify the locking granularity for a table, or one or more indexes to be used by the query...

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

Elemental MDX: MDX Time Series Functions: ClosingPeriod(), LastPeriods() and ParallelPeriod(), Pt. 1

by

Elemental MDX: MDX Time Series Functions: ClosingPeriod(), LastPeriods() and ParallelPeriod(), Pt. 1 In this three-part article, we will introduce the ClosingPeriod(), LastPeriods() and ParallelPeriod() time series functions, continuing our recent forays into functions that we can exploit to perform analysis within the context of time. This article follows an examination of a couple of other such time series functions 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 →
Pro Members SQL Server Standard Members

SQL Server Database Backups and Recovery Models – (Part 2)

by

SQL Server Database Backups and Recovery Models – (Part 2) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you learned about basics of SQL Server backup process and database recovery models. In this second part, you’ll learn about various SQL Server backup types,...

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 2012 Query Hints

by

Tips for using SQL Server 2012 Query Hints If your query is very slow, try the following before using query hints: – rebuild indexes used in the query (or defragment them using DBCC INDEXDEFRAG), – update statistics on the relevant tables, – consider creating new indexes for this query, – rewrite your query to provide better execution plan. Use 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

First, You Must Define Data Integrity…

by

First, You Must Define Data Integrity… By Craig S. Mullins The term "data integrity" can mean different things to different people… and depending on context. At the top level, there are two aspects of integrity with respect to databases: database structure integrity and semantic data integrity. Keeping track of database objects and ensuring that each object is created, formatted and...

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 jobs in SQL Server 2012

by

Tips for using jobs in SQL Server 2012 Specify the understandable job name. Try to specify the job’s name so, that the name describes what the job makes. By using so, you can simplify jobs administering and monitoring. Try to separate very large job into several small jobs. This can improve performance, and can be useful to maintenance the jobs...

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

Learning SSAS: Part V – Creating Dimensions

by

Learning SSAS: Part V – Creating Dimensions Hello and welcome to the fifth part of the series. In the previous articles I showed you how to create an SSAS cube and build and deploy it to a target Analysis Server. In the process you should have learnt how to create Data Sources, Data Source Views, Diagrams and Calculated Columns etc....

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 Database Backups and Recovery Model – (Part 1)

by

SQL Server Database Backups and Recovery Models – (Part 1) Author: Basit A. Farooq Editor Notes: This is the three part article series on SQL Server Database Backups and Recovery Models. In the first part, you will learn about basics of SQL Server backup process and database recovery models.In the second part, you will learn about database backup and transaction...

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 … 98 99 100 101 102 … 115