0
POPSEnabling Linked Servers While the code didn't really help me, it alerted me to the fact that you can now set these values for each linked server that you create. So I modified the properties of the Linked Server I was trying to use and all went well.
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
POPSData Size Converter SQL Server reports file sizes, space used and memory usage in varying increments. This handy little tool is going to help me translate between the different increments without having to think too hard about it.
0
POPSDBCC CACHESTATS One of my colleagues was using this. I had never come across it before. Thought I'd read up on it a little bit.
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
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