Any maintenance activity requires some amount of dedicated resources. SQL Server uses locks to reserve resources for a particular task and maintain isolation between transactions. Answer this simple question regarding locks and index maintenance in SQL Server databases to win up to two (2) Pluralsight training codes!...

In this post we would see one of the bad practices very commonly followed by developers which is risky as without our knowledge data would have got truncated before getting inserting into the table!...

There was a question in the forums where a user asked for a solution to find out the number which is succeeded by the last 0 in that number For example, in numbers like 10807023 and 1000508, 23 and 8 are the numbers which are succeeded by the last 0 of...

One of my friends asked me to ask him a very different and tricky interview question. I asked him to come up with the code that passes parameter to getdate() function ie use any code where getdate(something) is part of the code. Although it is very interesting he did not come up with an answer. Here......

Square braces in SQL Server play a major role in T-SQL programming. When an object name contains a space, special character, etc, the only way to express them is to put them around squre braces. Consider that you want to create a table user master (with spaces between user and master), you can use [u......

In the past I have published a few queries that allows you to query SQL Server Reporting Services database – to retrieve specific information about various reports deployed in the Reporting Server Instance. Recently, I got a question in my ASK forum who wanted to identify all the reports that use a ......

In many of the previous posts, we discussed about controlling the structure of the XML being generated with FOR XML. SQL Server 2005 introduced the PATH operator which provides a great extend of control over the shaping of the XML being generated. With PATH, we could achieve most of the XML shaping ......

Problem:When we run in the issue of something wrong or incorrect with stored procedure and suppose the stored procedure has 1000 lines long and very complex code for custom logic inside it, what you do? Then for above such issue, we put the SQL trace and get the procedure parameters and manually run......

Consider the following CREATE TABLE statementsCREATE TABLE emp1(emp_id int,) GO CREATE TABLE emp2(emp_id int,first_name varchar(50),) GONote that there is extra comma after the datatype of last column. But SQL Server ignores it and execute them without ...

There was a question in the SQL forums that the user wanted to remove leading zeroes in the numbers from a varchar column. The column will have numbers, alphabets or alpha-numeric strings. Only numbers should be considered for removing the leading zeroe...