ScottPletcher (1/13/2015)

---

You don't need to re-count the rows every time.

DECLARE @BatchSize int

DECLARE @RowRount int

DECLARE @TableRowCount int

DECLARE @TableRowLimit int

SET @BatchSize = 10000

SELECT @TableRowCount = COUNT(*)

FROM PtActs WITH (NOLOCK)

SET @TableRowLimit =...

Jeff Moden (1/12/2015)

---

curious_sqldba (1/12/2015)

---

I am trying to load data in batches on 10 K. The select statement at the bottom is taking about 60 % of the cost, is there...

Anyone ?

My apologies, should have specified this. We already have a in-house alerting system, i just need the syntax...

I want this to be scheduled so i can't use SSMS's feature .

Evil Kraig F (11/7/2014)

---

Keeping query tuning to the side is like asking to create a sentence without verbs.

Queries are what puts the pressure on systems. Knowing which queries hurt...

If you are given...

max_scalf (10/30/2014)

---

Hello all,

i am new to SQL Server and same goes for t-sql as well.

I am trying to write a simple procedure that does a backup, i understand there is...

ScottPletcher (10/17/2014)

---

With that many rows, you'll probably want to consider other, more efficient methods of comparing tables.

For example, change tracking would allow you to determine the rows in each table...

Are there any other reasons except maintenance overhead if I split my partitions to separate file group? Reason I say that is if I have multiple file groups I can...

GilaMonster (8/15/2014)

---

curious_sqldba (8/15/2014)

---

Ok, i have a application generating about 10,000 transactions read/write per hour. we have 50 + clients, should i partition per client ( data has to be separated)...

GilaMonster (8/15/2014)

---

10 000 an hour? Unless my log file's on a 3.5" floppy disk, I'm pretty...

SQLRNNR (8/15/2014)

---

curious_sqldba (8/15/2014)

---

Lets say you have database partitioned, all the transactions need to commit to same log file. In total there will be 10,000 commits per hour on the same...

Lets say you have database partitioned, all the transactions need to commit to same log file. In total there will be 10,000 commits per hour on the same log file,...

Makes sense. Thanks