SQL Tips and Tricks Archives - Page 200 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName

November 28, 2013

Here is the question I recently received based on my earlier blog post – SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME. “How I get three part name if the only thing I have is object_id and current database context. What I mean is that, when I…

SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer

November 27, 2013

Pinal Dave

SQL Tips and Tricks

MySQL, SQL Order By, SQL Scripts

Here is a very interesting question I received, which is based on my MySQL courses. The same script works on SQL Server as well as MySQL. Let us understand how to Order Column by Nearest Value for Any Integer.

SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

November 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a fourth episode of Notes from the Field series. While installing SQL Server many DBA takes pride that they were able to install SQL Server without any special configuration or MS has built such a fantastic installer that all the default values worked since installation.…

SQL SERVER – Export Data AS CSV from Database Using SQLCMD

November 25, 2013

Pinal Dave

SQL Tips and Tricks

CSV, SQL Scripts, SQL Server

We have covered multiple times in this blog that we can import CSV to Database very easily. However, recently I received a very interesting question where the user wants to export data with the help of SQLCMD.

Personal Technology – A Quick Note on Good Elevator Etiquette

November 24, 2013

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I have been traveling a lot for different conferences and meetings lately, and that means a lot of air flights, taxi drives, and elevator rides! There are plenty of rules out there, both written and unwritten, for air flights and taxis, and we all more or less follow these rules…

SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database – SSMS

November 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Error Messages, SQL Scripts

This is a follow up of the blog post I have posted on error 3154 few years ago. I have received quite a few emails that how we can fix the same error with the help of SQL Server Management Studio. In this blog post, I will explain how we can…

SQL SERVER – vCPUs – How Many Are Too Many CPU for SQL Server Virtualization ? – Notes from the Field #003

November 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a third episode of Notes from the Field series. Lots of organizations do Virtualization. The purpose of the Virtualization is often consolidation, performance or just easy to use configuration. Looking at the various advantages of the Virtualization, nowadays I find lots of organization have implemented…