Viewing 15 posts - 21,196 through 21,210 (of 22,224 total)
What about adding a statement from TFS using the tf.exe to get the the version of the project, add that to a variable and pass that variable into the command...
"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 24, 2008 at 6:22 am
I can't take credit for it. One of the guys in my shop, Scott Abrants, is one of those obsesive compulsive types who has to find the deep dark secret...
"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 24, 2008 at 5:55 am
Not a problem. Provide a variable, say the TFS version number or something, in the build command line and set the extended property for the database in a Post-Deployment script.
Actually,...
"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 23, 2008 at 1:02 pm
Yes, absolutely. Visual Studio Team Edition for Database Professionals, AKA DBPro, AKA DataDude. This tool has turned around our build & deployments. As a matter of fact, I think 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 23, 2008 at 11:08 am
First off, the second sample query won't work because the urlpage isn't included in the group by.
For the denormed table, I found that setting the clustered index to the date...
"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 23, 2008 at 8:31 am
If you look at the execution plans for the two queries, the scalar function looks like the simpler plan. It simply has a clustered scan and a scalar operation. 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 23, 2008 at 7:53 am
You should probably take a look at the binary data type. I'm not terribly familiar with its use, but I think that's what you need for storing .DOC files. VARCHAR(max)...
"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 23, 2008 at 7:08 am
Good article. I'm looking forward to more.
Can you point me to a good resource on maintenance considerations, if any, for Compact databases?
"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 23, 2008 at 6:55 am
Not knowing the structure or the code, it's hard to make suggestions. If you haven't already, check out this white paper from Microsoft. They outline a number of things 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 23, 2008 at 6:04 am
I think this is a case of buyer beware, your mileage may vary, some assembly required... You get the drift.
Scalar functions, as Adam very clearly outlines, unless they're very...
"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 23, 2008 at 6:01 am
Check the connection settings for both Management Studio & the App. You may have differences there that are causing the differences in execution time. Stuff like SET IMPLICIT_TRANSACTIONS, SET ANSI_PADDING.
Do...
"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 23, 2008 at 5:50 am
True, I forgot about that. Thanks.
"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 22, 2008 at 1:29 pm
That's one ugly debate you're entering into. Short answer is, parameterized queries function the same way as stored procedures. SQL Server will be able to reuse execution plans because 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 22, 2008 at 12:55 pm
You've got someone running transactions, sorts, or creating temporary tables with lots of data. We had users starting an ORDER BY query (no parameters, bad joins, bad search criteria) that,...
"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 22, 2008 at 12:47 pm
In terms of a join, don't adjust anything. If the column is null, it doesn't equal anything and that row won't be returned which is as it should be.
"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 22, 2008 at 12:15 pm
Viewing 15 posts - 21,196 through 21,210 (of 22,224 total)