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

Interview Question of the Week #053 – What is the Difference Between Deterministic Functions and Nondeterministic Functions?

January 10, 2016

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

Some questions are so theoretical that I believe they really do not add too much value if users know that question or not. Here is one such question I am very confident that you agree with my point of view. Questions: What is the Difference Between Deterministic Functions and Nondeterministic Functions?…

It’s a New Year, Take Advantage of It – Notes from the Field #110

January 7, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Milestone

[Note from Pinal]: This is the first episode of Notes from the Field series in the year 2016 and 110th overall. There is one place where I see the maximum crowd in the new year – fitness center (gym). It is indeed a good thing that we all want to…

SQL SERVER – Monitoring and Troubleshooting SQL Server Got Easy with Diagnostics Tool

January 6, 2016

Pinal Dave

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

Idera

Blogging has never been an easy task. With close to 9 years of non-stop learning and sharing has got me into a rhythm that I rarely miss a single day without writing one. Over these years, there is one topic area that gets most number of hits based on subject.…

SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database

January 5, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Few days back I have written blog containing script for removing space in column name using sp_rename. In case you missed, I am listing them below for quick reference. SQL SERVER – Script: Remove Spaces in Column Name in All Tables SQL SERVER – How to Rename a Column Name…

SQL SERVER – Someone was trying to hack my SQL Server Logins in Azure!

January 4, 2016

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

When I started to work with SQL Server on Azure VMs, I was completely excited because now the need to build local VMs has become super easy. If I need something for testing, then I know I can get a SQL Server instance in a jiffy and it can be…

Interview Question of the Week #052 – Print String in Reverse Order

January 3, 2016

Pinal Dave

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

Last week, I attended the last interview of the year. One of my co-interviewer asked a coding question to the candidate. In this type of question, the candidate is given one hour with SQL Server with a help file. The computer does not have internet candidate can use all the…

SQL SERVER – Script: Finding Cumulative IO Per Database File

January 2, 2016

Pinal Dave

SQL, SQL Server

MySQL, SQL Scripts

Sharing SQL Server related scripts is something I tend to do from time to time. At the SQLPass one of the attendees for my session around 42 tips asked, if I have any script that is handy to find the IO utilization per database file because they had couple of…