I can try to explain,

In the regular DBA job, we query our databases everyday.

If we use Natural Join, it is more concise, we write less.

We don't have to declare...

Why doesn't Microsoft SQL Server implement NATURAL JOIN?

It is in the SQL Standard.

I know it can be tricky (when fields have the same name such as DateUpdated), but it...

I found a post in another site that worked for me.

http://sqldbanotes.blogspot.com.br/2013/10/how-to-fix-failed-in-place.html

Thank you all,

Now I figure out better how I'm going to model my DW.

It is not the case of using linked measure groups, because the fact tables are in the...

Lowell,

I don't think it is a security issue. I am testing in my local machine, and my account runs the SQL Server. My account has permission to read the files.

My...

Lowell,

You SET the @provst variable two times, one following the other. Is this correct?

I supposed it was incorrect and changed the second to @provstr2. Where you write "text" is to...

Thank you Lowell,

Your script has helped me, but it doesn't bring what I want. If you make the INNER JOIN with the referenced_id, it just returns the dependencies that are...

Thank you both.

I didn't know the function IsNumeric. To my case I think it is enough.

The written function IsNumericEx can be very useful.

Best regards,

Lucas Benevides

DBA Cabuloso.

Thanks a lot.

The function IS_MEMBER is exactly what I needed.

Best Regards,

Lucas Benevides

DBA Cabuloso

The undocumented process told by Alexf works until the 2005 version, in the 2008 it does not work. This is because the Server Collation in 2008 can't change unless it...

It is going to be Active / Passive cluster.

The passive node is already present in the cluster, but the SQL Server isn't installed in this node, is only installed in...

First I want to thank you by the tip of the SSMS, I got it and could see the package.

But when I open the BIDS, in my solution explorer there...

Thanks George,

I will install it on my database server.

But if I want, can I host my reports on other IIS in another server, and let my IIS disabled on my...

Hello Gift Peddie,

This code you posted didn't work in the 64bit SQL Server 2005 on Windows 2003 Server, Service Pack 2. The error was

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has...

Which is the exact meaning of ESCAPE?

I thought it was to escape a wildcard that we would like to search. But the item didn't have any exclamation in the table,...