Hi jayarora,

No, I wouldn't expect a junior SQL Developer to know Hadoop.

You mention you're a newbie in the field of SQL development. If you're expected to write T-SQL in your...

Replacing SELECT * with a list of the columns you want to return would usually improve performance (unless you listed every column), but in this case it has no effect....

You're correct, the report .rdl files are stored in the Content column of ReportServer.dbo.Catalog. None of our few SSRS deployments have .rdl files stored in folders on their drives, and...

Hi deubel_m,

I was also surprised to see this bug. This has been confirmed by Microsoft and a fix is on the way (no ETA has been stated). Note that...

Hi Sam,

It doesn't look like there's much room to maneuver here. I don't have experience with heap fragmentation, and would love to hear if defragmenting the table solves the performance...

• This reply was modified 5 years, 3 months ago by  Andrew P.

According to CalculateMe.com the length of a mile is 0.00018939394 feet.

The SSRS expression to do this is:

=Fields!PipeLen.Value * 0.00018939394

Best,

Andrew

The documentation for the all_objects catalog view states that it shows all schema-scoped user-defined objects and system objects. Database-scoped objects that aren't within a specific schema are not included...

Hi michael.leach2015,

I believe only tables in a user's default schema can be referenced without stating the schema name.

Try including the schema of the Employee table reference, as below.

            
August 3, 2019 at 7:37 am
            
#3668453

            
            
                                                
        

Hi vsamantha35,

This thread appears to be a parallel conversation to this one on TechNet.

I'm not familiar with the TO_CHAR (...) function, however a Google search has returned that this...

Hi kumararan22,

There are a few possible causes for the installer to be unable to download a required installation file with that error. Check if your workstation's time and date are...

Hi johnzabroski,

Somewhat sadly, I haven't had the same experience with our SSRS 2017 installation. Our production SSRS instance is pretty busy and has remained steady for over a year. We'd...

Hi aferhough,

Welcome to the forum!

Could you describe what this query will be used for, is this for a homework assignment?

It would also be real...

Hi Sam,

I'd like to see a proper, methodological approach to investigating this as well, I'll be watching this thread 🙂. Here's what I would do.

I...

Thanks for the replies. The "Country > Region > City >Suburb" hierarchy was a simplistic example of the dilemma I was facing. In the specific situation I'm working with the table...

No worries. If you find further differences between your code samples and the database schema then you may have better success with AdventureWorksDW2008R2 here, which appears to be...