Viewing 15 posts - 20,176 through 20,190 (of 22,219 total)
I'm not sure if the injection attack is related or not.
It sounds like you recompiled after dropping and creating the script and got an execution plan that didn't run...
"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
June 11, 2008 at 1:38 pm
... And the execution plan from your own environment.
"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
June 11, 2008 at 12:01 pm
I'm running the last CTP, not the RC0 that just came out, but I have 8, 9 & 10 compatability modes. That's 2000, 2005 & 2008.
I'd suggest not going. 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
June 11, 2008 at 10:36 am
We have to do deployments out of source control. Sometimes they are incremental deployments and we could get away with having an ALTER statement instead of a DROP & CREATE,...
"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
June 11, 2008 at 9:30 am
One other point, submit abstracts to speak at the conference. If you get accepted, they usually wave the fee to attend. As far as PASS goes, volunteer and work your...
"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
June 11, 2008 at 8:52 am
I worked for several start-ups and they wouldn't send anyone. Larger companies... I sell it to the boss by pointing out sessions on things that we're working on or 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
June 11, 2008 at 8:18 am
Which version?
Do you have any particular error messages?
Several people on the forum's here have installed it with little to no issue, so we know that it does install.
"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
June 11, 2008 at 7:40 am
From what you described, I'd go with a single table, Organization, to describe the basic attributes of that object. Then, I'd add a table, let's call it OrganizationType, that lists...
"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
June 11, 2008 at 6:38 am
Rather than simply spot checking by running sp_who2, you might consider setting up a trace to capture the stored procedures and query calls on the server over a period 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
June 11, 2008 at 6:33 am
In SQL Server 2005 or 2000 without some type of structure or mechanism to gather that data, no.
"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
June 11, 2008 at 6:29 am
I did a series of tests because I wanted to write an article comparing OPENXML to XQUERY. I couldn't find a fundamental performance difference in query execution time, scans or...
"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
June 11, 2008 at 6:23 am
I agree with Jack. It's like you wrote a product description for SSIS.
For going to Oracle, I'd suggest getting this third party destination device. Otherwise, moving the data to oracle...
"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
June 11, 2008 at 6:16 am
Thanks Bart. Very useful information. I think I'll be staying away from the list all columns option though. I do like David Poole's tip up above. I need to remember...
"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
June 11, 2008 at 6:03 am
You are quick, Gail! I haven't even been able to download the bloody thing yet, let alone get my virtual's upgraded.
Thanks for the post. One less thing to test.
"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
June 11, 2008 at 6:01 am
Great report, thanks Steve. I think you're very right about Powershell. It's incorporated into Operations Manager 2007 and Team Foundation Server. I'm seeing more and more bits & pieces suggesting...
"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
June 11, 2008 at 5:56 am
Viewing 15 posts - 20,176 through 20,190 (of 22,219 total)