Forum Replies Created
Viewing 15 posts - 331 through 345 (of 8,416 total)
-
RE: UPDATE when the values are the same
Sergiy (8/28/2012)
Please explain why:- X locks applied to RID
- IX locks applied to pages.
What makes then different?
SQL Server can acquire locks at different levels, for example it can lock rows,...
-
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function
Usman Butt (8/28/2012)
Good news not yet. :unsure: I did not opt this while testing since I want it to be an iTVF, So we know NEWID() cannot be used :(.... -
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function
Jeff Moden (8/28/2012)
Is it something that could change characteristics based on the next change that MS might bless us with or do you think it's stable for the good part... -
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function
Jeff Moden (8/26/2012)
Ok... I tried those two. Why does the LEFT(@@Dbts,0) speed things up so much?It's intriguing, enough to be the subject of my next blog post after the...
-
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function
Usman Butt (8/28/2012)
But MTVF code speeded up things quite significantly which I shared earlier. For "not created in the same batch" part here is an example of the same batch... -
RE: UPDATE when the values are the same
Sergiy (8/26/2012)
You failed to explain how does it compare pages while the locks are applied to RID.It doesn't compare whole pages - that would be horribly inefficient. It knows...
-
RE: UPDATE when the values are the same
MissTippsInOz (8/27/2012)
I think an update where no update occurs can perhaps being thought of as a logical update. That is, as has already been said, locks are applied in... -
RE: Are the posted questions getting worse?
Fal (8/24/2012)
I need to deal with a critical issue, but unfortunately fixing it keeps getting bumped. I was wondering what metaphors Threadizens might have to describe just how low... -
RE: UPDATE when the values are the same
Sergiy (8/26/2012)
Was not so clear to me, as it turns out. Learned couple of things here, thanks to the good samaritans.Good. Well the last (important) thing to be...
-
RE: UPDATE when the values are the same
Sergiy (8/26/2012)
Where did you find "MDF", "HDD" and other stuff from your version of the question???OP's third post. http://www.sqlservercentral.com/Forums/FindPost1344046.aspx
-
RE: UPDATE when the values are the same
toddasd (8/24/2012)
This is why: http://xkcd.com/386/No it's not that. The original questioner has his answer, but educational opportunities remain in this thread.
-
RE: Tsql procedure to mutiple rows if it has duplicate id
ChrisM@Work (8/24/2012)
Try converting it to a read-only fast-forward cursor, and changeWHERE CURRENT OF reader
to an explicit UPDATE with a supporting index.
I didn't write it for performance (it's a cursor!)...
-
RE: Tsql procedure to mutiple rows if it has duplicate id
Luis Cazares (8/24/2012)
...the outer apply with EXP(SUM(LOG(value))) gave some unexpected results...Try it with zero or negative numbers in the 'val' column...
-
RE: Tsql procedure to mutiple rows if it has duplicate id
Luis Cazares (8/24/2012)
I'm curious. Why would you use a cursor?It's another option. Some people prefer them for some types of running totals problems pre-SQL Server 2012 (e.g. http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx).
I tend...
-
RE: Tsql procedure to mutiple rows if it has duplicate id
DECLARE @T AS TABLE
(
id integer NOT NULL,
value integer NOT NULL,
result ...
Viewing 15 posts - 331 through 345 (of 8,416 total)