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...
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...
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...
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). ...
July 11, 2011 at 6:25 am
SQLkiwi (7/8/2011)
--- never mind ---
Neverminding.
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...
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...
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...
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...
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...
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. ...
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!...
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.
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...
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....
July 5, 2011 at 2:42 pm
Viewing 15 posts - 3,811 through 3,825 (of 14,953 total)