ThatJeffSmith

Tag: sql

Things to Keep in Mind for PASS 2013, Charlotte NC

So the news is out, Charlotte NC is a destination city! image courtesy Wikipedia 2012 Democratic Presidential Convention 2013 PASS Summit Already folks are wondering, hey, where is Charlotte? And, can I get good sushi there? Charlotte is a city I visit frequently. Here are a few things I’ve picked up along the way: It’s […]

Similar Posts by Subject Areas:

Are You Illiterate?

I know you can read, you’re here. But maybe you’re a functioning illiterate. Here’s what I mean. You spend a lot of time in the database writing queries, analyzing data, doing important stuff. Most of the time, things go great for you. You can answer questions for people. You make things happen. The wheels of […]

Similar Posts by Subject Areas: , , , ,

Killing in the Name

Do you take pleasure in killing peo…people’s sessions in the database? If so, you are not alone. If you have Blocking Locks, the easiest way to fix that is kill the offending session and free up the requested resource. But, who should win this battle? What transactions take precedence? Should the business analyst have his […]

Similar Posts by Subject Areas: , ,

SQL_IDs, Plans, and Baselines, Oh My!

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief. Many of the customers I speak with are unaware of a new 11g […]

Similar Posts by Subject Areas: , , , , ,

Is Your Query Running?

You better run and catch it then! You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is. I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before […]

Similar Posts by Subject Areas: , , , ,

Partitioning and DBMS_REDEFINITION

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I […]

Similar Posts by Subject Areas: , , , , ,

Access of Evil

A play on words – the Axis of Evil, three countries that foster or promote terrorism. This is not a history lesson or political discussion, go here for that. So what is the Access of Evil? I would propose that the following practices conspire to bring down any well-ordered collection of data: MS Access MS […]

Similar Posts by Subject Areas: , ,

Trailing or Leading Commas?

For me, it’s leading. If I have a code or syntax problem, I find it easier to see the line missing the comma if I can look at the first char position. Of course you may say that’s crazy, and any reasonable programmer would demand trailing commas. I’m guessing your IDE offers formatting options that […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,