http://msdn.microsoft.com/en-us/library/ms187752.aspx

jerry209 (4/6/2012)

---

SQL Query returns the following values

ItemId IsProduced

101 1

102 ...

A lean Sql Trace definition should fetch you the TSql run against the database.

Why you would want to capture output is one I don't quite understand...

Assuming a script returns a...

...and just to show how ill-suited sql can sometimes be for string manipulation here is a C# snippet with a purpose built function that can be used to do the...

nhimabindhu (3/28/2012)

---

Hi i created a procedure for inserting data into table when i passing values as parameter for date column it is showing error.can u please help any one.

CREATE PROCEDURE...

I think you might want to post the execution plan as well.

I don't think there is an argument to be made here either way.

SSMS, for the company, is a no cost option if they have valid Sql Server Licences. It...

Gianluca Sartori (3/14/2012)

---

50 instances? Are you joking?

I've never heard of anyone hitting the instances limit. :w00t:

50 is the maximum number of inctances you can install on a standalone server. http://msdn.microsoft.com/en-us/library/ms143432.aspx

For...

Is it something you can share?

eriks4j (3/11/2012)

---

Tnx all for your help and constructive criticisms. I have actually successfully ran the installation couple of times after taking on board the suggestions. But this time the Database...

sqlservant (3/9/2012)

---

Okay, well thank you for your advise.

This was just an example, I put in the names for some clarity, I guess it didn't work.

I was really just interested in...

Looks like I got beaten to it 🙂

No sample or test data so can't test so maybe something like...

SELECT *, COUNT(*) OVER (PARTITION BY [column_name]) AS prt FROM CLDHIST;

Are you able to post Execution Plans?

Eugene Elutin (3/8/2012)

---

OTF (3/8/2012)

---

Eugene Elutin (3/7/2012)

---

It's not a good design to email from a trigger. You're killing performance of update. If I would be MS i would not allow to...