1
POPSDBCC DROPCLEANBUFFERS I saw one of my colleagues using this procedure. I haven't used it myself, but I think I'm about to start experimenting with it. I think the part about executing a CHECKPOINT first makes sense.
1
POPSIndexes have their disadvantages I've seen a lot of people talk about the consumption of disk space with respect to indexes, but I don't remember seeing mention of how it could consume memory space. I believe that makes sense. And seeing how I'm fighting with memory right now, it makes me think twice about slapping yet another index on my tables.
0
POPSDesign queries using SHOWPLAN turned on Yeah, this makes a lot of sense to do. I hadn't thought of it like that before. I've found myself turning Execution Plan on when working on complex procedures, but I don't make it part of my regular habit. I think this practice will be good for me to start doing.
0
POPSTable Spool should alert you to a potential problem I was looking at a query plan today and saw a Table Spool icon. I had never seen one of those before. I thought that it might not be so great. I found this little bit of text on spooling data to work tables and thought it was interesting.
Newest Clips
see Newest Clips
Pops
Comments
Tags
1
Most Pops
Print
Save
Turn on live update