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

SQL SERVER – Shortcut to SELECT Single Row from Table – SQL in Sixty Seconds #046 – Video

March 13, 2013

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio

Earlier I have blogged about the same subject and in very short time I received lots of good comments about this blog post as well lots of email from users who faced issues to make this work. Thought, the instructions are very simple in the blog post, every user read…

SQL SERVER – Avoid Using Function in WHERE Clause – Scan to Seek

March 12, 2013

Pinal Dave

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

SQL Function, SQL Index

“Don’t use functions in the WHERE clause, they reduce performance.” I hear this quite often. This is true but this subject is hard to understand in a single statement. Let us see what it means and how to use the function in the WHERE clause. We will be using sample…

SQLAuthority News – SQL Server Data Tools – Business Intelligence for Visual Studio 2012 – SQL Server 2012 Data-Tier Application Framework

March 10, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Utility

Microsoft SQL Server Data Tools provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform within Visual Studio. The SQL Server Object Explorer in Visual Studio offers a view of your database objects similar to SQL Server Management Studio. SQL…

SQL SERVER – Weekly Series – Memory Lane – #019

March 9, 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…

SQL SERVER – Tricky Question – What is the Default Size of the Database

March 8, 2013

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

I love tricky questions – they are fun and educating. Yesterday I was presenting in one of the largest organization in India on SQL Server Performance Tuning Subject. During the conversation, one of the user suggested that every single time they are creating new database it is created with the…

SQL SERVER – Watch Four Efficiency Tricks in SQL Server In Sixty Seconds – Subscribe for SQL Learning Videos

March 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL in Sixty Seconds

SQL in Sixty Seconds has been my favorite thing to do every Wednesday. It is indeed truly said that “A picture is worth a thousand words” – it is equally true that “A video is worth a thousand pictures”. Though recording the video is easy the difficult part is to…

SQL SERVER – Exporting Query Results to CSV using SQLCMD

March 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

sqlcmd

Social media is evolving at a rapid pace and every day I keep on getting question from different methods. Here is the latest question which I received on my Facebook page. The question was how to export the data of query into CSV using SQLCMD. This is indeed very easy…