Sean Lange (3/28/2014)

---

Luis Cazares (3/28/2014)

---

I'm a developer/programmer/moroff/slave and for that reason, I wonder why people like to overcomplicate things if they have the tools available. Next thing, I'll hear about...

Luis Cazares (3/27/2014)

---

How is it possible that someone writes a cursor instead of using SUM()?

I'm afraid that this database is full of these pieces of sh code and it's slower...

kaththecoder (3/6/2014)

---

Hi

I need to write code so that I can get the number of chars in my field "heu_postmeta".

I wrote this...

SELECT LEN(`meta_value`) FROM `heu_postmeta`

Getting error "LEN" does not exist

Any...

And here is the English link.

http://technet.microsoft.com/en-us/library/ms187323.aspx

Is it possible that you have line breaks in query text when script is executed 2012?

Is there difference when pasting to excel for following query?

SELECT 'This is line 1.' +...

MyDoggieJessie (3/13/2014)

---

selvakumar.sms (3/13/2014)

---

I tried various possibilities,no luck...

here my small doubt i need IIS service in Server or i need to enable SMTP service in server ?

IIS and SMTP services are...

Have tried text import wizard?

I have to use it all the time, because Finnish decimal separator is , and I need to import all floats as text and convert all...

Ickier (3/3/2014)

SELECT DISTINCT A.KeyRightA -- int

, A.Status as a_status -- int

, B.KeyRightB -- int

...

Parallelism? Parameter sniffing?

I was able to workaround the issue by forcing spatial index usage.

This problem is interesting because it was only one query which is using this dynamic cursor. All other queries...

I like that we are heading to summer. There is still daylight left when I get back from work. I did not see much daylight for the last two months....

If I understood your question correctly, I think this blog post will have answers.

http://www.brentozar.com/archive/2014/01/dynamic-sorting/

Without analyzing deadlock info more I have a question.

Do you create cartesian join intentionally? There is no join to site table.

PaulB-TheOneAndOnly (1/20/2014)

---

Ville-Pekka Vahteala (1/16/2014)

---

Hi.

We are having performance problems on our server. We have found out that execution plans (attached) are very different when query is executed from SSMS and Oracle.

Does...

I am confused what is what.

Could you rewrite question so that you use terms like database login and domain username?