Viewing 15 posts - 22,021 through 22,035 (of 22,219 total)
If you're going for cheap, then you just need to set up full text indexing that comes with SQL Server 2005. Otherwise, I found this information on the Google site:
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood" Author of:
- Theodore Roosevelt
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 22, 2007 at 6:28 am
Are you kidding? Set logic is bloody difficult. I have a hard time wrapping my brain around it almost daily. I just know that I have to take the approach...
"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
January 19, 2007 at 10:20 am
Just to start with, no:
SELECT * FROM ... LIKE 'Asp.net%'
will only find data that is starts with Asp.net. If you want to search in the middle of a string 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
January 19, 2007 at 8:32 am
It's not so much the database that's set oriented, although that's a big part of the issue. It's that TSQL is set oriented. Especially 2005 with common table expressions &...
"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
January 19, 2007 at 8:28 am
I agree with Ms. Shaw. Who wouldn't. You may also want to consider using a unique constraint:
ALTER TABLE [x]
ADD CONSTRAINT [y]
UNIQUE NONCLUSTERED ([emailaddress],[password]) ON [PRIMARY]
Then you get the index suggested...
"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
January 19, 2007 at 7:09 am
Now that's sweet. I had not known of this one prior to today. Thanks for posting 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
January 19, 2007 at 5:33 am
Nice choice. Beats a cursor in most situations.
"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
January 18, 2007 at 11:32 am
Crud I hate that. My first response went into the ether and my second got posted so I look like a schmuck. Sorry about that. What I said was:
Generating objects...
"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
January 18, 2007 at 5:17 am
Oops, should have added, SMO means SQL Management Objects. It's in the BOL, including decent (if not good) references & samples.
"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
January 18, 2007 at 5:11 am
Based on what you're suggesting, you might want to look at doing a little SMO programming. You can quite simply generate a CREATE script for various objects from there.
"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
January 18, 2007 at 4:32 am
We usually run this once a week on production servers:
sp_cycle_errorlog
We generally only keep the four weeks around. If you want to archive them after you cycle 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
January 18, 2007 at 4:29 am
In general, you don't want to. TSQL is set based and works best when you keep that in mind.
For example, where I work, we will usually write a pair...
"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
January 18, 2007 at 4:24 am
Thinking about it, that's a somewhat inadequate answer I gave.
Referring to Ambler's book on refactoring, of course you want to first add the new columns. Then you have a decision...
"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
January 17, 2007 at 6:29 am
I'm not sure I agree on this one. My manager came out of sales & has few technical skills but he's doing a pretty good job managing the team. His...
"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
January 16, 2007 at 8:11 am
If I were going to refactor this, I'd leave the existing column in place as a calculated column and then split the actual data storage into two other columns. 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
January 16, 2007 at 6:35 am
Viewing 15 posts - 22,021 through 22,035 (of 22,219 total)