Viewing 9 posts - 1 through 9 (of 9 total)
How do you get EPPlus.dll installed in GAC on windows server 2008 R2 without GACUTIL or Win SDK?
December 15, 2016 at 1:50 pm
Thanks!!
I am trying to understand why SQL Server is updating records using two different rows? My thinking was in any case it gets all columns updated from one row.
March 2, 2012 at 11:06 am
you can check this more real example too.
create table #Data
(
COMPANY int,
NAMEvarchar(50),
SALARY int
)
create table #Random
(
Random_COMPANY int,
Random_NAMEvarchar(50),
Random_SALARY int
)
insert into #Data (COMPANY, NAME) values (1, 'ABC' )
insert into #Data...
March 1, 2012 at 9:34 pm
Source Table1
idval1val2
11NULL
123
Destination Table before update
idval3val4
188
Expected Destination Table after update - Option 1
idval3val4
11NULL
Expected Destination Table after update - Option 2
idval3val4
123
Destination Table after update - Real Output
idval3val4
113<-- This should be null
March 1, 2012 at 9:16 pm
BOB: Are you saying that you can at this moment change from nvarchar back to varchar and see the performance degrade, even if you run the stored procedure with the...
August 31, 2009 at 1:45 pm
I have checked execution plan. It is same for NVARCHAR and VARCHAR.
I tried on three different servers. and on all three servers I am getting same perfromance.
I am also surprised...
August 31, 2009 at 1:05 pm
Very Nice Article.
I have one doubt about table variable.
Inside one of my SP, I am storing values in table variable to loop through the records.
If number of records inserted in...
July 9, 2009 at 11:59 am
Thanks for the reply. I was confused by reading so many forums for cursor, which has many different explanation for cursor. I got the answer why cursor is slow. It...
April 26, 2009 at 3:48 pm
@Gila Monster:
You said that cursor is working iteratively, My Question is that table variable is also works on iteration. so why only cursor is slow? and not table variable.
April 17, 2009 at 12:34 pm
Viewing 9 posts - 1 through 9 (of 9 total)