Standard Members

Pro Members SQL Server Standard Members

Understanding SQL Server Database Restore Process

by

Understanding SQL Server Database Restore Process Author: Basit A. Farooq Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks. It is our responsibility as a database administrator (DBA) to ensure that the information in the databases is available all the time. Although, a SQL Server various high-availability solutions tries...

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

by

SQL Server 2012 Reporting Services Optimization Tips Try to restrict the report queries result set by using the WHERE clause and by returning only the particular columns from the table. This can results in good performance benefits, because SQL Server will return to client only particular rows and columns, not all rows and columns from the table(s). This can reduce...

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

Issuing SQL Statements in DB2 Utilities

by

Issuing SQL Statements in DB2 Utilities By Craig S. Mullins The EXEC SQL utility control statement can be used to declare cursors and execute dynamic SQL statements during an IBM DB2 for z/OS utility execution. The EXEC SQL control statement produces a result table when you specify a cursor. The EXEC SQL control statement executes entirely in the EXEC phase...

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 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 →
1 … 89 90 91 92 93 … 110