|
|
-
|
|
So after a long i get a chance to work on SQL Server 2008 and understand it in better way. So today we look into a new storage feature in SQL Server 2008 as Sparse Column. Sparse column takes no physical usage for a column which may have “NULL” data. This means when you declare a column......
|
|
-
|
|
Hi all … This time a great news for all the technology enthusiast and want to meet great peoples in technology and you missed TechEd India 2009 so you can attend now the same kind of event in Ahmedabad, India on June 20, 2009 Saturday(TechEd on Road) by 1:30 PM. You will get a chance to meet Two M......
|
|
-
|
|
Hi all,
Here is a very powerful feature of SQL Server 2005 is Data Encryption & Decryption, in Sql Server 2000 if we like to Encrypt Data then we have to write our own functions to encrypt the data. In SQL Server 2005 and SQL Server 2008, these functions are available by default.
SQL Server p......
|
|
-
|
|
Hi all,
Today i encounter a issue with my instance as i am using the table SPT_VALUES from the master database available in our Sql Server, so when i tried to fetch some records from master..spt_values then it shows me error…
Here is a example of query and the error thrown by SQL is..
......
|
|
-
|
|
Being a .Net developer, the most useful feature i found was the Error Handling or Exception Handling technique.When it comes to programming languages , all popular OOP languages have TRY()…Catch() method to handle an exception.
In Sql Server 2005, error handling was made easy . This article ......
|
|
-
|
|
Hi…
In this post , I showed a way to generate 8 characters numeric and alpha numeric values.This can be useful in situations where one has to allocate passwords or unique id to users.
Here is a way in SQL to generate Random, Unique and Reliable Alpha Numeric Values..
SELECT NEWID()......
|
|
-
|
|
Partitioned tables are a new feature available in SQL Server version 2005, aimed mainly at improving the performance of large database systems. It helps us to split the larger tables and data in to smaller parts.
In a few word this means that you can horizontally partition the data in your table......
|
|
-
|
|
Hi this is first post for INDEXES in SQL Server. In this we learn about indexes , how SQL use indexes and all.
If you have much experience with indexes at all, you are probably already familiar with the difference between clustered and non-clustered indexes. So we look at that whether or not SQL SE......
|
|