Discuss in the Community


Jason Strate
Follow /1 Sep 2014 at 4:00pm / SQL Server

September 2014 – SQL Server Monthly Maintenance Checklist

image source It’s time for a monthly reminder to review you SQL Server environment.  As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown element causing issues today or in the near...
35 0 /
Porus Homi Havewala
Follow /1 Sep 2014 at 2:49pm / Oracle

Managing Oracle Database 12c with Enterprise Manager – Part III

We are discussing the management of Oracle Database 12c in Oracle Enterprise Manager 12c. In our previous blog posts on this topic, we came to the Provision Pluggable Databases page as seen below. This is accessible via the Container Database Home Page...
35 0 /
Nakul Vachhrajani
Follow /1 Sep 2014 at 4:30am / SQL Server

#0344 – SQL Server – Missing Configuration Manager on Windows 8

Microsoft SQL Server comes with a very powerful  configuration manager which can be used to manage the SQL Server services and control network visibility and footprint. Working without the SQL Server Configuration Manager is a nightmare for a DBA. SQL...
25 0 /
Chris Webb
Follow /31 Aug 2014 at 11:45pm / SQL Server

This Is My 1000th Blog Post

Just a few months away from the tenth anniversary of my first post here, I’ve reached the milestone that is my 1000th blog post. If you’ve been with me since back then, thanks for reading! I have no idea how I managed to write so much – it’s an average...
39 0 /
Aris Prassinos
Follow /31 Aug 2014 at 8:39am / Oracle

Tracing Oracle Text queries

When troubleshooting query performance problems a common approach is to get a 10046 trace. In case of Oracle Text queries though this trace does not give much insight on where to concentrate any tuning efforts. For example, just by looking at the 10046...
49 0 /
Aris Prassinos
Follow /31 Aug 2014 at 7:20am / Oracle

Forecasting query elapsed time gains when caching Oracle Text indexes

A well known technique when using Oracle Text indexes is to preload them and pin them in the keep pool. There is a very good Oracle paper describing this: http://www.oracle.com/technetwork/database/enterprise-edition/mem-load-082296.html According...
45 0 /
Iggy Fernandez
Follow /30 Aug 2014 at 3:53am / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 19: Practice Exam IV

Previous installment: Practice Exam III First installment: DON’T PANIC The translation of a SQL statement into an efficient sequence of relational algebra operations is a tremendously complex task. The goal is to find the most efficient sequence...
326 0 /
Dan Hotka
Follow /30 Aug 2014 at 12:29am / Oracle

Oracle CBO and Clustering Factor: Picking the Right Index

Hi! There are several reasons Oracle CBO might not be picking the right index...have you checked the indexes clustering factor? Are your statistics up to date? This statistic is stored in [USER/ALL]_INDEXES. Clustering factor is the relationship...
48 0 /
Fernando Garcia
Follow /29 Aug 2014 at 10:40pm / Oracle

Iníciate en la ciencia de los datos con Oracle y SQL

El Big Data está entre nosotros y llegó para quedarse. Una pregunta que a veces me hago es: - ¿Qué volúmen de datos deberíamos estar manejando para considerarlo Big Data? Big Data puede tener distinto significado...
103 0 /
Larry Leonard
Follow /29 Aug 2014 at 7:26pm / SQL Server

CMS: Find, in All Servers and Databases, if given Table.Column's data is unique

Using CMS , we can determine if all the Customer.CustomerID values are unique, and therefore, for example, a candidate for being made a primary key. -- Find, in All Servers and Databases, if given Table.Column's data is unique. set nocount on if...
53 0 /
Larry Leonard
Follow /29 Aug 2014 at 6:40pm / SQL Server

CMS: Find all Databases on all Servers with Table "A" without Column "B"

This CMS ( Central Management Server ) code will tell you, for all databases in all servers, which tables of a given name don't have a column of a given name. -- For all databases in all servers that have a "Customer" table, which ones don't...
52 0 /
John Pertell
Follow /29 Aug 2014 at 5:24pm / SQL Server

Phantom FileTable Constraints

