Whenever we develop application of maintain application we define sets of rules or policies like naming convention , data type, database & SQL SERVER properties (like which property should be unable or disable) but the problem is to cross check or to enforce these properties is very tedious. To enforce the policies SQL SERVER …
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer will roaming around like so Can you update record using View? or Can you delete record using view ? I hope everyone who is reading this article will be aware of what is …
In last post, TIP#96 We have configured Database E-mail. Now in this post we will see how to send mail in SQL SERVER. Sometimes we need to send mail for different requirements like 1) Notification mails like data inserted /updated/deleted successfully 2)Send data reports like no of amount earned, failed transaction etc. for this …
A part from performance many times we faced challenges related to space of our database. Sometimes our database is actually taking huge space and sometimes it our mistake due to which it took space. It is worst condition when you are on a dedicated hosting or cloud hosting with limited space. In such case “Compression” …
It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command. When someone wants to determine detail of a function or stored procedure he/she can use this useful command. The syntax is very simple. Just write sp_helptext Storedprocedure/ functionname For example …
Hello friends, Just wanted to share some technical words here again it is good to know 1) OLAP : On Line Analytical Processing 2) MOLAP :- Multidimensional On Line Analytical Processing 3) ROLAP :- Relational On Line Analytical Processing 4) HOLAP :- Hybrid On Line Analytical Processing 5) RTOLAP :- Real Time On Line …