Viewing 15 posts - 14,686 through 14,700 (of 22,219 total)
chetanr.jain (7/12/2010)
My Client has one service desk application at its two location ( A & B) with individual identical database. Now client wants to merge the both the 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
July 12, 2010 at 6:39 am
shayy (7/12/2010)
I have a table with these fields:
ID (PK), ProjectName, and some other non important fields (about 20)
Most of my queries i'm doing SELECT * from this table.
there is one...
"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
July 12, 2010 at 6:32 am
If you're working with linked servers and running queries against them, you need to know that unless you specifically use a construct like OPENQUERY and pass in parameter values, all...
"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
July 12, 2010 at 6:27 am
Alvin Ramard (7/11/2010)
Jack Corbett (7/11/2010)
CirquedeSQLeil (7/11/2010)
Alvin Ramard (7/11/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
July 12, 2010 at 5:15 am
Jeff Moden (7/9/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
July 11, 2010 at 6:45 am
Wouldn't be the first time I did something wrong. Time for experimentation.
"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
July 9, 2010 at 1:39 pm
Yeah, it's a bit of a bear.
Fact is, you're right Steve, SharePoint doesn't need 'sa', but it needs about 85% of what 'sa' does, so it's easier to just give...
"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
July 9, 2010 at 11:48 am
The Dixie Flatline (7/9/2010)
One...
"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
July 9, 2010 at 9:07 am
Kit G (7/9/2010)
But now I have a plan.
Cool. Should there be an evil laugh after "But now I have a plan"? :w00t: This is after all, The Thread....
"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
July 9, 2010 at 8:22 am
I'd be interested in seeing it too (unless you already sent it to me & I lost it, entirely possible). We've been getting great results with our indexes, but we...
"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
July 9, 2010 at 8:21 am
lverea-783150 (7/9/2010)
I 'm starting to manage a very big non-documented database created by another people.
I wish to know if there is a way (an script or something like that) 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
July 9, 2010 at 7:36 am
mupparaju78 (7/9/2010)
which one is the best performence "index or cluster index"
Yes!
More detailed, it depends.
Even more detailed, assuming a covering index, meaning an index that can satisfy all the requirements 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
July 9, 2010 at 7:08 am
Sorry, nothing built in for that. You'll have to roll your own.
"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
July 9, 2010 at 6:50 am
I'd take a look at the sys.dm_tran_locks dynamic management view. You could also use sys.dm_exec_requests to see which sessions are blocked, but just to see all locks, the first DMV...
"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
July 9, 2010 at 6:49 am
The industry had respect for the traditional DBA?
There are a lot of products and processes out these days, specifically targeted at eliminating the need for DBA's. For some reason we've...
"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
July 9, 2010 at 6:43 am
Viewing 15 posts - 14,686 through 14,700 (of 22,219 total)