LIKE queries are not useful in FULLTEXT indexes. You'd need queries to use CONTAINS or FREETEXT in the WHERE clause.

Best practice is to monitor space and add space before it is needed. Adding space can interfere with your workload and slow the server down. You also get fragmented files....

BWFC (2/18/2016)

---

To be pedantic, it depends on what edition you run the code. I know that the unwritten rule is assume the latest version but many people testing that,...

thisisfutile (2/17/2016)

---

I've been tempted to rely, 100%, on the "I forgot my password" links on more critical sites. They all send an email (and I have a very secure...

djj's solution works, whether you have more or less:

DECLARE @a VARCHAR(100)

SELECT @a = 'aaa'

SELECT LEFT(@a, 50)

SELECT @a = 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

SELECT LEFT(@a, 50)

However, if you truncate data, make sure clients know there...

On one hand, I'm glad I no longer code in C, on the other hand, lots of work available: http://arstechnica.com/security/2016/02/extremely-severe-bug-leaves-dizzying-number-of-apps-and-devices-vulnerable/

Gary Varga (2/16/2016)

---

Steve Jones - SSC Editor (2/16/2016)

---

...The other concern is what if there is a v2.0 branch in development that mirrors production. What prevents a developer from accidentally checking...

yes

jasona.work (2/16/2016)

---

So, saw Deadpool this weekend and I must say, it was really fun and quite funny.

They didn't overdo the "breaking the fourth wall" (if you're not familiar with the...

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...

Did you get the context of the job?

I tend to agree with you that there should be a central VCS and one set of code for an application/database. Branching when needed, but contained.

However, the person that talked...

I saw this from Patrick Keisler: http://www.patrickkeisler.com/2013/07/are-you-primary-replica.html

He's querying the role column for a 1, and while that shouldn't matter, I'm wondering if there is some context that's different. Obviously you...

What does the step do? If you log in to a console of the server as your proxy and execute the code in the step, what happens? Not the step,...

Orlando Colamatteo (2/13/2016)

---

Thanks for leaving out a bunch of steps to get to the eventual solution (like creating the cert and opening the key). Forced me to do a bit...