Viewing 15 posts - 1,786 through 1,800 (of 14,953 total)
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 30, 2012 at 8:14 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 30, 2012 at 7:46 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 30, 2012 at 6:21 am
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.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 2:17 pm
ColdCoffee (3/29/2012)
SELECT Tab.String
,NewStr = CASE WHEN LEFT(Tab.String,1) = '0' THEN STUFF (Tab.String,1, 1 , '' )
...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 2:16 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 2:10 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 2:05 pm
DECLARE @string VARCHAR(7) = '000123';
WHILE SUBSTRING(@string, 1, 1) = '0'
SET @string = STUFF(@string, 1, 1, '');
SELECT @string;
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 1:22 pm
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 11:23 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 10:06 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 6:49 am
Lynn Pettis (3/28/2012)
James Stover (3/28/2012)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 29, 2012 at 6:47 am
Koen Verbeeck (3/28/2012)
David Burrows (3/28/2012)
SQLRNNR (3/27/2012)
When did we start doing milestones for the 5k posts? I thought it was 10k.
A milestone is a milestone is a milestone, don't be...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2012 at 7:01 am
Sqlchicken (3/27/2012)
GSquared (3/27/2012)
Contact MS about it. That's all I can suggest on it that makes any sense to me.Completely off topic but MAN do I love your signature lol
Thanks.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2012 at 6:45 am
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...
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
March 28, 2012 at 6:43 am
Viewing 15 posts - 1,786 through 1,800 (of 14,953 total)