Correct, indexes don't show up in sys.objects. You'll find indexes in sys.indexes (they're not considered objects like tables, procedures, constraints, etc are)

BLOB_EATER (9/21/2016)

---

Earlier in the year I applied for a PFE role which I didn't get but reached the last round. I was wondering if you guys think it would be...

I strongly recommend you reconsider the entire process.

Leave .net out, other than to call the stored procedure. Write the load process in T-SQL in a single batch. Do the same...

Please don't post multiple threads for the same question.

No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1819483-3740-1.aspx

As I said in the other thread, I would recommend you not use .net, not...

A million rows is not large, and processing row by row is inefficient.

Don't do it from .net (even slower), do whatever you need as a single transaction in T-SQL.

If...

No. TempDB uses existing files, they're just cleaned on a restart. It's only if the files aren't there that it will have to create and size them.

My favourite Friday shirt (not casual fridays, because every day is casual dress) is one that I got from the MS company store...

Phil Parkin (9/20/2016)

---

TomThomson (9/20/2016)

---

Phil Parkin (9/20/2016)

---

BrainDonor (9/20/2016)

---

New t-shirt for dress-down Fridays - https://www.amazon.com/Trend-Could-Thinking-Would-Great/dp/B01M0TJS26

But I don't know if I can - shouldn't the first full-stop be a comma? I think it...

I don't have time to rewrite it (and no DDL anyway), but the main performance problem there is the TOP (1) ... ORDER BY in the subquery.

Try changing the subquery...

The table name is specified as a parameter

That is horrible design and a security nightmare. Completely vulnerable to SQL Injection since no checks are done on the parameters. Terrible...

Mike Scalise (9/20/2016)

---

To me, it's the difference between the overhead to maintain a clustered index when rows are INSERTED/UPDATED vs the overhead to maintain the copy of the data (the...

Depends

Are you talking about separate VM drives which are just virtual hard drives on the same physical device? If so, no point (other than logical separation and easier space management).

VMs...

Mike Scalise (9/20/2016)

---

However, if I add only a non-clustered index with ID as the key, then the table becomes ordered, much like it would if I created a clustered index...

Mike Scalise (9/20/2016)

---

If I create a non-clustered index on ID and include the rest of the columns (first name, last name, and middle name), is that effectively the exact same...

That'll work.

You...