Pro Members

Pro Members SQL Server Standard Members

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 1

Elemental MDX: MDX Time Series Functions: PeriodsToDate() and OpeningPeriod(), Pt. 1 In this three-part article, we will introduce the PeriodsToDate() and OpeningPeriod() time series functions, which we can exploit to perform analysis within the context of time. As we have discussed in other articles of the Elemental MDX series, many business requirements revolve around theperformance of analysis within the context...

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.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 Transactional Replication

Tips for using SQL Server 2012 Transactional Replication SQL Server 2012 introduces AlwaysOn Availability Groups. This is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise and supports a failover environment for a discrete set of user databases, known as availability...

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.
Log In Register
Pro Members SQL Server Standard Members

Moving your SSIS package to a new server

Moving Your SSIS Package to a New Server by Kautuk Pandey Generally I do not write about SQL Server integration Services, keeping myself restricted to SQL Server and SQL Server Analysis Services. But, recently during the development of a data warehousing solution using Analysis Services I used Integration Services extensively (for dynamic partitioning and processing of the cube but that...

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.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 Snapshot Replication

Tips for using SQL Server 2012 Snapshot Replication SQL Server 2012 introduces AlwaysOn Availability Groups. This is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise and supports a failover environment for a discrete set of user databases, known as availability...

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.
Log In Register
Oracle Pro Members Standard Members

NULLs and Average

NULLs and Average Aggregate functions, such as MAX, MIN, AGR, and SUM ignore NULLs. That may be a problem if you want to aggregate all the rows, not just those with non-NULL values for the column of interest. To solve this problem, you can use the NVL function. Read on to learn how. For the article sample, you’ll need to...

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.
Log In Register
Pro Members SQL Server Standard Members

SQL Server: Purging msdb History Tables to Control msdb Database Growth

SQL Server: Purging msdb History Tables to Control msdb Database Growth By Basit A. Farooq From time to time, I see the following question posted on various SQL Server forums by different users asking why the msdb database on their SQL Server instance is too big. As we all know, msdb is a system database that supports SQL Server Agent...

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.
Log In Register
Pro Members SQL Server Standard Members

Troubleshooting problems with indexes in SQL Server 2012

Troubleshooting problems with indexes in SQL Server 2012 If you have problems with indexes in SQL Server 2012, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 index bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At 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.
Log In Register
Oracle Pro Members Standard Members

Column-Level Security with Views

Column-Level Security with Views Perhaps using views is the best option when it comes to restricting access to a certain column or columns within a table. First, you create a view that selects all the columns from the underlying table except those ones you want to make inaccessible. Then, you grant the SELECT privilege on that view to your users,...

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.
Log In Register
Pro Members SQL Server Standard Members

XML Support and SQL Server (Part 5)

XML Support and SQL Server (Part 5) By Basit A. Farooq Editor’s Note: This article is the fifth part of my XML support and SQL Server article series. In this part, I’ll discuss the basic XML queries and data manipulation. I’ll also give the brief introduction to the XQuery language and the use of query(), value(), exist(), nodes(), and modify()...

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.
Log In Register
Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 stored procedures

Tips for using SQL Server 2012 stored procedures Include the SET NOCOUNT ON statement into your stored procedures. This can reduce network traffic, because your client will not receive the message indicating the number of rows affected by a Transact-SQL statement. Try to avoid using temporary tables and DDL (Data Definition Language) statements inside your stored procedure. Using temporary tables...

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.
Log In Register