SQL Server

Pro Members SQL Server Standard Members

Tips for using ASP.NET with SQL Server 2012

by

Tips for using ASP.NET with SQL Server 2012 Try to avoid using ADO methods to access SQL Server data in your ASP. Use SQL Server 2012 stored procedures instead of ADO methods. By doing so, you can reduce network traffic and boost overall ASP.NET performance. If you use ADO to access SQL Server data in your ASP.NET, try to avoid...

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 VII – Attribute Relationships

by

Learning SSAS Part VII – Attribute Relationships Hello and welcome to the latest article in the Learning SQL Server Analysis Server series. The series started with the basic terminologies and techniques in Analysis Services before moving on to more complex things like building cubes. In the previous few articles we started diving deeper with hierarchies, advanced dimension properties and 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

SQL Server 2012 Temporary Tables Optimization Tips

by

SQL Server 2012 Temporary Tables Optimization Tips Use local temporary tables instead of SQL Server 2012 cursors. Because using temporary tables usually are more efficient than using cursors, you should use temporary tables instead of cursors whenever possible. Try to avoid using temporary tables inside your stored procedure. Using temporary tables inside stored procedure reduces the chance to reuse 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

What’s In a Name? On Database Naming Standards

by

What’s In a Name? On Database Naming Standards By Craig S. Mullins The establishment and enforcing of naming conventions is often one of the first duties to be tackled when implementing new software. Adequate thought and preparation is required in order for such a task to be successful. What amount of effort should be extended in the creation of appropriate...

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

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1

by

DAX and PowerPivot Essentials: Introduction to PowerPivot, DAX and the Related() and Distinct() Functions, Pt. 1 This is the first article of a new, SSWUG – exclusive series, DAX and PowerPivot Essentials. The primary focus of this series will be an introduction to PowerPivot for Excel and the Data Analysis eXpressions (“DAX”) language. The series is designed to provide hands-on...

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 Transact-SQL Optimization Tips

by

SQL Server 2012 Transact-SQL Optimization Tips Try to restrict the queries result set by using the WHERE clause. This can results in good performance benefits, because SQL Server will return to client only particular rows, not all rows from the table(s). This can reduce network traffic and boost the overall performance of the query. Avoid using optimizer hints in your...

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

Troubleshooting SQL Server 2012 Roles

by

Troubleshooting SQL Server 2012 Roles If you have problems with SQL Server 2012 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...

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

Understanding SQL Server Full-text Indexing – (Part 2)

by

Understanding SQL Server Full-text Indexing – (Part 2) Author: Basit A. Farooq In this part, you will learn how to create full-text index using Transact-SQL, and how to manage and optimize full-text search catalogs and indexes. Creating a full-text index by using Transact- SQL To create a full-text index by using Transact-SQL: If the full-text catalog you want to store...

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

Understanding SQL Server Full-text Indexing – (Part 1)

by

Understanding SQL Server Full-text Indexing – (Part 1) Author: Basit A. Farooq In this part, you will learn about full-text indexing, how to configure an SQL Server instance to support full-text search, and how to create full-text index using SQL Server Management Studio. Introduction: SQL Server allows applications and users to execute full- text search queries against character based data...

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

3 Things: Moving Some, All or None of Your Systems to the Cloud

by

3 Things: Moving Some, All or None of Your Systems to the Cloud by Stephen Wynkoop Overview Making the move – for some or all (or none) of your systems is a big move. At first it’s all about cost savings. Then you find that there are really strong reasons for moving that encompass functionality, better systems, better availability 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 … 96 97 98 99 100 … 115