SET XACT_ABORT is one of the hidden gem we can say. It is helpful in many ways.Let me explain by an example suppose you are working on a stored procedure which is doing a complex data manipulation. You though this query will run with in 1 minute when you run it from .NET or other …
Hello friends,Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature. ** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition. ** This feature is not available in SQL Server 2005’s Standard edition. I hope by the name it is …
In last post TIP #91 we talked about What is Data compression ? What are the features ? Now in this tip we will take implement the data compression with basic steps.So lets follow the steps1) Right click on the table on which you need to implement compression. You will get following menu just select …
SQL Server is a uniquely designed Relational Database Management System developed by Microsoft. Its basic functionalities include storing, manipulating and retrieving data requested by multiple software applications running on a single computer or on any other machine across a network. Details of SQL Server Database: For storing SQL Server data individual files are created for …
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” …
When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …
Dear Friends, In my last article (TIP 87) I wrote about PWDENCRYPT. I forgot to write few details but thanks to all my talented friends & blog readers who guided me by providing there feedback on post. I respect their inputs and always interested to get more inputs. Thanks to all of you. Now I …
I the last tip TIP#88 we saw how to encrypt a password. Now in this tip I would like to share how to check encrypted password ? Means once you stored your encrypted password in database now next step is to compare that particular password with your input password and return results accordingly. The …
Security is always a concern for every database developer. How to secure valuable information is one of the major and important aspect. The first approach toward security to have a strong username & password and the next step is to have password in encrypted form. Now this article will help you to encrypt your password …
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which SQL Server provides. By using this stored procedure we can easily determine all the dependencies of particular table. The stored procedure is sp_msdependencies We can use this stored procedure as shown below Execute sp_msdependencies …