tkacyndra (2/22/2011)

---

i have the following trigger.

basically, anytime i update a table, i need to copy the row to a history table and then do the update on the main...

Steve Jones - SSC Editor (2/22/2011)

---

On a similar debating note, does anyone know of code in SQL Server that's worth protecting with CLR, obfuscation, or any hassles of encrypting? Not...

Koen Verbeeck (2/22/2011)

---

Craig Farrell (2/22/2011)

---

Koen Verbeeck (2/22/2011)

---

Craig Farrell (2/22/2011)

---

I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

You create a foreach loop...

ken.trock (2/22/2011)

---

Select * From vExecutiveSummary, not that I'd ever do that :-D. Looks like the waittypes are CXPACKET. I'll get a better idea when some heavy user reports are run.

select...

Koen Verbeeck (2/22/2011)

---

Craig Farrell (2/22/2011)

---

I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

You create a foreach loop (the way that's built...

I assume you've dropped it to a Recordset Destination? The short answer is: you can't, not easily.

You create a foreach loop (the way that's built in to work with...

Rich Yarger (2/22/2011)

---

Let me clarify further - here is what I am thinking from your suggestion:

- min server memory / max server memory = 4gb

- Virtual Memory Partition...

MAXDOP set at the server is the default, not an override.

How are the problem queries being called, do you know the specific calls causing the issue (DBCC INPUTBUFFER), what are...

Dangit, you're right. ...

coder_t2 (2/21/2011)

---

Hey guys, I am interested in upgrading my current server's memory to 16GB and trying to load the entire DB into it. The database is currently about 16GB in...

Ever notice as soon as you close a window and start looking as something else little things seem to come back to you?

I believe this is what you're looking for...

Mike, I think you might have oversimplified your examples.

I'm assuming the real code doesn't PRINT the results, but does something with them. What would that be?

Deeby, can you post your actual code? It may have to do with your methodology.

If I'm right, you're getting something like the results of this:

SELECT 'abc' AS txt INTO...

Well, that's a new spelling... 🙂 ...

AJ-636201 (2/21/2011)

---

I have created only one clustered index and that is on FirstName column, and no other index has been created not even any non clustered index.

So is there...