Viewing 15 posts - 20,176 through 20,190 (of 22,224 total)
Two answers. Yes, it's possible. What you want is a foreign key to another table to ensure integrity between the data entered on one table and the data entered on...
"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 12, 2008 at 10:44 am
All right, now I'm mad.
If I run a profiler trace and capture XML execution plans, I can save those to file. They save correctly as UNICODE.
What the heck is...
"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 12, 2008 at 10:40 am
Yes, that was the answer.
Well, at least it wasn't something stupid that I did (for once).
This is a bit of a pain. I wonder if there's a work around.
"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 12, 2008 at 10:26 am
It sounds like you're using up resources. I'd suggest using perfmon & trace to see what's happening with the server & the queries respectively.
90% cache hit ratio isn't all...
"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 12, 2008 at 5:50 am
I can't help you with SSIS. I just don't know anything about what's going on there in 2008 yet.
SSRS on the other hand, I've got some knowledge. In addition 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
June 12, 2008 at 5:42 am
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
Viewing 15 posts - 20,176 through 20,190 (of 22,224 total)