(Pinal Dave) When I do not find anything on my blog, I write a blog post about it, so next time I do not have to recreate the scripts from the beginning. Just another day, I was doing performance tuning for an organization, I had to create a computed column with CASE statement and I suddenly realize

(Koen Verbeeck) SQL Server 2016 comes with the integration of the popular language R into the database engine. This feature has been introduced in SQL Server 2016 preview CTP3.0 and is called SQL Server R Services. In previous tips we explained how to set-up the client and server machines, how to le

(Pinal Dave) Let us first see script which will return us tablename with schema where clustered index is not a primary key.

(Cate Murray) Very few applicants in the Information Technology world have 100% of the skills and technologies listed on a job description. This isn’t necessarily a hindrance, however, that will prevent you from getting the position.

(Manoj Pandey) Im getting following error:

(Kalen Delaney) As a teacher, and also a student of languages, one issue that’s always fascinating to me is how people choose to shorten a compound, or multi-part, name. This is very problematic when the word is from another language. For example, we use the word latte in English as a short form o

(Arshad Ali) While doing performance troubleshooting, have you ever wished for a process that was easier and faster to follow, especially when your system had slowed down and business is being impacted? Did you wish you could compare the execution plans for a query from a different time frame easily

(Steve Endow) If you create custom tables for Dynamics GP customizations or have situations where you need to backup and recreate tables via SQL script, you’ve probably used the “Script Table” feature in SQL Server Management Studio.

(Ed Elliott) I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed at what time.

(Denny Cherry) Recently there has been some talk online about how SQL Server processes data type conversions compared to how Oracle’s method for type conversion. I figured that I would clear up some of the confusion that’s out there.