Viewing 15 posts - 14,956 through 14,970 (of 22,227 total)
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
I'm with Paul, obviously it would be better to have multiple machines, but if you can't, multiple instances will at least simulate the results. This way you avoid the issue...
"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 6:16 am
Even though both operators have the word SCAN in them, there is no real comparison between a Constant Scan and an Index/Cluster/Table Scan.
Usually, but not always, an Index/Cluster/Table Scan is...
"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 6:14 am
It really depends on the situation, but for most of us, no, this is a waste of time & effort. I've been working for a company for almost nine years....
"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 6:04 am
The best way to deal with sudden issues on the database is to prepare beforehand. Know how to look for contention. Know how to look at the processses that are...
"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 6:00 am
I've honestly never tried it that way, so I'm not sure where to go. If you know which procedure is giving your problems, I just work with it on my...
"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 21, 2010 at 4:36 am
Viewing 15 posts - 14,956 through 14,970 (of 22,227 total)