Eirikur Eiriksson (12/22/2015)

---

ScottPletcher (12/21/2015)

---

But if you put the N' when the column is not unicode, you'll force SQL to implicitly convert the column itself and that could be a real...

Yeah, everybody always "warns" about that, but who on earth would want to apply a 299GB log anyway??

joshdbguy (12/21/2015)

---

Sean Lange (12/21/2015)

---

From your description of the situation I would add a few columns to a table. As described this would be a 1:1 relationship which is really kind...

Eirikur Eiriksson (12/21/2015)

---

Talib123 (12/21/2015)

---

This query has issues due to the \.

If I use a Where = it works fine. How do I get around this small annoying issue.

SELECT name FROM...

First, verify that they've done a proper design to assign the columns to this table. That is, do not assume they've done that, verify that they've done it. ...

You also need to keep in mind that index usage stats count the number of times an operation occurs, not the quantity of rows affected. That is, "10 scans",...

I've got more servers than that, but I'd automate it for one server. I don't see time spent visually scanning a log file as particularly productive. Besides, what happens when...

I'd create indexes on all the columns you need to count that way. Then the COUNT query can use the existing indexes to give you a very quick totals.

If...

If you (almost) always look up by PartitionID and Name, then the table should be clustered first on those columns. If you really want/need to, add other columns to...

Once the db is changed to Simple model, it's easy enough to shrink the log, you just have to keep an eye on where the current end-of-file marker is, as...

It depends. It won't happen automatically. But if you can add code to SP_CHILD_1 and SP_CHILD_2 to end after that period of time, you could have the child...

Jeff Moden (12/15/2015)

---

ScottPletcher (12/14/2015)

---

Jeff Moden (12/12/2015)

---

ScottPletcher (12/10/2015)

---

Do you have a unique index on Word? You don't want SQL to have to sort the words every time -- that will...

Sergiy (12/14/2015)

---

Do developers really have the same...

They should have the same level of permission in a test environment that they do...

For Application Events. Stored proc parameters are not...