|
|
-
|
|
When IDENTITY columns are added to existing tables, how is a particular record assigned an IDENTITY value?...
|
|
-
|
|
As I wrote about replication latency from publisher to distributor and distributor to subscriber for replication and an alert for replication latency, same as we need to have an alert in case of replication failure. I would like to review some of my ear...
|
|
-
|
|
Impressed by awesome sessions at SQLBangalore user group meeting today (15th of June, 2013), I decided to write a blog post about it. It’s a monthly event that takes place at Microsoft campus in Bangalore. Today’s UG meeting named “Relive TechEd 2013 a...
|
|
-
|
|
Different type of containers and uses in SSIS...
|
|
-
|
|
Export to XML File using SSIS...
|
|
-
|
|
IDENTITY values work great when inserting records into a table. But, can IDENTITY columns be added to existing tables where records already exist in the table? If yes, in what order will the IDENTITY values be assigned?...
|
|
-
|
|
As we know, in SQL Server we can almost use SET-BASED approach to implement any kind of business logic. Rarely CURSOR is used in some cases. Now the question is "When did you use CURSOR to get better performance than SET-BASED approach?"...
|
|
-
|
|
There is a large number of requests in multiple forums to split a delimitted column value to multiple columns. Here is one method that I worked on, probably, this would help most of us in future if we come across similar situation:
Create Table Pro...
|
|
-
|
|
POWER is one of the mathematical functions used in SQL Server which returns the value of the expression to a specific power. But it rounds the values after 16 digits if the result is more than 16 digits. Consider the following exampledeclare @value deci...
|
|
-
|
|
When one thinks of an incremental number, a series of positive numbers comes to mind. Is this true for IDENTITY columns too? Can IDENTITY numbers, their SEED and INCREMENT values be negative?...
|
|