My reference to goof of the internet was for me, or anybody else for that matter.

Even with MVPS I retest their claims to make sure

#1 I understand what they...

Don't screw up the data.

If you screw up the data you need a backup.

This...

Convert to <var>char is a string manipulation. This is dependant on local settings such as langages, dateformat, datefirst, etc.

If you only do mathematical equation leaving the data in it's...

This works only on the indexes that need help :

http://sqlfool.com/2011/06/index-defrag-script-v4-1

Shrink the file ONCE. Then setup the job. If the log regrows leave it alone. It just...

What does this return?

SELECT log_reuse_wait_desc FROM sys.databases where name = 'your db name here'

No it tells you to do a RESTORE of your backups. The same thing we told you 50 times to do already.

You can't use only the logs to rebuild...

RSP (12/14/2011)

---

Wow - 3hours of video? Come on, I asked an opinion on a specific question. Why are you suggesting I sit to watch 3hours of video? ...

Never-ish :-D.

There's a plethora of reasons for it!

if you...

Whole MSBI ERP stack, which includes BI. 😉

Sure, if you had listened to those videos you wouldn't ask the question. :hehe: (how's that for summary).

There are 3 hours of video for a reason. This is...

GSquared (12/14/2011)

---

Koen Verbeeck (12/14/2011)

---

GSquared (12/14/2011)

---

Well, per the French scholars Goscinny and Uderzo, it was actually the ancient Gauls who used this method of settling certain disputes. Usually disputes over...

Dev (12/14/2011)

---

Ninja's_RGR'us (12/14/2011)

---

Who cares?

What do you LOVE to do. More...

Complete answer to that and way more =>

http://www.youtube.com/watch?v=RZ4YTg4S7HI&feature=plpp_video

http://www.youtube.com/watch?v=Kcnj5bQghjY&feature=plpp_video

http://www.youtube.com/watch?v=XmE_Utp8CY0&feature=plpp_video

Pork chops is a projectile thrown in the face of someone who uses cursors, rbar and other forms of bad sql.

Kind of a more efficient and longer distance fish face...