ashwan (6/23/2016)

---

let say there is a DB with large update frequently . In this situation all select statements are waiting for new update. ? why Select statements do not...

It won't return the currently updating data if it's selected by the SELECT query.

If you use hint (NOLOCK) for...

What is the isolation level?

Do you use any hints (e.g. NOLOCK)?

You can do the same with the Generate scripts action on right-click on the database, filtering the objects and properties you...

You can write similar form of it and put...

It's an easy task. You must first eliminate the duplicate rows and then make the SUM-ing.

According to your sample data, it should be somthing like this

with SampleTable as

(

select

[Format],[Response],...

Your script is not good enough.

Running it, resulted with the following error messages:

(2 row(s) affected)

[font="Courier New"]Msg 6107, Level 14, State 1, Line 1

Only user processes can be killed.

Msg 6104, Level...

The LAG function is aimed for those kind of problems like yours. Have you saved you query using LAG, if so share it here. Someone may find a better solution...

It's a big percentage for such a question (very internal one). Many...

TomThomson (6/17/2016)

---

Igor Micev (6/17/2016)

---

Those are the checkpoints in SQL Server 2012 and 2014 as well. The difference with SQL Server 2016 is that in 2016 the Indirect type is by...

To be clear, you can use the trigger_nestlevel() function - https://msdn.microsoft.com/en-us/library/ms182737.aspx

It's aimed for triggers.

Those are the checkpoints in SQL Server 2012 and 2014 as well. The difference with SQL Server 2016 is that in 2016 the Indirect type is by default set on...

That's why Gail advised you to decrease it...

Hi,

This could help you

SELECT strVal, STUFF(

STUFF(strVal+'c', PATINDEX('%[0-9][^0-9.]%', strVal+'c')+1, LEN(strVal), ''),

1, PATINDEX('%[0-9]%', strVal)-1, ''

) AS [decimal]

FROM(VALUES( 'MG' ), ( 'MG/5ML' ), ( 'MCG/0.5ML' ), ( 'MG/ML' ),...

Rio