SQL Server provides a stored proc, "'sp_spaceused", to return space info. But annoyingly and frustratingly, it returns two separate result sets.

For my use, I cloned their proc, adjusting it...

Books should be more valuable than classes. Look for titles by Kalen Delaney particularly. For general SQL skills, look for Itzik Ben-Gan.

Shrinking the log file has absolutely no affect on the data indexes and their fragmentation. You would only need to check on index rebuilds if you shrink the data...

I suspect it's because SQL's internal processing does "ON" clauses before WHERE clauses.

Therefore, I think they figure the ON clause might eliminate rows sooner than a WHERE clause, and avoid...

Sean Lange (7/30/2014)

---

ScottPletcher (7/30/2014)

---

That's not true....

That's not true. The default...

matt6749 (7/28/2014)

---

One followup. (Hope I'm not annoying everybody):

With the Simple recovery model I'm using, would BEGIN TRANS and COMMIT statements help free up space in the log when used as...

All clustered keys must appear in all nonclustered indexes. If you don't explicitly specify them, SQL will add them automatically.

I explicitly specify them when the index function requires them,...

Yeah, would have to see the main SELECT to know how to adjust the code properly.

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