Possibly a dumb question but would it be faster to do this on the application side?  Not sure how much data you are pulling (in MB/GB) if you just did...

If it is related to parameter sniffing problem (which it sounds like to me, but I also would not be surprised if I was WAY off on this), adding the...

One thought on how to "fix" this (based on the reply to the thread you indicated) would be to have that column returned inside a CASE statement where you could...

Anything interesting in the logs?  That is usually where I start all of my troubleshooting.  SQL Server logs as well as the Windows logs.  Never know where it may be...

I was doing some digging into this and best I can tell there is no way to do it without looking for a "\" in the ServerName field. And this...

I would recommend running a chkdsk on it (and DBCC once you get it online).  It could be that there was some corruption on the file/folder around permissions.  So when...

phpmyadmin, if I remember right, is an administration tool for PHP.  This, if I remember right, does not care about your database.  I think it can connect to a database,...

• This reply was modified 4 years, 10 months ago by Mr. Brian Gale.

OH... you want 1 contents.txt per directory.  That gets a bit more complicated, but still pretty easy in Powershell.  Basically, you will need to start by getting the directory list...

One thought (may not be possible) but what about using a windows account rather than a SQL account?

If that is not an option, SQLCMD can execute TSQL against a SQL...

It looks like you have the code already.  Just append "> Contents.txt" to the end of it.

If you don't want powershell, bat file can do it too with "dir /s...

It's all good!  Not sure if I've been mistaken for Pietlinden before, but I know my opinions on query hints are that they should be avoided.

And I agree about getting...

I can't speak on how ETL developer compares to SQL Developer in terms of level.  They are 2 different roles from my understanding.

The benefit of branching out is you get...

My opinion with regards to performance - test it out!

In theory, one method may be faster than the other.  In practice, this can surprise you.  Sometimes the statistics and indexes...

Without having sample data, it is tricky to say for certain, but as a thought - would a DISTINCT on your SELECT help?

If not, could you provide some DDL and...

Scott - I am not sure if you saw my most recent reply where I basically retracted my previous statements on NOLOCK.  It was a bit of a ramble and...