hemanth T (5/6/2011)

---

Hi All,

I met a scenario "When a coloumn of a table A is updated trigger should be performed like"AFTER UPDATE" and i need to insert values into table...

rootfixxxer (5/6/2011)

---

Thanks

Like i wrote i didn't had the time to optimize the function...

But the main problem here it's why in 2000 only takes 11 seconds and now in the 2005...

ok now i see it; 5 cursors are being executed for each row;sqlnaive hit it on the issue first; you've got to break it up, or change the logic to...

the devil is in the details.

Can you post the actual execution plan as a .sqlplan xml file, so we can look at it and identify what it's running so...

there's a huge amount of posts and submitted scripts here on SSC that do what you are asking for:

http://www.sqlservercentral.com/search/?q=script+roles+permissions

take a look at any of those and see if they do...

  is the html symbol for non breaking space.

the forum here will convert   into the html space...so you wouldn't see what i was talking about. i had...

you need at least one more column.. if i count everything in the table, there's just one value...in your example you said 680.

bit if you count...group by anothe rcolumn, i...

better:

Select * from TableA where col1 = ReverseOfSomeFunction(@VariableA)

Since the index is on col1, so it would be used and speed things up and would result in an index seek for...

this is a tough requirement,a nd will undoubtedly require multiple passes of SQLs and lots of code; there is no way you can do this in a simple, easy...

an HTML report ignores whitespace...so to handle that, you'd probably want to .Replace " ", "& n b s p ; " or with CHAR(160) which is a space in...

mutobo (5/5/2011)

---

Hi

I have read somewhere that is is possible to define a loopback linked server ( pointing to the same source db )

and use in auditing scenarios to modify data...

SQL stays in a single datatype when you are doing the math;

so when you do this portion of your formula:

8*1024*1024*1024, which are all integers, SQL assumes/shortcuts a decision that INT...

I'm hitting a lot of low hanging fruit today! I'll leave complicated PIVOTS and recursive CTE's to you, ok?

not sure, i'm not comfortable with teh UPDATE from a subselect, so i'd use this update statement instead:

UPDATE ADDRESS

SET ADDRESS_STATE_ID = s.STATE_ID

FROM zipcode z

...

DECIMAL (5,1) means 5 significant digits: 9999.9 is the max amount...so any value larger than that size will result in an arithmatic overflow error.

i typically always use the same decimal...