SQL Server Archives - Page 124 of 393 - SQL Authority with Pinal Dave

SQLAuthority News – Last Post of Year 2012

December 31, 2012

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

The year 2012 was the most interesting year. If I start listing what was special about this year – I think it will take me 2-3 days to just write a blog post about this subject. Let me pick few things which I would like to specifically call out. SQL…

SQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)

December 30, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Here is the question received from user – the email was long and had multiple request from reader to resolve this error. Scenario: The user was trying to import data from Excel to tables in SQL Server Database. Every time he attempted to import the data he faced following error.…

SQL SERVER – Weekly Series – Memory Lane – #009

December 29, 2012

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 – NuoDB RC2 Available to Download – General Availability in Near Future

December 28, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

Regular readers who are familiar with my blog will be also familiar with my interest in NuoDB. It is a very innovative new age database which follows 100% SQL, ACID and Elastically Scalability. Here is an earlier article on this subject where we explain why sharing will no more required…

SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.

December 24, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Here is the interesting conversation I recently heard between two teammates in one of the organizations I visited. DBA Jr: I can’t take transactional backup of the database. DBA Sr: What is the recovery model? DBA Jr: How to find the recovery model? DBA Sr: Go to SSMS >> Right…

SQLAuthority News – Chrome Browser – Personal Technology

December 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Personal Technology

Almost every computer you can buy these days will come with Microsoft Windows installed on it automatically. Also installed automatically – Internet Explorer, Microsoft’s web browser. Many of us use this browser without a second thought, but in this latest Personal Technology Tip and Trick I thought I’d expand your…

SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server

December 20, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime

A common question – I often get from Oracle/MySQL Professionals: “What is the Equivalent to CURRENT_TIMESTAMP in SQL Server?” Here is a common question I often get from SQL Server Professionals: “What are differences between Difference Between CURRENT_TIMESTAMP and GETDATE ()?” Very simple question but have showed up so frequently that I…