Viewing 15 posts - 3,811 through 3,825 (of 14,953 total)
IceDread (7/11/2011)
However, having said that, it does not offer much if the new users rights is not properly limited.
If...
- 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
July 11, 2011 at 8:19 am
If the only problem were boredom, I'd say stay with the current job and work on honing your skills and knowledge during your "downtime". The primary duty of a...
- 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
July 11, 2011 at 8:12 am
It's pretty usual to end up with scans when you have OR statements in the Where clause.
There can be other reasons for them, including the selectivity of the leading edge...
- 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
July 11, 2011 at 8:04 am
Second the motion on getting rid of both steps. They kill performance, break your backup chain (no point-in-time recovery), and cause physical file fragmentation on the hard drive(s). ...
- 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
July 11, 2011 at 6:25 am
SQLkiwi (7/8/2011)
--- never mind ---
Neverminding.
- 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
July 11, 2011 at 6:20 am
You can accomplish much of this through federated databases queried through a central "master server" (essentially, it's your load ballancer).
This isn't necessarily easy to do, and you can end up...
- 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
July 8, 2011 at 6:31 am
Why do you need to figure out a different method of getting what you want? If the data you need is best provided to you by means of 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
July 8, 2011 at 6:27 am
It depends entirely on your business needs.
Will you ever need to roll data back more than 2 days?
Do you test restoring your backups every day?
What would happen if you lost...
- 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
July 7, 2011 at 2:02 pm
Different stats in different databases.
Without a Where clause specific to those columns, it's going to have to do an index scan, either clustered or non-clustered, to get all the data...
- 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
July 7, 2011 at 11:22 am
The structure I'd use for this would be a Materials table, and a separate hierarchies table.
So, a Raven battleship would be listed as a "Material". It would be the...
- 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
July 7, 2011 at 9:33 am
ALZDBA (7/7/2011)
Jeff Moden (7/7/2011)
ALZDBA (7/3/2011)
It's great to see many of SSC addicts have been granted MVP once more.Congratulations to you all.
Dang... I missed this one on the first pass. ...
- 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
July 7, 2011 at 6:44 am
Fal (7/6/2011)
anyone with a minor dose of manners and a sense of humor is invited.
Please, kind Ladies and Gents, will you indulge me in a joke?
"Knock knock..."
Come on in!...
- 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
July 6, 2011 at 6:50 am
Actually, converting it to a star/snowflake schema makes all kinds of sense to me, if it's not primarily OLTP in nature. That's a good idea.
- 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
July 6, 2011 at 6:46 am
The only real solution I've seen to the 100k articles thing, is a wiki. Then you have one article on the subject. But the quality and accuracy is...
- 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
July 6, 2011 at 6:42 am
What you're seeing is the usual point of diminishing returns.
For most people, the greatest returns from a site like SSC will start with asking for specific help on specific questions....
- 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
July 5, 2011 at 2:42 pm
Viewing 15 posts - 3,811 through 3,825 (of 14,953 total)