If you鈥檝e got performance troubles with an application that stores data in SQL Server, and especially if it鈥檚 a home-grown application (not a store-bought app), you can get dramatic performance improvements simply by focusing on some basic indexing techniques.聽 These tips and tricks pay off more than pouring money into hardware that might look good sitting in the datacenter, but doesn鈥檛 really make the application significantly faster.
When I go into a shop to speed up an application I鈥檝e never seen before, two of my favorite quick-hits are from the :
- 鈥� these are indexes the SQL Server engine says it鈥檚 not using.聽 Unused indexes incur a speed penalty because SQL Server still has to add/update the indexes as records change, so they make writes slower.
- 鈥� these are indexes SQL Server wishes it had available.
The above paragraph and information sounds good doesn鈥檛 it? Well guess what? They鈥檙e not my words, they鈥檙e Brent Ozar鈥檚 words from his article on . Now had I not mentioned that fact, would you think I wrote it? Well that is the meat of a hot topic that spawned today on Twitter in the SQL community. Apparently a young man who recently graduated college decided to open a blog focused on SQL Server, UNIX and Oracle. The problem lay in the fact that all the articles on his site were not his own. What this guy did was use an to point to prominent sites (such as , and amongst others) and so their content was then published on his blog. The big deal was that 1) He didn鈥檛 ask permission to republish their content and 2) He didn鈥檛 make it clear that the article you were reading was written by someone else. The ONLY credit given is a very tiny blurb on his 桃子视频 page that says 鈥渕aterials in this site has been collected from various sites and blogs and for that I thank them鈥�. Riiiiight, that鈥檚 not exactly proper citation. Given that this guy claims to also have gotten a Master鈥檚 degree, I would think at some point in his educational studies the mention of proper citation and what plagiarism is.
Upon learning of this site and its apparent violations, members of the SQL community who had their intellectual property infringed upon took action by leaving fairly straightforward messages on this about page informing him that he was in violation and needed to remove content immediately otherwise harsh actions could be taken. Within a relatively short period of time the author got the message (sort of) by removing the menu options on his site, yet the content still remains if you look for it. Due to this fact I expect notices to start flying shortly and if the blogger still fails to comply then his hosting company should drop the axe. What鈥檚 interesting about this situation is the conversation that was spawned afterward on Twitter.
Todd McDermid ( on Twitter) had the opinion that the SQL community reacted much harsher than we should have and blogged about it in his article . In his post Todd does bring up some good points in that perhaps the hardcore lynch mob approach was a bit rash and perhaps a gentle 鈥渉ey buddy, do you realize what you鈥檙e doing is stealing?鈥� might be a more diplomatic approach but the problem is that many of these guys in our community whom are prominent bloggers have been burned plenty in the past. Brent blogged on and in it described a situation (not first, definitely won鈥檛 be last) where someone decided stealing content was acceptable. Are the messages left on violater鈥檚 site that they have to take down content or face DMCA report the nicest? Maybe not. Is it a necessary evil because of the countless times these bloggers and authors have had to deal with this? Absolutely. Todd outlines that this particular case the blogger in question may be starting out and not know better but after a bachelor鈥檚 degree, master鈥檚 degree and reading the numerous blogs he鈥檚 aggregating (which incidentally have blogged before on just this topic) he should know better. One could argue about what exactly constitutes 鈥渃ommon sense鈥� in this right but I鈥檇 argue someone who has gone through a master鈥檚 program should be very well versed in the art of writing and proper citation.
Some would argue that “nobody lost out” by what this guy was doing but I would disagree. This is a violation of someone’s intellectual property. When you decide to blog on a technical level you are taking your time to help educate the masses. You’re putting in a lot of hard work into formulating something that is uniquely yours and sharing it. “But Jorge, this guy was just sharing FOR you (well not me because I’m not worth stealing from which is comforting on some level for the moment)”, yeah but he wasn’t making it clearly known that it was not his work. If someone has a SQL problem and they quickly Boogle out a question what if they come across the aggregator’s content before they get to yours (the source)? If the person needing a quick answer simply finds the answer on his blog and goes on his way, guess who gets credit for that? The thief. Sure this guy put a very tiny note in his about page but who is going to look in there when reading content? Now let’s take this up a notch. You’re on the job market and the prospective company (like many do) do a search for you on the internet to see what pops up. Imagine how good your word and reputation would be to them if they saw an entire community backlashing on you because you were knowingly stealing content? It’s not worth it!
So what does one do? Well you could ask the author for permission to repost content. For the record I asked Brent if I could borrow that first paragraph for this purpose (thanks Brent!). Or, and I know this is crazy, COME UP WITH YOUR OWN CONTENT! It’s not easy but it definitely pays off and in the end you get mad street cred *fist bump*. So don’t steal content, people work hard to produce this stuff and in the end you’re only going to make yourself look worse by pretending to be something you’re not.