Greg Edwards-268690 (7/16/2015)

---

Sean Lange (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have...

reported as spam

kbadarinath (7/16/2015)

---

I would like to delete records from all tables which is older than 90 days. I know that stored procedure can perform this task. But is there a easy...

DBA From The Cold (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

DBA From The Cold (7/16/2015)

---

BrainDonor (7/16/2015)

---

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have suggestions as to how...

shirish_padekar (7/15/2015)

---

Hi,

We are using asp.net and all our database related codes are enclosed inside using() which takes care of closing/disposing the connections after operation is done:

using (SqlConnection connection = new...

shirish_padekar (7/15/2015)

---

Hi,

From last few days at times we are getting below errors:

1. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is...

scotsditch (7/14/2015)

---

Hi I have a text field which has entries of variable length of the form:

"house:app.apx&resultid=1234,clientip"

or

"tost:app.apx&resultid=123,clientip"

or

"airplane:app.apx&resultid=123489,clientip"

I'm trying to pick out the numbers between resultid='...',clientip no matter what the rest of...

robert.wiglesworth (7/14/2015)

---

Ok, thanks. That seems to work. But it seems complicated. Opinions on this please....

If I am able to edit how the records in this table get entered, should I...

MarkThornton (7/14/2015)

---

Dear Eirikur,

Thanks for the suggestion. However, I make extensive use of Redgate's SQL Server Source Control, which will only work on one instance of Management Studio at a...

Nice. I went there once in high school and it was so foggy you couldn't...

ctaylor 79909 (7/13/2015)

---

Thanks! Also, I saw the name Steve Jones as a moderator. Do you know if this is the same Steve Jones who was a TechIMO moderator...

ctaylor 79909 (7/13/2015)

---

SSChampion, that is really intesting (and bizarre) to me.

I inherited the SQL Server solution here and thought that when I read "as Timestamp" in the DML, that I...

sgmunson (7/13/2015)

---

Sean Lange (7/13/2015)

---

Plain and simple, you can't. The datatype is decimal, it stores decimal values. There is no decimal value that is the same as an empty string. This...

I don't think that the timestamp datatype is what you think it is. You should read up about it here. https://msdn.microsoft.com/en-us/library/ms182776.aspx

Please note that timestamp is an alias for ROWVERSION. It...

vs.satheesh (7/13/2015)

---

Hi

In my production server we have configured two separate instance.One default instance another one named instance.Whenever i try to login through named instance its connecting very fast.But...