Viewing 15 posts - 19,741 through 19,755 (of 22,219 total)
I can't help you on the rogue DBA topic. Hunt 'em down & hurt 'em may be your only option.
As to the rest, why not manage the database code in...
"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
August 13, 2008 at 11:18 am
Don't worry about it. There's always more to learn, for everyone. Speaking of which, I need to download 2008 and get started learning new stuff.
"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
August 13, 2008 at 9:06 am
Not per se. The thing is, you need to be very careful about how you manage security. If you give a role blanket execution priveleges, then you may need 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
August 13, 2008 at 9:04 am
OK. You may or may not want to continue the existence check. From what I can see though, I think you could skip it. It looks like you're doing 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
August 13, 2008 at 8:44 am
I volunteer to continue processing beer to lager as time & money allows. I know it's a sacrifice, but someone has to do 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
August 13, 2008 at 8:34 am
This really gets into DB design, but based on what you're saying, I would drop the FK that is currently in place on the Property table. From what you say,...
"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
August 13, 2008 at 8:32 am
majorbloodnock (8/13/2008)
Grant Fritchey (8/13/2008)
Jeff Moden (8/12/2008)
"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
August 13, 2008 at 7:49 am
Let me understand this...
The Historical_Propertys table has a pk, Property_ID. The Property_Managers table has a pk, Property_ID. There is a foreign key constraint on the Historical_Propertys table against the Property_Managers...
"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
August 13, 2008 at 7:41 am
I'm a little confused. If you grant execute to a stored procedure that can insert data... it's going to insert data. The way around it is to not grant execute...
"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
August 13, 2008 at 7:33 am
While I love VS for DB's and I'm even presenting a session at PASS on how to use it for multi-environment deployments, I don't think it will do what you're...
"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
August 13, 2008 at 7:31 am
Well... It depends...
The IN clause in this case is probably going to cause a table scan. I'd say that you're better off using IF EXISTS in a nested fashion such...
"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
August 13, 2008 at 7:16 am
Whether or not business logic should be inside a query is a HUGE debate. There are extremists on both sides. I'm pretty much in the middle. If it makes sense...
"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
August 13, 2008 at 7:05 am
Can you post the scripts you're using to create the tables? There may be something 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
August 13, 2008 at 6:50 am
Jeff Moden (8/12/2008)
"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
August 13, 2008 at 6:44 am
Good to know. Unfortunately, with the division of labor where I work, I don't have the ability to do that. But if I really need it, I know what 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
August 13, 2008 at 6:41 am
Viewing 15 posts - 19,741 through 19,755 (of 22,219 total)