Viewing 15 posts - 19,426 through 19,440 (of 22,226 total)
UPDATE STATISTICS is the best command for working with statistics since it has the most flexibility. However, for batch work, sp_updatestats can do all the stats on a 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
October 20, 2008 at 8:48 am
Here are some tutorials over at JumpstartTV that might help too:
This one exactly answers the question:
http://www.jumpstarttv.com/generating-sql-server-scripts-using-smo_425.aspx?searchid=3347
This one discusses capturing changes
http://www.jumpstarttv.com/capture-schema-changes-with-smo_412.aspx?searchid=3347
Here's the full list.
http://www.jumpstarttv.com/Search.aspx?terms=smo
"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
October 20, 2008 at 8:44 am
You could also try to the tools from Red Gate (www.redgate.com).
You could use a coding language and make a call to SMO (SQL Management Objects) to generate the scripts. Since...
"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
October 20, 2008 at 7:55 am
Also answered here:
http://www.sqlservercentral.com/Forums/Topic588077-149-1.aspx?Update=1
"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
October 20, 2008 at 7:46 am
Do you mean running scripts from the command prompt? Check out the functionality of sqlcmd.exe.
"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
October 20, 2008 at 7:46 am
In addition to how to create an index, you might want to know about where to create them:
http://www.sqlmag.com/articles/index.cfm?articleid=5113
http://www.sqlservercentral.com/articles/Performance+Tuning/2770/%5B/url%5D
"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
October 20, 2008 at 7:41 am
We've been using ER diagrams less and less for development and instead relying on tools like Visual Studio Team System Database Edition. But we still do use ER diagrams for...
"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
October 20, 2008 at 7:35 am
If it's doing a seek operation, but it's still slow, I'm inclined to look at index fragementation or out of date statistics. You do have automatic update of statistics enabled,...
"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
October 20, 2008 at 7:33 am
I've been working on the whole concept of unit testing TSQL for quite a while. At this point, I'm a bit more in Phil's camp. We do "unit testing" as...
"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
October 20, 2008 at 6:45 am
danschl (10/17/2008)
Specifies that the query is optimized for fast retrieval of the first number_rows. This is a nonnegative integer. After the first number_rows are returned, the query continues execution...
"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
October 20, 2008 at 6:02 am
Still, that's information. I'll set up a test database over the weekend and try a couple of things.
I have to wonder why on earth it would matter...
"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
October 17, 2008 at 12:30 pm
Interesting.
What query or queries did you run against it to get a recommendation?
I can't imagine that the database would matter, but the one I'm using is the 2008 version 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
October 17, 2008 at 12:07 pm
Execution plan?
"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
October 17, 2008 at 11:10 am
It will treat them, as much as it can, as a whole. But the more complicated the query, the longer it will take the optimizer to find a good plan....
"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
October 17, 2008 at 10:53 am
I'm sorry, no, I can't.
The basic structures look a lot like what you see in the article.
I've got another article coming out in the SQL Standard this month that compares...
"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
October 17, 2008 at 10:50 am
Viewing 15 posts - 19,426 through 19,440 (of 22,226 total)