Eric M Russell (9/13/2016)

---

ChrisM@Work (9/13/2016)

---

Eric M Russell (9/12/2016)

---

4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will...

Jeff Moden (9/13/2016)

---

Curious... isn't that just moving the problem to something else? You still have to...

Eric M Russell (9/12/2016)

---

4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need to remain online...

ashishkumarrai (9/13/2016)

---

ChrisM@Work (9/13/2016)

---

ashishkumarrai (9/13/2016)

---

ChrisM@Work (9/9/2016)

---

This should be a step in the right direction:

DROP TABLE #Buckets

CREATE TABLE #Buckets (bucketID INT, FullCapacity INT, CurrentAmount INT);

INSERT INTO #Buckets

VALUES ( '1', 85, 0...

ashishkumarrai (9/13/2016)

---

ChrisM@Work (9/9/2016)

---

This should be a step in the right direction:

DROP TABLE #Buckets

CREATE TABLE #Buckets (bucketID INT, FullCapacity INT, CurrentAmount INT);

INSERT INTO #Buckets

VALUES ( '1', 85, 0 ) ,

...

sqld-_-ba (9/10/2016)

---

nevermind, just thought of workaround - I can insert record into table and then check rowcount

insert into #tmp select

top 1 1 FROM CHANGETABLE(CHANGES dbo.UserPrefs, @last_sync_version) AS ct

WHERE...

TheSQLGuru (9/12/2016)

---

ChrisM@Work (9/12/2016)

---

From memory Phil, if you explicitly...

From memory Phil, if you explicitly drop the...

The Dixie Flatline (9/12/2016)

---

When you join two tables, the optimizer should know which one is the smaller. It doesn't have to follow the sequence in which the tables...

We use this method quite a lot for breaking down processing queries running in production, so that the number of rows processed is low enough to avoid locks escalating to...

First, simplify your query. Second, split it into two different queries. The execution plan for a single orderID is unlikely to be the same as the execution plan for them...

This should be a step in the right direction:

DROP TABLE #Buckets

CREATE TABLE #Buckets (bucketID INT, FullCapacity INT, CurrentAmount INT);

INSERT INTO #Buckets

VALUES ( '1', 85, 0 ) ,

...

Gregory Hart (9/8/2016)

---

OK, ... let this post/thread be a lesson to all you "know-it-all" experts. Lessons learned:

Not all UDF are bad, ... if correctly written, they can be tremendous for...

Chitown (9/8/2016)

---

Expert, I am working on scheduling a job which runs every 10 minutes and kill any active session (which is active for more than 10 minutes) from a specific...

Reported as spam.