TomThomson (7/25/2014)

---

Brandie Tarvin (7/23/2014)

---

Not to provoke debate (but I'm gonna anyway @=), I generally use surrogate Identity columns as singular, non-composite PKs because if I used natural composite keys, I'd...

peter 67432 (7/25/2014)

---

Hi Scott,

When I try to run the scripts I get:

'Online index operations can only be performed in Enterprise edition of SQL Server.'

Is there a way to do...

Lynn Pettis (7/24/2014)

---

One thing to remember about Oracle and SQL Server, they are not the same. The internals are different, and there for how the operate is different.

For example,...

Lowell (7/24/2014)

SELECT * From myTable

INNER JOIN MyLinkedServer.SandBox.dbo.AnotherTable myAlias

ON MyTable.ID = MyAlias.ID

WHERE myAlias.CustomerID = 12

looks pretty simple, right? with a WHERE statement that specific, i'd expect very few rows, since how...

mallikachowdhary 98955 (7/24/2014)

---

Hi ,

I have a issue regarding a query showing very late response on one server while it works perfectly on another.

I have a job defined in SQL server...

>> and restricted the log size to 30mb <<

That seems a little low, given that you might have a situation where one transaction takes a while to complete. Would...

You simply must get some answers to accurately resolve this:

1) What is the recovery model for your database? Bulk-logged, Full or Simple?

2) If not simple, at what time(s) during...

Igor Micev (7/23/2014)

---

ScottPletcher (7/23/2014)

---

I suspect there's a better clustering key, rather than the "default" identity, that might clear up a lot of your performance issues. Getting the best clustering...

And wishing you'd answered that matchbook ad for a technical school...

N_Muller (7/23/2014)

---

Transaction ID was not the best term - I guess I should have used Event ID :-). Event ID is naturally increasing, but there are many changes to...

N_Muller (7/23/2014)

---

Identity as a clustered index was not my first choice. The problem is that this is a high volume, high concurrency OLTP with thousands of data inserts per minute....

If you're willing to push back against the myth that identity should be default clustering key, and base the clustering key(s) choice on data instead, you can change the bolded...

I suspect there's a better clustering key, rather than the "default" identity, that might clear up a lot of your performance issues. Getting the best clustering key(s) is the...

I'd definitely restore and use the backup before I deleted the original files.

But rather than detach and delete the files yourself, just do a DROP DATABASE, which would be a...

It seems you do indeed have the proper clustering key.

Next I'd look at the missing index stats from SQL. You may be able to cover a large % of...