Viewing 15 posts - 15,016 through 15,030 (of 22,227 total)
Instead of a group by clause, I'd suggest going with either an ORDER BY and select the TOP 1 value or use the OVER ORDER BY with the ROW_NUMBER in...
"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 18, 2010 at 6:16 am
Best tool I know of for working with models is Embarcadero ERStudio.
But if you do a search, there are free ones out there, but you're going to get what you...
"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 18, 2010 at 6:10 am
Richard M. (5/17/2010)
James Stover (5/13/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 17, 2010 at 2:53 pm
To know if servers are down, you need to enlist yet another server as the monitoring point, pinging the original servers to see if they're alive.
"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 17, 2010 at 11:10 am
The thing is @@ERROR really doesn't catch errors, it reports them. TRY/CATCH can literally catch, say, a deadlock, and let you retry the query. That difference alone is a great...
"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 17, 2010 at 9:23 am
Since you're doing updates, you do have to worry about two searches there, the search within the table for the correct records to update and the select statement & join...
"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 17, 2010 at 9:19 am
There must be differences, index fragmentation, statistics age, contention for resources, available memory, connection settings, lots of these things can cause differences in performance.
"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 17, 2010 at 9:17 am
Basically if the error will cause a disconnect, SQL Server can't catch or handle the error, so the calling code will have 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
May 17, 2010 at 6:51 am
I'm still not getting a total picture with details, but based on what else you've said, I'm going to stand by the original post. A table that stores relationships, user...
"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 17, 2010 at 6:09 am
GilaMonster (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice guy and...
"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 17, 2010 at 6:00 am
avanch-990710 (5/14/2010)
Now, does the sa account for SQL server 2000 and SQL server 2008 have the same password--I have them set up with different passwords?
That depends on what was set...
"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 17, 2010 at 5:49 am
I still don't understand what you're asking for? A query has no selectivity. There is not a measured set of uniquely identifying data about a query. The data stored in...
"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 17, 2010 at 5:48 am
The Dixie Flatline (5/14/2010)
Forums really shouldn't be a resource of last resort, especially in an emergency. ...
"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 17, 2010 at 5:41 am
TheSQLGuru (5/13/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 17, 2010 at 5:38 am
Ben Holcombe-270296 (5/13/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 17, 2010 at 5:35 am
Viewing 15 posts - 15,016 through 15,030 (of 22,227 total)