Rollbacks very often take more time than the initial modification. They are only very quick if all the pages are still in memory.

Are there nonclustered index(es) on the table?...

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

The optimizer can and often does (in my experience) introduce a SORT into the query plan on a small table to facilitate a merge join against a...

TheSQLGuru (8/31/2016)

---

The optimizer can and often does (in my experience) introduce a SORT into the query plan on a small table to facilitate a merge join against a larger table....

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key...

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on Column1...

TheSQLGuru (8/31/2016)

---

ScottPletcher (8/31/2016)

---

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on Column1 and a...

Tarun Jaggi (8/29/2016)

---

Hi All,

I have a table which has million rows and database is set under RCSI. The table has a clustered primary key on Column1 and a non-clustered index...

(1) not sure what that means.

(2) no. a table can have many nonclustered indexes.

(4) presumably they mean hierarchy ids, but can't tell for sure, the q is vague enough they...

Gregory Hart (8/29/2016)

---

The below is what I have used in the past to accomplish the need for a Scalar UDF in MS SQL:

IF OBJECT_ID('tempdb..##fn_CORP_Divide') IS NOT NULL DROP PROCEDURE ##fn_CORP_Divide;

CREATE...

I'd prefer to just add one day to the end date when needed. That seems much "cleaner" than dual 3ms adjustments:

SELECT

start_time, end_time, DATEDIFF(MINUTE, start_time,...

Add an extra join condition so you only get a single occurrence:

...

INNER JOIN (SELECT ConsumerID, ConsumerAccountID

FROM Consumer

WHERE ConsumerType = 'S') s ON p.ConsumerAccountID = s.ConsumerAccountID

AND...

Did you look at the code I posted?

Rather than literal strings of spaces, I recommend using SPACE(), just for readability:

/*CREATE FUNCTION ...*/

SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(LTRIM(RTRIM(@Text)),

SPACE(33), ' '),

SPACE(17), ' '),

SPACE(9),...

INSERT INTO dbo.TableA

( Sequence, Title, Signature, IsDefault, UserName )

SELECT A_Last.Sequence + B.row_num, A.Title, A.Signature, 'Y' AS IsDefault, B.UserName

FROM (

SELECT B2.*, ROW_NUMBER() OVER(ORDER BY B2.UserName) AS row_num

...

--