0
POPSSort Warnings I'm pretty sure I've seen plenty of these before also. Mostly I've only used up to 4 columns in a sort, so I have a feeling that RAM is better option.
0
POPSComparison Operators I don't even know why I was trying to do =<... I guess it's because I'm used to using BETWEEN more than <= >=. At any rate, this may come in handy in the future.
0
POPSUsing stored procedures to submit events to NS So based on what the tutorial is saying, I'd assume that it would be possible to have event data sent to the NS application from another database using DTS or a replication publication. It seems likely that you could also use a Message Queuing application to insert event data.
0
POPSBCP Utility I haven't used this tool in years. However, dealing with this DSS system that I'm working on has necessitated the use of the bcp utility as I'm moving about 20 GB worth of data to create a new table... It would have taken hours and probably would have filled the transaction log had I not used bcp.
0
POPSOracle RAC Overview Oracle RAC technology sounds pretty cool. I've worked with Microsoft SQL Server clusters before, but never with Oracle. I'm interested in learning more, especially since it's looking like I'll need to deal with Oracle a lot more in my next job. :-)
0
POPSSet-based way of determining databases' writeability I'm writing a script that will help me "port" privileges for Windows security accounts of one domain over to equivalent accounts on a different domain. You must first check to see whether any affected databases are read-only. If they are, you must take them out of read-only mode, first, before you revoke or grant any privileges to the database. I am using this procedure to figure out which databases are read-only.
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.
0
POPSMoving the tempdb database While trying to optimize the performance of some data loads on one of our QA database servers, I decided to move the tempdb to a different disk array hoping that would improve the time it takes to assemble the large set of records to be inserted into a denormalized table. This clip contains the information I used to move the database.
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.
Latest Pops
see Latest Pops
by Osolage 
Clips
Comments
Tags
1
Most Pops
Print
Save
Turn on live update