Viewing 15 posts - 20,611 through 20,625 (of 22,219 total)
Samuel Clough (4/22/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 8:31 am
Andy Warren (4/22/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 8:27 am
Samuel Clough (4/22/2008)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 7:00 am
Anders Pedersen (4/22/2008)
Who cares if a developer saves 10%-20% (the numbers I have heard bandied aroud) by using LINQ during development time? How much time...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 6:57 am
The honest answer is, it depends. But I've found that most of the time, performance problems are in the code and the structure, not the system. That assumes the system...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 6:25 am
There are three tiers of code to developers, client, business, data access. If you want to make development faster, you need to reduce or eliminate one of these tiers. They...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 6:07 am
Excellent, and timely, question. I've been trying to track down the exact same information. The whole idea of ORM (Object Relational Mapping), which LINQ and Entity Framework are examples, has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 6:03 am
Thanks for getting back.
At this point, to everyone except the development architect, we're still gathering information prior to making a decision. My two biggest issues come down to 1) not...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 22, 2008 at 5:46 am
Something along these lines will work as well. I agree you should fix your data types. This will only work well if you've got good indexes too.
SELECT t.Name, t.Date, t.Time
FROM...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 1:11 pm
When you have the Job Activity Monitor window open, it's on the left in the Status field under a link labeled "View filter settings" and you can also get to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 12:26 pm
One other thing you might look at. The Activity Monitor has a "filter settings" that might be filtering out the info that you expect to see. You should check that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 12:18 pm
You mentioned a job that changes it's status between the time it ran and the time you looked at it. Did it run again during that time period? That's the...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 12:12 pm
If the history is getting cleaned up, it's from that properties page I mentioned. There is a way of removing history. It sounds like you might have a bit of...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 10:51 am
Do you mean the history of the jobs? Or do you mean that a job failed at 3am, but succeeded at 6AM so it shows as successful? If the former,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 9:38 am
I assume there's a real difference between the number of users and transactions between dev & production? That alone will show a pretty large difference in behavior. But I'd still...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 21, 2008 at 8:54 am
Viewing 15 posts - 20,611 through 20,625 (of 22,219 total)