What I'd focus on is any and all automated tasks and any and all regular manual tasks they do.

Do they have scheduled backups?

Do they test them regularly? Automated or...

There's data about online index operations here: http://msdn.microsoft.com/en-us/library/ms191261.aspx

Specifics about an online rebuild are here: http://msdn.microsoft.com/en-us/library/ms188388.aspx

It specifically says:

ONLINE = { ON | OFF }

Specifies whether underlying tables and associated indexes...

Makes sense.

All the questions you listed would be dev/performance tuning. The performance tuning and monitoring part of it is usually a DB Admin task. But, as usual, most...

You don't actually need the case statement:

SELECT STUFF(Y, 1, PATINDEX('%[^0]%', Y)-1, '')

FROM (VALUES('123'),('0123'),('000123')) AS X(Y);

Works just fine.

ColdCoffee (3/29/2012)

---

THis?

SELECT Tab.String

,NewStr = CASE WHEN LEFT(Tab.String,1) = '0' THEN STUFF (Tab.String,1, 1 , '' )

...

Either a DDL trigger that sends you an alert, or a "DBA" database that can be used to log things like "have I set up maintenance plans and backups for...

Schema Binding is pretty specific, and not that common a concept. It's got it's uses, mainly in high-end performance-tuning, but I wouldn't consider that a pass/fail question on an...

DECLARE @string VARCHAR(7) = '000123';

WHILE SUBSTRING(@string, 1, 1) = '0'

SET @string = STUFF(@string, 1, 1, '');

SELECT @string;

If you need the top value per company, then Max and Group By is the way to go. If you simply need the highest value (ties?) then Top 1...

It'll depend on the local market. I make about the national average for a DBA with my level of experience, but I live in an area with less than...

I don't have any DBA certs/degrees/whatever either. Been one successfully for over 10 years now. Get paid a lot for it, too.

The people forbidding temp tables probably just...

Lynn Pettis (3/28/2012)

---

James Stover (3/28/2012)

---

Computer science isn't dead, but the way it's taught probably is. By the time you finish a four-year degree in CompSci, much of what you learned...

Koen Verbeeck (3/28/2012)

---

David Burrows (3/28/2012)

---

A milestone is a milestone is a milestone, don't be...

Thanks.

True, if you add in Jeff's optimizations for the splitter portion, the CTEs part will be even faster. Can't hurt.

I use a CLR splitter these days, so forgot about...