Viewing 15 posts - 18,061 through 18,075 (of 22,219 total)
Yep. 'post' is not a number.
"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
March 9, 2009 at 6:04 am
You have to inlcude a mechanism for eliminating duplicate games. Is it the first one encountered? The first one alphabetically? The one with the lowest or highest ID number? 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
March 9, 2009 at 6:00 am
Let's have a war
We can start it in New Jersey
We don't
really
need all these people
in the city
There's too many of us, there's too many of us, there's too many 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
March 8, 2009 at 5:09 pm
A primary key and the index created in support of it are basically one and the same. Management Studio creates all the primary keys, by default, as the clustered index....
"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
March 8, 2009 at 5:06 pm
There can be only one!
Now back to writing about backup encryption.
"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
March 8, 2009 at 1:48 pm
Excellent. Consider it borrowed. I'm working on the first draft of a review process for PASS and the new SQL Standard so I'll incorporate this. It's actually not too far...
"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
March 7, 2009 at 6:22 pm
I'm glad it helped. Understand though, it really is introductory. You're going to blow past it pretty quick. Come back and post when you have questions on details as 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
March 7, 2009 at 4:24 pm
I'm aligned with those who don't see a special l33t forum for invited users, not that I'd get invited. Anything I'm going to post, especially questions when I have them,...
"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
March 7, 2009 at 4:21 pm
Yes, the best way to determine what needs indexing is to use Profiler, or TSQL, to create a server side trace to capture data over time. You can then run...
"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
March 7, 2009 at 4:49 am
If the OUT process changes a lot of the data, especially if it does a lot of deletes, you could be seeing index fragmentation affecting the next process. Hard 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
March 7, 2009 at 4:45 am
DavidB (3/6/2009)
My guess is that the FTI will perform better, and I believe you would limit those reads a bit as well. 🙂
Quite likely, but I'd test it very thoroughly....
"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
March 6, 2009 at 5:06 pm
Jeff Moden (3/6/2009)
Grant Fritchey (3/6/2009)
At this point, I'm calling this a troll.http://www.sqlservercentral.com/Forums/FindPost670625.aspx
Remember, don't feed the trolls.
Heh... what? They don't like pork chops? 😉
I told him to stop trolling way...
"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
March 6, 2009 at 4:57 pm
This will lead to table or index scans
and ProEmail like '%@%'
"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
March 6, 2009 at 1:35 pm
At this point, I'm calling this a troll.
http://www.sqlservercentral.com/Forums/FindPost670625.aspx
Remember, don't feed the trolls.
"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
March 6, 2009 at 1:33 pm
chrisau168 (3/6/2009)
wanted to confirm some basic concepts about indexes.
my understanding of clustered index and nonclustered index is like this.
if I have a clustered index on column "a" and I 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
March 6, 2009 at 12:58 pm
Viewing 15 posts - 18,061 through 18,075 (of 22,219 total)