So Gail, in this scenario we have 1 case that just terminates the statement (divide by zero error) and one that terminates the batch (error converting varchar to int), am...

GilaMonster (4/25/2012)

---

SQLKnowItAll (4/25/2012)

---

S_Kumar_S (4/25/2012)

---

Hi

The sample code is at bottom. I have introduced 2 erros in the proc. Both are level 16 errors. I was expecting that the insert statements after...

This code with the variable set as 'TST2' is essentially doing this:

SELECT Col5

,Col6

,Col7

FROM table

WHERE Col7 = 'A'

AND Col6 = 'S'

AND Col2 = 0 --kind of, your syntax is wrong

Not to...

S_Kumar_S (4/25/2012)

---

Hi

The sample code is at bottom. I have introduced 2 erros in the proc. Both are level 16 errors. I was expecting that the insert statements after error generating...

You say you have indexes, but do you know if they are

1. being used?

2. selective enough for the filter parameter to make a difference?

Hehehehe... I certainly don't! Of course, that's what makes it a clever name for my blog. Anyone want to buy it?...

Not going to have fragmentation when the clustered index is on an identity column after the data has been truncated.

They should. That's why I was asking about other non-clustered indexes. You should not have to reindex, but if you have doubs you can simply look at the...

How much data? Is the non-clustered index going to change to be on the identity or is it on a column that is not ordered? How is the data loaded?

I know this is a 2008 forum, but I thought it worth mentioning that there are now wonderful window functions in 2012 that make this nice and easy.

Variant of what...

Sapen (4/24/2012)

---

Hi Everyone,

Hope all is well.

I have noticed the following error around 5:00AM this morning on our SQL Server staging environment.

A significant part of sql server process memory has been...

Geoff A (4/24/2012)

---

SQLKnowItAll (4/24/2012)

---

Duran (4/24/2012)

---

Hello everyone,

I would like to set up some alerts on my SQL server 2008 machine, and I was wondering if there were any specific ones that...

GilaMonster (4/24/2012)

---

SQLKnowItAll (4/24/2012)

---

I assume that since you said 19 and higher, but then specifically 825 that it is not...

I assume that since you said 19 and higher, but then specifically 825 that it is not included for...

Duran (4/24/2012)

---

Hello everyone,

I would like to set up some alerts on my SQL server 2008 machine, and I was wondering if there were any specific ones that would be good...