|
IMHO
If you are / have access to competent DB developers (i.e. you can write or have written good SQL stored procedures, can debug them and, if necessary, measure and tweak performance) then stored procedures are the way to go.
If you are scared of SQL, or are crap at it, have no idea what is efficient or not, can manage a quick select or insert butr quake at the sight of anything more complex, then you might be more comfortable writing C# or VB rather than SQL and let LINQ to SQL manage the SQL code for you.
I am with you on the SP front - I much prefer the separation of concerns - I can have my .Net devs write against what is to essentially an interface, and my DB developers concentrate on the DB.
IF a SP is inefficient, I can tinker with it, and test it independently of any .Net code, and redeploy it without the need to re-deploy any client side code.
With well constructed SPs I can even significantly change the underlying DB structure without worrying about changing any deployed .NET code.
And if it is more efficient to mangle the data in the application, I can still have an SP return a record set and use LINQ to POCO to do the mangling.
My first use of SPs was entirely due to security of the DB - access to which was restricted entirely to stored procedures, so even giving someone access to the DB server still only gave them access to the SPs - they couldn't even see the tables - let alone try to update them.
(AM I starting to sound religious enough?)
MVVM # - I did it My Way
___________________________________________
Man, you're a god. - walterhevedeich 26/05/2011
.\\axxx
(That's an 'M')
|
|
|
|
|
Yep, that's largely the way I've seen things as well.
|
|
|
|
|
FYI MacBook Air owners:
Quote: Apple has determined that certain 64GB and 128GB flash storage drives used in the previous generation of MacBook Air systems may fail. These systems were sold between June 2012 through June 2013.
MacBook Air Flash Storage Drive Replacement Program[^]
Kevin Priddle
Editor and Special Projects Manager | CodeProject & Developer Media
|
|
|
|
|
Thanks, will look into that tonight.
I'd rather be phishing!
|
|
|
|
|
Since Windows 7, when you run a disk cleanup and select Windows Update Cleanup (mostly after the service pack installation). It takes at-least an hour to cleanup. I can download and install the same update 10 times in that time.
Windows 8.1 just updated with today's launch. and I performed disk cleanup to free up 450 MB of disk space on 5 different computers, and it took 1.0 - 2.5 hours to cleanup with > 70% CPU utilization. 
When you run disk cleanup, it scans your computer and then tells you how much space it is going to free. So I am guessing it creates some king of list. So why it takes to long to loop through the list and remove the files.
When they are going to fix this. 
|
|
|
|
|
Rutvik Dave wrote: When they are going to fix this
Do not hold your breath. We are talking Microsoft.
|
|
|
|
|
Rutvik Dave wrote: When they are going to fix this.
Doesn't sound broken to me. It's not something you do every day.
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
|
|
|
|
|
Eddy Vluggen wrote: Doesn't sound broken to me. It's not something you do every day.
omg! Look, what they did to you. 
|
|
|
|
|
I've wondered about this and figured that they are doing a lot of checking and ACID type operations to make sure they don't brick the system if power is lost.
|
|
|
|
|
But the update is already applied, this is the cleaning process of temporary setup files, right?
|
|
|
|
|
It has to scrub the uninstall data from various places and what if one update is dependent on another update?
This is just one theory.
Do remember that Microsoft isn't known for it's speedy installs.
|
|
|
|
|
Update Cleanup? What's that? I never have run it, because the first thing I do is turn off automatic updates.
Marc
|
|
|
|
|
..which is why I burst out in laughter whenever a company starts on the subject of security 
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
They probably create a restore point before deleting each file.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
185 sushi chefs walk into a bar.
|
|
|
|
|
I don't think so - they don't server their kind there! 
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
Do not argue with an idiot. He will drag you down to his level and beat you with experience
Greg King
-----
I always wanted to be somebody, but now I realize I should have been more specific.
Lily Tomlin, Actress
|
|
|
|
|
..and say "Bartender! Show me some raw power, chop, chop!"
- I would love to change the world, but they won’t give me the source code.
|
|
|
|
|
Sorry I cant serve you: You smell a little fishy to me....
|
|
|
|
|
wizardzz wrote: 185 sushi chefs walk into a bar.
The bike gang didn't stand a chance.
|
|
|
|
|
The bartender says, "Where have you been all these months!? We missed you!"
/ravi
|
|
|
|
|
The bartender says: "I can't sherve sou, sou shee ?"
~RaGE();
I think words like 'destiny' are a way of trying to find order where none exists. - Christian Graus
Do not feed the troll ! - Common proverb
|
|
|
|
|
Bartender says, "Sorry, I can't serve you."
The sushi chefs reply, "Soy what. We'll just find somewhere to go."
|
|
|
|
|
The bartender says, "I can't serve you because this seems to be fishy".
"Real men drive manual transmission" - Rajesh.
|
|
|
|
|
The bartender says, "Miso sorry, you can't be served."
|
|
|
|
|
Bartender says, "Sorry, you guys got to roll."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
