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

SQL SERVER – Introduction to Function SIGN

June 23, 2012

Yesterday I received an email from a friend asking how do SIGN function works. Well SIGN Function is very fundamental function. It will return the value 1, -1 or 0. If your value is negative it will return you negative -1 and if it is positive it will return you…

SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY

June 22, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

The most common question I often receive is why do I blog? The answer is even simpler – I blog because I get an extremely constructive comment and conversation from people like DHall and Kumar Harsh. Earlier this week, I shared a conversation between Madhivanan and myself regarding how to…

SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode

June 21, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

What do you do when you are in a hurry and hear someone say things which you do not agree or is wrong? Well, let me tell you what I do or what I recently did. I was walking by and heard someone mentioning “Columnstore Index are really great as…

SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video

June 20, 2012

Pinal Dave

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

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

Importing data into database is one of the most important tasks. I often receive questions regarding what is the quickest way to insert CSV data or how to import CSV Data into SQL Server Table. Honestly the process is very simple and the script is even simpler. In today’s SQL…

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

There is an old quote “A Picture is Worth a Thousand Words”. I believe this quote immensely. Quite often I get phone calls that something is not working if I can help. My reaction is in most of the cases, I need to know more, send me exact error or…

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

June 18, 2012

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

I love interesting conversations with related to SQL Server. One of my friends Madhivanan always comes up with an interesting point of conversation. Here is one of the conversation between us. I am very confident this blog post will for sure enable you with some new knowledge. Madhi: How do…

SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)

June 17, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Just like any other Developer or DBA SQL Server Management Studio is my favorite application. Any any moment of the time I have multiple instances of the same application are open and I am working on it. Recently, I have come across a very interesting feature in SSMS related to…