I'm glad you were able to successfully do what needed to be done, but I wouldn't recommend making a habit of just making changes like this in production. You...

You need to Enable a network protocol to allow connectiosn to the SQL Server. Here's an article on how to do it, http://msdn.microsoft.com/en-us/library/ms191294.aspx. If that doesn't work you...

I think you really want to change your query. Your actual file sizes shouldn't change on a daily basis, but the space used by the files could and should...

Since all the conditions in the WHERE clause of the NOT EXISTS query are OR'd together it only takes one of the criteria to match in order to get a...

Shawn Melton (10/17/2014)

---

I have seen one setup, although is a bit of a hack, is to add code at the end of the procedure that returns the data in the...

A server-side trace has minimal impact and would be the way I'd recommend going about it on SQL 2005.

All DDL triggers, including LOGON triggers are AFTER triggers, so changing from...

There's no easy way to do it. What I've done, and it is a hack, is create a different SQL Agent job where step 1 checks for data from...

Looks like google is having a problem with "19900101..99991231". If you remove that the search works. Don't know why, but that seems to be the issue.

You need to tell sp_executesql that @outDupCheck is an output parameter as well. So your query needs to look that this:

EXECUTE sp_executesql @sqlStr, @ParmDefinition, @strAccount = @parmINAccount, @intHospital...

Because FLOAT is not precise, it could actually be stored as 9956.587499999, and is displaying 9956.5875 so ROUND would leave it at .587 not rounding up to .588

TomThomson (10/15/2014)

---

Luis Cazares (10/14/2014)

---

In an unrelated topic, have you ever seen a code and want to vomit but after formatting it you just want to cry? I really can't understand...

Without knowing what tables are involved it is hard to give you a complete answer, if you were to post your question using the guidelines in the top link in...

Luis Cazares (10/14/2014)

---

In an unrelated topic, have you ever seen a code and want to vomit but after formatting it you just want to cry? I really can't understand how...

Steve Jones - SSC Editor (10/14/2014)

---

Thanks, a couple updates.

We implemented ASKIMET for posts. This took effect today and shouldn't slow things down, but we are evaluating and discarding SPAM posts....

How have you identified that this insert is the cause of the high CPU condition?

Based on this limited information, unless there is a trigger or triggers, a singleton insert doesn't...