Viewing 15 posts - 14,956 through 14,970 (of 22,232 total)
Gianluca Sartori (5/25/2010)
Grant Fritchey (5/25/2010)
"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
May 25, 2010 at 9:18 am
Grant Fritchey (5/25/2010)
"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
May 25, 2010 at 9:12 am
Sandy2704 (5/25/2010)
How is it caused by the bad code???
Just to give one example, our developers wrote a piece of code that made every call to the database, three times. So...
"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
May 25, 2010 at 9:10 am
Jeff Moden (5/25/2010)
Grant Fritchey (5/25/2010)
"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
May 25, 2010 at 9:04 am
I haven't been posting here at the water cooler because, frankly, I was appalled at how many posts I had here. But I have to share this one because it...
"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
May 25, 2010 at 9:02 am
karthikeyan-444867 (5/25/2010)
Track down articles by him for more information on natural keys.
can you give me the URL?
Come on Karthik. You've got the name, Joe Celko, and you have...
"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
May 25, 2010 at 8:59 am
http://lmgtfy.com/?q=%22SQL+Server+2005%22+%22New+Features%22
"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
May 25, 2010 at 6:41 am
There is nothing built into SQL Server 2000 that will answer that question automatically. The reason Paul asked for the version is because 2008 has a process called Change Data...
"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
May 25, 2010 at 6:39 am
I agree with Steve. Why on earth would you want to reduce the number of transactions per second? This is indicative of a high load on the system. You should...
"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
May 25, 2010 at 6:30 am
It really depends on the needs of the system and, which school of thought you subscribe to. I'm not a fan of using natural keys as the primary key 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
May 25, 2010 at 6:28 am
That's a completely circular reference. While you can set those up, they're impossible to maintain.
"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
May 25, 2010 at 6:06 am
The main problem is, your set based solution is using that UDF instead of straight SQL. That's causing performance issues.
"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
May 24, 2010 at 9:05 am
Have you run DBCC CHECKDB on this database?
"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
May 24, 2010 at 8:26 am
I'd suggest getting a copy of the book "Microsoft SQL Server 2008 Internals" by Kalen Delaney. This is a huge topic, as was already noted, and just can't possibly be...
"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
May 24, 2010 at 8:25 am
Just adding another thought...
Most app developers that need to support multiple platforms are taking advantage of ORM tools like Hibernate, nHibernate, LINQ, Entity Framework, etc., to perform the work for...
"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
May 24, 2010 at 7:51 am
Viewing 15 posts - 14,956 through 14,970 (of 22,232 total)