in cmdprompt

fltmc filters

in sql

xp_cmdshell 'fltmc filters'

I think for SQL, if using xp_cmdshell, the sqlserver service will need to be admin, but I may be wrong.

If we don't have schema information or indexing, a query or proc or something that will give us a hint as to what type of function you are using and...

http://sqlblog.com/blogs/rob_farley/archive/2011/04/13/the-power-of-t-sql-s-apply-operator.aspx

Show us the query please?

Have a look at the query plan created for the bulk insert.

There was or maybe still is, where a plan gets created with sort even though you not doing an...

When you say 'Bulk inserts' do you mean straight from file or table without doing any joins or filtering or sorting?

Bulk inserting into a clustered table or table with...

Beatrix Kiddo (11/27/2015)

---

There are much easier ways to do a restore! I can't tell from your script, but are you trying to move the file onto itself? (The reason I...

run sp_who or query sys.processes to see if anything is using the database.

check the code below and make sure that the file you are trying to overwrite belongs to the...

Any reason why it is being run in as an execute string?

does the bit below effectively make the left join an inner join?

b.srnumber BETWEEN 1 AND 100

Also, for anyone else who struggles to read unformatted sql.

SELECT

...

I have added the changes suggested, specifically excluding where the identity is included explicitly in indexes, as well as only returning indexes which contain the identity column.

It seems like the...

Thanks Scott, Will, Lee, Sean and BornReady for the effort in testing, critiquing and optimizing.

Some good ideas here and I will adapt the script as soon as.

The specific scenario...

Jeff Moden (11/21/2015)

---

The ultimate would be to find the queries using the tables and determining if there's a performance problem with those queries or not. I wrote my own...

I may not be helping fix this particular problem, but I had a look at the PS and the embedded sql and have difficulty reading it inside the PS.

How about...

I think to do partition switching you need all indexes to be partition aligned.