Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my shot in the dark...

This thread has taken a wild turn recently. Let's all try to remember that at SSC we pride ourselves on being professional and not making personal attacks. That is what...

Luis Cazares (2/12/2016)

---

http://www.sqlservercentral.com/Forums/Topic1760779-2799-1.aspx

I was going to comment on that thread, but I got lost...

Here is a great article discussing the shortcoming of the INFORMATION_SCHEMA views. http://sqlblog.com/blogs/aaron_bertrand/archive/2011/11/03/the-case-against-information-schema-views.aspx

Brandie Tarvin (2/12/2016)

---

Thank you backup, Sean. I'm still shaking my head over the OPs initial "you're wrong, that can't be done after all" and then "Well, prove it" responses.

EDIT: I...

Luis Cazares (2/12/2016)

---

djj (2/12/2016)

---

My comment also. I was thinking you...

mw112009 (2/12/2016)

---

Well then can you be kind enough to share that code with us please ?

If you are not willing that is fine. No hard feelings!

Have a great day!

BTW...

I read that as there is a gap of 4 hours with transaction log backups between 8pm and midnight each day. I don't understand from the question how there is...

MSSQLBuddy (2/11/2016)

---

Hi Team,

One of my colleague dropped and created the default login account to SQL Server. Now the login account has only public access. I am not sure of...

Thirded. It was a...

Indeed!!

Simple to remove these functions and add some range logic.

Select j.mdoc_no

, j.doc_no

, j.doc_dt

, j.del_dt

from jcdtl...

itsgaurav (2/11/2016)

---

My sql server database ldf file size is too much from mdf file approx 1 gb. How I can reduce this.

Even I set recovery model simple.

And using sql...

itsgaurav (2/11/2016)

---

Is sql function such as Month, Year or day sucks the query performance if we use these in where clause.

If yes please suggest an alternative options???

I am using sql...

Michael L John (2/11/2016)

---

Sean Lange (2/11/2016)

---

Michael L John (2/11/2016)

---

Sean Lange (2/11/2016)

---

Grumpy DBA (2/11/2016)

---

Sean Lange (2/11/2016)

---

Back in the late 80's early 90's when mix tapes were the thing I had a...