SQL Server

Pro Members SQL Server Standard Members

Tips for using SQL Server 2012 User-Defined Functions

Tips for using SQL Server 2012 User-Defined Functions If you want to invoke a stored procedure directly from a query and this stored procedure returns a scalar value, consider replacing a stored procedure with a scalar user-defined function. A stored procedure cannot be invoked from the SELECT statement, but if you need to invoke some code inside the query, try...

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 index related dynamic management views and functions – (Part 2)

SQL Server index related dynamic management views and functions – (Part 2) By Basit A. Farooq Editor’s Note: This is the part-2 of this this three part article series on index-related dynamic management and functions. In this part, I’ll be covering index-related dynamic management function (DMF): sys.dm_db_index_physical_stats. Introduction: SQL Server uses indexes to sort and organize table data. It creates...

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

Import or Export Files to or from in MSSQL 2005 and above versions.

Import or Export Files to or from in MSSQL 2005 and above versions. Eli Leiba 03/2013. General Description: The task of importing or exporting binary long data stored in files in the file system in MSSQL Server is a basic and important task that was dealt with differently over the years and the development of the Product. For the SQL...

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 Join Hints

Tips for using SQL Server 2012 Join Hints If you want to set any join hints, do not remember to test the query with hint and without the hint and compare results. Because SQL Server 2012 query optimizer usually proposes the best execution plan, you should test the query with join hint and use this hint only when it provides...

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 index related dynamic management views and functions – (Part 1)

SQL Server index related dynamic management views and functions – (Part 1) By Basit A. Farooq Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use to maintain, modify, tune and identify missing indexes. Some of these dynamic management views (DMVs) and dynamic management function (DMFs) you might use are...

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

Topics For a One-on-One with Your Manager

Topics For a One-on-One with Your Manager Professional Career Development Series This is Laura Lee Rose, a business and life coach that specializes in professional development, time management, project management and work-life balance strategies. In our weekly interview with Stephen WynKoop (founder of SSWUG.org and Bits on the Wire), we discuss various professional development and career growth topics. Recently we...

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 Merge Replication

Tips for using SQL Server 2012 Merge 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

Curbing the Curmudgeons in the Corner

Curbing the Curmudgeons in the Corner By Craig S. Mullins Sometimes viewed as prima donnas, DBAs can be curmudgeons who have vast technical knowledge, but limited people skills. Just about every database programmer has their favorite DBA story — those famous anecdotes that begin with “I have a problem…” and end with “…and then he told me to stop bothering...

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

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