Viewing 15 posts - 18,181 through 18,195 (of 22,226 total)
I'd suggest getting all the database objects into source control. Then, make all your changes through the scripts, not by editing the database through Management Studio. You should very carefully...
"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
February 28, 2009 at 6:05 am
It's in the Books Online, the SQL Server documentation. Just look up sp_recompile and read what's 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
February 28, 2009 at 5:59 am
David Sumlin (2/27/2009)
If not, almost makes me want 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
February 28, 2009 at 5:49 am
Ah, if you want to collect errors, this won't help at all. It's only going to show completed queries. You'll need to set up a server side trace.
Howerver, a slightly...
"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
February 27, 2009 at 8:53 am
Jeff Moden (2/27/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
February 27, 2009 at 6:39 am
Profiler doesn't debug queries. It captures performance and behavior. I'm not aware of a third party tool that does everything that it does.
However, just because you don't have Profiler doesn't...
"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
February 27, 2009 at 6:13 am
Just to help the newbiezzzzz a bit further, this is an Access bit of code you're writing, not T-SQL inside SQL Server 2005, right?
"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
February 27, 2009 at 6:06 am
No, that's probably not a great way to go about it. Instead have a many-to-many join table between the two other tables. So you'll have a ChangeRequest table and a...
"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
February 27, 2009 at 6:01 am
I see a loop and I want to eliminate it, if possible. But you're right, of course.
I still think partitioning the data would be a better approach rather than having...
"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
February 27, 2009 at 5:48 am
Will they still compile? Leave 'em there. If not, clean 'em out.
"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
February 27, 2009 at 5:43 am
Jeff Moden (2/26/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
February 27, 2009 at 5:41 am
Jeff Moden (2/26/2009)
Darwin knew this was possible...http://www.sqlservercentral.com/Forums/Topic665342-148-1.aspx
What? You don't know about Type II? You been living in a cave?
"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
February 27, 2009 at 5:35 am
There's a heck of lot here to chew on, but the first thing that jumped out at me was the this little bit of RBAR (row-by-agonizing-row) processing:
while @RevStateyr < '1991'
Begin
...
"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
February 26, 2009 at 8:42 pm
I'd have to do some experimentation with it to be sure, but according to BOL you can get the DMV sys.dm_exec_query_requests has the sql_handle and statement_start_offset combined with statement_end_offset 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
February 26, 2009 at 8:00 pm
I just got directly to the page by googling '"Are the posted questions getting worse" karate'.
Apparently I was quoting Captain Queeg. It must have been right after a Cub...
"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
February 26, 2009 at 7:49 pm
Viewing 15 posts - 18,181 through 18,195 (of 22,226 total)