Hugo Kornelis (1/18/2016)

---

For recoverability, I do recommend strongly against combining data file and transaction log for the same database on the same (physical) disk. If a disk is lost and...

Pick the correct data type for the data, have a FillFactor that's not 100%, and make sure that you don't have the coding pattern of inserting 'empty' rows and then...

No.

A sysadmin has all rights within an instance and cannot be stopped from doing anything they want. If you want to restrict access, host the DB yourself and give out...

I had that question in a class I was teaching last week. Even with an Integer, you can insert 1 row a second, every second, for 81 years before you'll...

Here it is, was easy enough to find from google with the title.

https://msdn.microsoft.com/en-us/library/bb283630.aspx

You don't need to update statistics. A freshly built index will have up to date stats already.

Changing parameter values within a procedure is a really bad idea.

https://www.simple-talk.com/content/article.aspx?article=2280

http://sqlinthewild.co.za/index.php/2009/02/09/all-indexes-are-unique/

I already answered that

GilaMonster (1/14/2016)

---

find whatever MySQL function lets you take substrings and use...

CASE WHEN <Condition 1> AND <Condition 2> AND <Condition 3>......

Go into the maintenance plan/job and enable detailed logging. All you're showing are high level messages and none say anything useful.

SQLRNNR (1/14/2016)

---

GilaMonster (1/14/2016)

---

Alvin Ramard (1/14/2016)

---

GilaMonster (1/14/2016)

---

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if...

Alvin Ramard (1/14/2016)

---

GilaMonster (1/14/2016)

---

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks...

He's asking MySQL questions on a SQL Server site and appears to be about at the level of spelling 'SQL'. I won't be surprised if he asks "What's a backup?"

Restore a backup you took before the update.

Or, find whatever MySQL function lets you take substrings and use that to remove the last 4 characters.