Why do you believe that slowness is related to the size of the data file and the...

sqlfriends (11/16/2015)

---

Hello, I would like to discuss a little about DBA path.

Other than server management, what other skills or path DBA should learn and prepare for future?

For example, skills like...

My solution would be to add a default constraint to get the current date on the column. With that in place, use a format file to insert values only in...

This will return the last five games for each team.

If you want to return the last five games for a single team, you can have a simpler approach (or approaches).

DECLARE...

There's a lot to be done. As you don't have nothing installed yet, I'll assume that you'll get the latest version available (2014). I strongly suggest that you read the...

Just to be clear.

MS Access, MS SQL Server, MySQL, PostgreSQL and others are different products to handle databases. They share similarities, but queries are written different for each one of...

Jeff Moden (11/14/2015)

---

GilaMonster (11/14/2015)

---

I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and...

GilaMonster (11/14/2015)

---

I am getting seriously tired of the lack of thought and understanding evidenced by recent questions from certain individuals. Is a little bit of independent work and research really...

What I posted doesn't use a function and it'll be the best way to do it. If you want to filter rows, you just change the condition to the WHERE...

You're lacking indexes on those tables. If we're talking about millions of rows, that will definitely be a problem.

Is this a question for a test? Why do you have restrictions? Why are you cheating?

RVO (11/13/2015)

---

Thanks Luis.

Without DISTINCT, row count is actually 20 billion something.

Maybe that's what Estimated Row counts show ?

To me if without DISTINCT query returns 20 billion records from 80...

For Q1:

You need to set different values for the Value and Label properties for your month attribute in the date dimension.

For Q2:

You need to build a hierarchy to be able...

Ed Wagner (11/13/2015)

---

Luis Cazares (11/13/2015)

---

hoseam (11/13/2015)

---

Hi

I have a column that has values [1,2,3....10,11,13,14 ...]

I want to return just two characters, e.g [01, 02, 03....10,11,12...]

I concatenated a string before to

'0'||CAST(m.d_depend...

Set your source as a query instead of a table, then use this:

SELECT ID,

Value,

CASE WHEN Value NOT LIKE '%[^0-9]%'...