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

SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey

April 15, 2013

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of…

SQL SERVER – Tricks for Row Offset and Paging in Various Versions of SQL Server

April 14, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Paging

Paging is one of the most needed tasks when developers are developing applications. SQL Server has introduced various features of SQL Server 2000 to the latest version of SQL Server 2012. Here is the blog post which I wrote which demonstrates how SQL Server Row Offset and Paging works in…

SQL SERVER – Weekly Series – Memory Lane – #024

April 13, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQLAuthority News – HP Project Moonshot Interchangeable and Interlockable Servers with Elastically Scale NuoDB

April 12, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

NuoDB

HP has recently released a new product called Project Moonshot. For anyone interested in databases, server systems, or cloud computing, the description of this new option was intriguing. On its most basic level, Project Moonshot is a scalable server system, available in small units that are easy to enlarge and…

SQL SERVER – Fix : Error: 217 Implicit conversion from data type datetime to int is not allowed.

April 9, 2013

Pinal Dave

SQL

SQL Error Messages, SQL Scripts, SQL Server

Just a day before I was working on some query and faced this error. As soon as I receive this, I realized that what I had done wrong and what I needed to fix. The suggestion demonstrated in the error message is to the point and accurate. Let us learn how to fix error 217 for Implicit conversion.

SQL SERVER – The procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

April 8, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Stored Procedure

Here is one of the very common question I receive on SQLAuthority Facebook page. I usually answer them on Facebook but this one I find it very interesting so I decided to answer here. “There are few of the stored procedure when I try to execute they return following message. Would…

SQL SERVER – Weekly Series – Memory Lane – #023

April 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane