In last few tips TIP #64 & TIP #65 we get information how to take backup & How to ensure it can be restore? Now lets me share some more information related to backup. Problem:- Sometimes , we are interested to know when last backup is taken for particular database ? Solution: The first …
Problem:- We have seen last time how to take backup in tip # 64. but sometimes it happened we took backup and we are not able to restore it. It might be corrupted. Now , Next step thought come in our mind how to ensure we took right backup which can be restore. …
Problem:- A good maintenance plan always said to take backup but sometimes it is very difficult to take backup of database just because of space constraint.We take backup but we don’t have enough space available.Solutions: SQL server provided the best way and gave us solution of compressed backup. Now how to take compressed backup let …
There are various functions available in SQL Server and it is good to know all of them you never know when they will be helpful to you. So lets start one by one. 1) LEN :- By the name it is clear that LEN function give length of the parameter For example :- DECLARE …
Problem: Sometimes we may require to convert row data to column. we require pivot view of data. Solution: Lets understand this by an example below I am using a table variable which have few columns like Employee, Amount, Month and year. Lets define and create some sample data here. DECLARE @tblEmployee AS TABLE (Employee …
Problem:- It is general problem that you are interested in generating the database diagram of a database and when you right click on database diagrams folder of database and try to create a new database diagram you get following error as shown in below snap. Solution:- The above snap says that you are not …
Grouping sets is one of the cool feature came in SQL SERVER 2008. Lets understand here with problem and solution. Problem:- Suppose , We want an aggregation result in a query with different groups. Firstly we want aggregated result on first column then combination of First & second column then other column combination. So, …
Problem:- One of the pain point in any SQL engineer is “Performance”. There are various reasons due to which your SQL Server database is slow. One of the possible reason is your maintenance. You don’t know when statistics last updated and take further step if those are not updated Solution:- Here we have simple …
Problem:- Suppose you have a source table and one destination table and you want to synch destination table from source table. means if record is already exists then you need to update and the record with latest value and insert the record if record is not exists. Solution:- Although there are various ways exist …
This is one of the interesting feature which I like most. Instead of passing values from collection one by one pass entire collection to stored procedure as a table value parameter. I know above statement is not digestive enough so lets understand this by an example. Suppose , I have a table tblStudent with …