Eric M Russell (8/15/2016)

---

When it comes to revceiving data feeds from external clients or 3rd party providers, it's best when an auto-certification process breaks the file transfer when the file...

Ham

Puzzle

Your errors come from the fact that you changed your CHAR column to integer. The concatenation needs to occur on string values when you're building your list, so try...

Nice article, David. Like Jeff pointed out, if people have an irrational fear of xp_cmdshell, what are they going to think about Bash? I don't have this fear...

If you don't have any backups, then you've got a much bigger potential problem on your hands than a lost job. You should define a backup strategy and implement...

Satiz (8/15/2016)

---

Hi experts,

I need a trigger script that will insert a record in Audit table when performing update ,delete operation in a that table.It must handle this by using temp...

That was a simple one, but casting is an important point. Date math is also very powerful when done right. Thanks.

ThomasRushton (8/15/2016)

---

Jeff Moden (8/15/2016)

---

ThomasRushton (8/15/2016)

---

ChrisM@Work (8/15/2016)

---

Someone was a little overzealous with spam removal over the weekend. On Saturday morning there was a new thread entitled something like “Hash match estimates...

Sweet

Please don't post the same basic question in multiple forums. It only fragments responses and spreads the discussion around so things get lost. Direct replies to http://www.sqlservercentral.com/Forums/Topic1809353-391-1.aspx.

I believe the coconuts were in Camelot. 😉

Definitely agree. jagjitsingh, pass your varchar parameter containing a delimited string, split it apart with DelimitedSplit8K and then use it...

Sean Lange (8/12/2016)

---

Wow the spam really is getting bold and stupid. We now have a spammer who added a spam rely to a previous spam from a different spammer. This...

Brandie Tarvin (8/11/2016)

---

TheSQLGuru (8/9/2016)

---

SQLJudo did a 30-day series on creating your own SSMS Add-in. Why don't you just build what you need (and then make a product out of it...