Viewing 15 posts - 21,676 through 21,690 (of 22,224 total)
System catalog view:
SELECT * FROM sys.servers
It's one of the properties, is_rpc_out_enabled.
"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
October 17, 2007 at 5:28 am
Look up the EXECUTE statement in BOL:
EXECUTE ('USE STUFF;DROP INDEX OWNER_idx ON dbo.OWNER')
AT SQLnk
The linked server has to support RPC calls:
EXEC master.dbo.sp_serveroption @server=N'SQLnk', @optname=N'rpc', @optvalue=N'true'
Oh, and, Warren Peace: SKY HIGH...
"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
October 16, 2007 at 1:07 pm
You can use IS_MEMBER() to determine the current users inclusion in a particular group. There are also a series of dynamic management views (DMV) that access security. Try sys.database_role_members and...
"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
October 16, 2007 at 8:23 am
I'd heard C++ too. I don't recall the source though.
"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
October 16, 2007 at 8:14 am
The error logs are just text files. You should be able to simply open them in a text editor, completely seperate from SSMS.
"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
October 16, 2007 at 8:05 am
And since this is 2005, the sqlcmd command line utility as well.
"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
October 16, 2007 at 6:44 am
I wish I had real wit, but all I can come up with is "Hey, Steve, you've got a groupie."
Seriously though Sandy, you left out Gail Shaw, NinjaRGR 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
October 16, 2007 at 6:36 am
You've got perfect programmers too? Wow. Small world.
Seriously though, sounds like you're on the right track.
"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
October 16, 2007 at 6:14 am
John Aherne (10/15/2007)
"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
October 16, 2007 at 5:59 am
Steve Jones - Editor (10/15/2007)
However I think Matt made a great observation. Be careful about moving to a new employer because 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
October 15, 2007 at 11:53 am
Jack Corbett (10/15/2007)
[/quote-0]
I have to admit to not being confident on this one. I would define it by saying it occurs when SQL uses...
"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
October 15, 2007 at 11:51 am
Maybe it's Rhode Island? But we ask these questions:
What's the difference between clustered & non-clustered index
What's the difference between blocks and deadlocks
What kind of recovery models does a database have...
"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
October 15, 2007 at 11:49 am
I've been involved with hiring DBA's where I work for the last three years. It's been a frightful experience. We eliminate most candidates in a ten minute phone call. While...
"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
October 15, 2007 at 10:05 am
I went through a period of swapping jobs quite a lot. It was those damned dot coms. Funny thing was, I took a pay cut each time I jumped because...
"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
October 15, 2007 at 9:56 am
There is a difference between simply including a column and adding it to the index. You add a column to the index because it is part of sorts, searches, joins,...
"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
October 15, 2007 at 9:13 am
Viewing 15 posts - 21,676 through 21,690 (of 22,224 total)