I was writing a wrap-up post to my series on FileTables when a co-worker found something interesting. SQL will insert a phantom FileTable constraint when you use SQL Server Management Studio to create a script of a non FileTable table that has a clustered...
59 0 /
Jason Strate
Follow /29 Aug 2014 at 5:00pm / SQL Server

Reblog: August 22 to August 28

Photo credit – Husso I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried...
42 0 /
Follow /29 Aug 2014 at 4:25pm / Oracle

Understanding Optimizer Statistics and Keeping Them Simple - Part 5

Last time, in Part 4 , I reviewed setting statistics collection parameters and the use of dbms_stats.set_*_prefs . In today's post, I will review the individual collection parameters and their values in more detail. Collection Parameters In order...
179 0 /
Kevin Kline
Follow /29 Aug 2014 at 1:35pm / SQL Server

Four New Slide Decks for SQL Server and IT Pros from the DevLink 2014 Conference

I always enjoy presenting at the DevLink conference, presented each summer in middle Tennessee.  This year, I’m trying to be a better social media person and actually post my slides (in their most recent forms) on my SlideShare account for everyone...
5276 0 /
Follow /29 Aug 2014 at 1:30pm / SQL Server

Get Ready to Learn SQL in an Interview with Dennis Still

I recently got to know Dennis through twitter and essentaiSQL.com.  If you’re non-technical, you’ll find this interview inspiring.  You too can learn SQL.  If you’re a techie or IT pro, Dennis provides great comments and insights on...
254 0 /
Tracy McKibben
Follow /29 Aug 2014 at 1:00pm / SQL Server

Friday Followup For August 29, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
128 0 /
Stuart Ainsworth
Follow /28 Aug 2014 at 10:55pm / SQL Server

What I Wished I’d Known Sooner As A DBA

Mike Walsh has put together an excellent topic for discussion , and I’ve read several responses to this; all of them are great, but most them are a little optimistic for my experiences.  I like to think that most of my friends and peers in the #sqlfamily...
44 0 /
Iggy Fernandez
Follow /28 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 18: Practice Exam III

Previous installment: Practice Exam II Next installment: Practice Exam IV First installment: DON’T PANIC Every time the optimizer chooses to join two data sets using the hash-join method, it has to decide which of the two data sets will be the...
257 0 /
Follow /28 Aug 2014 at 1:23pm / SQL Server

The Art of Performance Tuning

Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance...
68 0 /
Chris Yates
Follow /28 Aug 2014 at 1:04pm / SQL Server

What I Wish I Had Known Sooner…as a DBA

Yesterday I took a minute and to review some posts by some Data Professionals and in doing so I came across and article by Erin Stellato . She had been tagged by Mike Walsh  who posted an article regarding 4 Attitudes I Wish I Had Earlier as a DBA At...
81 0 /
Kendal Van Dyke
Follow /27 Aug 2014 at 7:13pm / SQL Server

Presenting At OPASS August 2014 Meeting On 8/28

Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS) . Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working...
52 0 /
Kellyn PotVin
Follow /27 Aug 2014 at 6:01pm / Oracle

The ALS Ice Bucket Challenge, the DBA Kevlar Way

I believe you do your best when you follow in what you believe. Kellyn’s # ALSIceBucketChallenge …. Hold the ice…:) https://www. youtube.com/watch?v=cawQjZ RCyok Tags: Del.icio.us Facebook ...
80 0 /
Iggy Fernandez
Follow /27 Aug 2014 at 5:00pm / Oracle

The Hitchhiker’s Guide to the EXPLAIN PLAN Part 17: Practice Exam II

Previous installment: Practice Exam I Next installment: Practice Exam III First installment: DON’T PANIC Here is the second practice exam. This time, we use the following hints in the query. Instead of the USE_NL hints that you saw in the previous...
186 0 /
Mike Walsh
Follow /27 Aug 2014 at 4:16pm / SQL Server

4 Attitudes I Wish I Had Earlier as a DBA

Empathy – I sorely lacked that early in my career. I was chatting about this with Tom LaRock because I linked to his great post about empathy in a post about stuff I learned working in the ambulance a few posts back. I’ve actually had about...
121 0 /