SQL Server

Pro Members SQL Server Standard Members

Tips for using Integration Services in SQL Server 2014 (Part 1)

by

Tips for using Integration Services in SQL Server 2014 (Part 1) Try to avoid SSIS lookups. Because SSIS lookups slow down performance, try to use the Transact-SQL statements to perform the same functions. If you need to combine data rows from multiple upstream data flow components, you can use the Union All, Merge, and Merge Join transformations. These transformations make...

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

Transact-SQL Subqueries

by

Transact-SQL Subqueries You use subqueries to break a query into logical steps. By using subqueries, you can often solve a complex data retrieval or modification problem with a single statement. You use subqueries in situations in which a query depends on the results of another query. Subqueries typically aren’t the most efficient way to retrieve data. Whenever possible, it is...

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

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 3

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 3 The PART 3 is the vital and core part of this “Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server” series. Each and every part of the code has been described in details for better understanding; this part of the article has been followed by an additional PART...

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 — Importing and exporting flat file data

by

Importing and Exporting Flat File Data Author: Basit A. Farooq File export Many companies have periodic requirements for flat files generated from database sources. You can use the SQL Server Import and Export Wizard to define the export SQL Server Integration Services package once and reuse the file as long as the export parameters don’t change any time. This means...

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

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 2

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 2 What is Web Service? The web service is a group of utilities which offer programmable reasoning castoff by customer’s systems across the internet. The web services are grounded on the Service Oriented Architecture (SOA) plus interact by means of Simple Object Access Protocol (SOAP). Simple Object Access Protocol...

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 linked servers in SQL Server 2014

by

Tips for using linked servers in SQL Server 2014 Try to avoid using distribution transaction or minimize it using. Because distribution transactions incur more overhead than general transactions, avoid using distribution transactions, whenever possible. One of the first steps to optimize remote queries against a SQL Server 2014 linked server is rewrite queries so, that the most work will be...

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

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 1

by

Applying Hypertext Transfer Protocol (HTTP) Endpoint in SQL Server – Part 1 Introduction The businesses make practice of web system each and every time they want their information to be accessible by the different users distributed over countless sites. The web systems practice some particular definite services, identified as the WEB SERVICEs, which offer program writing help plus benefits 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

Some tips for using views in SQL Server 2014

by

Some tips for using views in SQL Server 2014 Consider using indexed views. Indexed views can significantly improve the performance of an application because the result set of the indexed view is stored and indexed in the database. You do not need to modify your existing applications to take advantage of the performance improvements with indexed views. The indexed view...

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

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 4)

by

Installing and Configuring SQL Server 2014 on Windows Server 2012 – (Part 4) Autor: Basit A. Farooq Installing instance of SQL Server 2014 on Windows Server 2012 In the part-1 of this five part article series, we discussed the SQL Server 2014 installation prerequisites and the steps that we must perform for the installation of SQL Server 2014 instance. 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 →
1 … 79 80 81 82 83 … 115