(Pinal Dave) As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging.

(Dennes Torres) There are plenty of very useful object properties that can help us to find problems in our databases. We can use object properties to find tables without primary key, tables without clustered index and much more information.

(Pinal Dave) When I wrote the previous post around SQL SERVER ¨C CREATE TABLE Failed Because Column ¡®C1024¡ä in Table ¡®myTable¡¯ Exceeds the Maximum of 1024 Columns, I thought it was a simple concept.

(Rohit Garg) Today, My Friend is facing issue with SQL Server error logs on one of my production server. SQL Server is not able to read SQL server error log files. We have checked that SQL Server Error log files are accessible on file system.

(Chris Webb) A few years ago I wrote this post on how to alias columns in a table in DAX, using a combination of AddColumns() and Summarize(). The good news is that in Excel 2016/the Power BI Designer/SSAS Tabular 2016 there’s a new DAX function specifically for this purpose: SelectColumns().

(Kenneth Fisher) I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS IO and SET STATISTICS TIME. Well I learned a new one recently. Client Statistics Unfortunately there is no t-sql command to turn it on but it’s not terribly difficult.

(Dallas Snider) When I use the SQL Server RAND() T-SQL function as a column in a SELECT statement, the same value is returned for every row as shown below. How can I get differing random values on each row?

(Rod Trent) There’s been some discussion and little confusion over a new feature that will deliver in SQL Server 2016 called the “Query Store.” At first blush, you’d think that Microsoft was delivering a Windows-type app store for queries in SQL Server 2016.

(Marlon Ribunal) Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.

(Pinal Dave) It is second to human nature to utilize every bit of juice for what we pay. You buy something and you would like to get the best out of it right? If you start thinking from an organizations point of view, they think they should buy something which satisfies their needs.