L' Eomot Inversé (6/11/2013)

---

Nice question that shows one of the less obvious pitfalls arising from implicit conversion. Pity the explanation doesn't explain why it works as it does. ...

Well, that is interesting!

Whoops - just realized I checked...

Louis Hillebrand (6/11/2013)

---

When I run the 2nd query it inserts 2 rows into the table.

So my answer would be 'error', '2 rows', '2 rows'.

If I remove the insert from...

Evil Kraig F (6/10/2013)

---

I don't argue with H.L. Mencken's philosophy, but noone ever got rich trying to make a spreadsheet software using a pac-man interface, either.

If you can't trust your...

Jeff Moden (6/10/2013)

---

Idiot's Razor: "If you make something idiot proof, only...

t2sqldba (6/9/2013)

---

All,

My problem scenarion is:

"I have a SQL agent job setup that calls a SP which collects all data and sends a report to some email ids via msdb.dbo.sp_send_dbmail.

The job...

bas de zwart (6/6/2013)

---

We've tried several options, but it really seems as if a dynamic 'use' statement can't be run inside SSMS2012.

We are considering the use of synonyms and...

Matthew Darwin (6/5/2013)

---

The elapsed time is per query, not cumulative. So the elapsed time is the ~1000 ms plus the ~660 ms; I'm guessing this is rounded up in...

dwain.c (6/5/2013)

---

Further poking around leads me to believe that the only accounts listed by the Config Mgr are Windows authenticated accounts, whereas 'myaccount' is a SQL authenticated account.

I'm wondering if...

dwain.c (6/5/2013)

---

Further poking around leads me to believe that the only accounts listed by the Config Mgr are Windows authenticated accounts, whereas 'myaccount' is a SQL authenticated account.

I'm wondering if...

I have the funny feeling that we have been here...

S_Kumar_S (6/3/2013)

---

HI

I have a table with 80 million records with PK on an int column. A service selects data from this table multiple times/sec in live environment.

I have to change...

SQLRNNR (6/4/2013)

---

Of course, they could be just figuring that you are their insurance policy - they are...

Brandie Tarvin (6/4/2013)

---

wolfkillj (6/3/2013)

---

I heard a great joke for nerds (I was about to call it "nerd joke", but it's for nerds, not about nerds) this weekend:

Why do computer science...

Greg Edwards-268690 (6/3/2013)

---

Maybe that's what they are saving - not having to define a name that means anything.

That could limit (or draw questions) if the field represents mulitple things.

And everyone...