Generally, you prefer 10ms or less, although up to 20ms is ok. Anything over that is poor and progressively getting worse, of course.

Again, in general, 100ms is not acceptable,...

Yeah, I'm completely lost as to what the code is trying to code. And if the db is offline, you won't be able to access the view "sys.database_files" within...

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...