Viewing 15 posts - 20,806 through 20,820 (of 22,224 total)
I wasn't, but our local user group (SNESSUG) is hosting one of those in a couple of weeks. If no one else hooks you up, I'll get the script from...
"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
March 20, 2008 at 12:42 pm
Adam Bean (3/20/2008)
Grant Fritchey (3/20/2008)
Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter...
"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
March 20, 2008 at 12:19 pm
Terry (3/20/2008)
I have a PRODUCTS table which contains 2 fields: old product code and new product code.
I also have a clients table, where the old code is stored.
I would...
"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
March 20, 2008 at 12:17 pm
Sorry, left out a bit of detail.
Instead of looking at the System Monitor, go to the Performance Logs and Alerts and set up a new Counter Logs using the "New...
"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
March 20, 2008 at 12:11 pm
I would not recommend it, but you can log directly into a SQL Server database.
Instead, I've logged out the CSV's and imported them directly to a table inside the 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
March 20, 2008 at 12:08 pm
I'm guessing something else in the code because I took your example, added a statement, and it's running just fine.
CREATE PROCEDURE [dbo].[Sp_Update_Fact] AS
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
March 20, 2008 at 10:56 am
DBA (3/20/2008)
the execution plan shows a couple of parallelism cost 1% and a couple of hash match cost 2%. No index scans.
That's 3% of the cost. The other 97%?
"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
March 20, 2008 at 10:42 am
sqluser (3/20/2008)
But i need to do the same for all the table columns having uniqueidentifier.---
The first query will show you all tables and all columns with uniqueidentifiers. You'll then...
"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
March 20, 2008 at 8:03 am
Since there are likely to be more wars (unfortunately) why not set up a table of wars with the appropriate date ranges and then join against it? That way 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
March 20, 2008 at 7:31 am
Worth mentioning, did you look at the 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
March 20, 2008 at 7:24 am
First off, if these are primary keys and you have referential integrity, you have a MAJOR task in front of you. Why would you want to do something like this?
Otherwise,...
"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
March 20, 2008 at 7:12 am
I would add to the Administrative costs a very high cost to implement changes. Tune one procedure, deploy it 200 times. Modify one column, rebuild 200 tables in 200 databases...[shudder]
I...
"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
March 20, 2008 at 6:58 am
I wouldn't have expected all those cache misses (miss's?) either. What did the test procedure do? Take a look at the link posted above to see if the test proc...
"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
March 20, 2008 at 5:44 am
Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."
[to the tune "The Yellow Rose of Texas"]
Oh, my body has a passage 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
March 19, 2008 at 11:28 am
Whoa! Hold on. Revelation! People who come out of college are mature adults? Hmmm... To ask this in the proper SSC manner, you have a test that proves 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
March 19, 2008 at 10:43 am
Viewing 15 posts - 20,806 through 20,820 (of 22,224 total)