Viewing 15 posts - 18,676 through 18,690 (of 22,219 total)
Check out the Books Online for the topic SQL Agent. Agent is a scheduling process that will let you run lots of stuff, including TSQL batches, on a scheduled basis....
"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 20, 2009 at 5:49 am
One place I've been visiting for bits and pieces is this blog: http://blogs.msdn.com/sqltips/default.aspx
But by & large, for focused information, Gail has given you what I've been using.
There is also the...
"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 20, 2009 at 5:47 am
mgalgey (1/20/2009)
I want to capture any custom code that is in the stored proc that is not auto generated and insert it into the new stored proc.
Eg
Old ...
"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 20, 2009 at 5:41 am
Oh, and it goes before the ORDER BY clause.
"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 20, 2009 at 5:36 am
Try using the HAVING clause. Look it up in Books Online for details, but it would look something like this:
SELECT...
FROM...
WHERE..
GROUP BY...
HAVING SUM(MyValue) > 0
It's sort of like a WHERE clause...
"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 20, 2009 at 5:35 am
I'm not aware of a good, all encompassing SQL Server 2005 tutorial. I'm with Jack. You'll need to hit JumpstartTV, Simple-Talk, and of course, here at SSC, to get the...
"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, 2009 at 11:42 am
Jack Corbett (1/19/2009)
Grant Fritchey (1/19/2009)
Ninja's_RGR'us (1/19/2009)
That's worth repiting Grant :w00t::D:hehe:.
What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent 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
January 19, 2009 at 7:26 am
Ninja's_RGR'us (1/19/2009)
That's worth repiting Grant :w00t::D:hehe:.
What? Did the copy editors fall down on the job again. Steve, fire that mangy lot and get someone decent in here to protect us...
"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, 2009 at 7:03 am
I'm sorry, but I don't understand the structure. What relates one table to another? How would you join table1 to table2 to get the results you want. What does table3...
"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, 2009 at 6:35 am
I don't see why you both couldn't write an article on the same topic. With your different backgrounds, knowledge sets and approaches I'll bet both would offer up unique information....
"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, 2009 at 6:33 am
rferguson (1/18/2009)
"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, 2009 at 6:14 am
office (1/18/2009)
"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, 2009 at 2:52 pm
Jack Corbett (1/18/2009)
"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, 2009 at 2:46 pm
In fact, you'd probably hurt performance with just an index on Event, depending on where the cluster index is on the table (if there's a clustered index) because you're likely...
"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, 2009 at 12:40 pm
In addition to the web sites Gail provided (and the storage engine web site from Microsoft is just fantastic), you might want to read through Kalen Delany's book on the...
"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, 2009 at 12:38 pm
Viewing 15 posts - 18,676 through 18,690 (of 22,219 total)