SQL Archives - Page 174 of 519 - SQL Authority with Pinal Dave

SQL SERVER – How to Change Compatibility of Database to SQL Server 2014

May 6, 2014

Yesterday I wrote about how we can install SQL Server 2014. Right after the blog post was live, I received a question from the developer that he has installed SQL Server 2014 and attached a database file from previous version of SQL Server. Right after attaching database, he was not…

SQL Authority News – Presenting at SQL Bangalore on May 3, 2014 – Performing an Effective Presentation

May 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQLAuthority Author Visit

SQL Bangalore is a wonderful community and we always have a great response when we present on technology. It is SQL User Group and we discuss everything SQL there. This month we have SQL Server 2014 theme and we are going to have a community launch on this subject. We…

MySQL – How to Create Stored Procedure in MySQL

May 2, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Stored Procedure

MySQL supports Stored Procedures which can execute set of codes by applying relevant business logics. In this post we will see how to create a stored procedure and execute it. Let us create the following tables CREATE TABLE items(item_id INT, item_description VARCHAR(100)); CREATE TABLE sales(sales_id INT auto_increment KEY,item_id INT, sales_date…

SQL SERVER – Synchronize Data Exclusively with T-SQL

May 1, 2014

Pinal Dave

SQL

Devart

Database developers often face the task to synchronize users’ data. Currently, to solve this task, there was developed quite a big number of various utilities. In this article, we will review the process of creating the new functionality to synchronize data exclusively with T-SQL.

SQL SERVER – Faster Application Performance with In-Memory OLTP

April 30, 2014

Pinal Dave

SQL

Safepeak, SQL Server

Today, I’d like to examine how in-memory OLTP engines to vastly improve performance and scalability of SQL Server databases and to accelerate applications. A very large part of this article focuses specifically on SQL Server 2014 and its new In-Memory OLTP capabilities.

SQLAuthority News – Two Microsoft Whitepaper on In-Memory OLTP

April 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Earlier this week, I was presenting at Great Indian Developer Summit in Bangalore. Lots of people were interested in the subject of In-Memory OLTP database. Everybody wanted to know how to do, use the new features of In-Memory OLTP feature. Microsoft has recently released two white paper which discusses about…

SQLAuthority News – Microsoft Whitepaper – Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

April 26, 2014

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Statistics

I have been reading this Whitepaper from a couple of days and I am yet not done reading it completely, but I think it is one of the best white papers I have read in the recent time. First of all, it is written by my friend and SQL Expert…