SQL Query Best Practice
78 views | +0 today
Follow
SQL Query Best Practice
Optimize data access in SQL server
Your new post is loading...
Your new post is loading...
Scooped by Senthilkumar Sevathan
Scoop.it!

Hadoop | Data on Wheels - Steve Hughes

Hadoop | Data on Wheels - Steve Hughes | SQL Query Best Practice | Scoop.it
Posts about Hadoop written by Steve
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

Dimensional Data Model - Premium resource to ... - Datawarehouse

Dimensional Data Model. Dimensional data models are popular amongst data warehousing systems as they are best suited for large scale data analysis queries. Dimensional data models are de-normalized as opposed to ...
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

SQL: UNION Query

The UNION query allows you to combine the result sets of 2 or more select queries.
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

SQL Query Help | DaniWeb

SQL Query Help | DaniWeb | SQL Query Best Practice | Scoop.it
Here is the code that can be copied into sql server to better assist with what I am trying to accomplish. Hope it makes sense and post back with any questions you may have: create table #temp(period int, location int, custnum varchar(10), driver ...
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

How to Get a CSV File Generated from a SQL Server Query (SQL ...

How to Get a CSV File Generated from a SQL Server Query (SQL ... | SQL Query Best Practice | Scoop.it
In SSMS (SQL Server Management Studio) you are running a query and want to get a CSV file as the results. This is accomplished by setting the Output format in the Query Options to Comma delimited. You can also ...
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

Enforce business rules with indexed views and a two-row table - SQLServerCentral

Enforce business rules with indexed views and a two-row table - SQLServerCentral | SQL Query Best Practice | Scoop.it
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

SQL Tuning - Lesson - Parallel Query

I uploaded a @YouTube video http://t.co/h8VmlEUu SQL Tuning - Lesson - Parallel Query...
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

Step by Step: Installing SQL Server 2012 RC 0

Step by Step: Installing SQL Server 2012 RC 0 | SQL Query Best Practice | Scoop.it

For my upcoming internal session on contained database, I decided to install latest version of SQL Server 2012

more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

Connection not Instalized SQL Query - Visual Basic .Net - Microsoft ...

Connection not Instalized SQL Query - Visual Basic .Net - Microsoft ... | SQL Query Best Practice | Scoop.it
Connection not Instalized SQL Query - posted in Visual Basic .Net: Hello, Please can you tell me why I keep getting connection string property has not been initialized? Dim con As New SqlClient.SqlConnection Dim cmd As ...
more...
No comment yet.
Scooped by Senthilkumar Sevathan
Scoop.it!

Cancelling a Long Running SSAS Query - SQL Chick

Cancelling a Long Running SSAS Query - SQL Chick | SQL Query Best Practice | Scoop.it
Data Analysis & Visualization with Microsoft Business Intelligence tools.
more...
No comment yet.