The SIGN function returns 1, -1 or 0 depending on whether a value is positive, negative or zero. A simple example with INT and DECIMAL values.
SQL SERVER – Follow up – Usage of $rowguid and $IDENTITY
A follow up with great comments from David Hall and Kumar Harsh on the usage of $rowguid and $IDENTITY, and the limits of my earlier solution.
SQL SERVER – ColumnStore Index – Batch Mode vs Row Mode
Someone said columnstore indexes run only in batch mode. I stopped to disagree. Here is what I showed about columnstore batch mode vs row mode.
SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video
What is the quickest way of importing CSV file data into a SQL Server table? This SQL in Sixty Seconds video shows it: create a table, BULK INSERT, verify.
SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue
A friend could connect to SQL Server but could not see any user created object, while his colleague could. It was a security and permissions issue.
SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables
Madhivanan asked how to tell if a table has a uniqueidentifier column without querying system tables or DMVs, knowing only the table name.
SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)
Open a read only file in SSMS and you get a small lock icon. You can edit it, but saving brings a pop-up. Here is how SSMS handles read only files.