Viewing 15 posts - 8,731 through 8,745 (of 22,219 total)
What you're looking to do is use the GRANT command to give people access to a particular table. There's an example at the link. You can combine that with 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
March 10, 2014 at 3:35 am
ananda.murugesan (3/10/2014)
GilaMonster (3/10/2014)
Still not following.Are you talking about the primary key constraint? Or some other constraint? What exactly is the problem here?
Yes. I am talking about Primary Key constraint., Not...
"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 10, 2014 at 3:23 am
MyDoggieJessie (3/9/2014)
Wow Grant, that "SQL Server 2012 Query Performance Tuning" book is $40- do we get an SSC discount? 😀
Ha! Price is set by Apress. They've actually come down some...
"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 10, 2014 at 3:17 am
jaminbw (3/9/2014)
Thanks for this article. I relate to this so much.
I do want to be responsive to needs of operations but, I hate how often I am seen as...
"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 10, 2014 at 3:16 am
PRR.DB (3/9/2014)
Grant Fritchey (3/9/2014)
If we're talking SQL Server 2012, you can use a SEQUENCE. There are a nuber of examples on the documentation page.
i think sequence for only integer datatypes...
"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 9, 2014 at 6:02 am
Perfmon doesn't show that type of material. You'll want to capture query metrics using a server-side trace (not Profiler, don't run the GUI against production machines) or extended events. But...
"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 9, 2014 at 5:46 am
I'd go with a pre-built script to do the heavy lifting. I like Michelle Ufford's scripts[/url] for doing this. Others like Ola Hollengren's.
"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 9, 2014 at 4:52 am
If we're talking SQL Server 2012, you can use a SEQUENCE. There are a number of examples on the documentation page.
"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 9, 2014 at 4:51 am
If you're not using SQL Server 2000, you should be avoiding aliasing users. sp_addalias is deprecated functionality. I don't even think it's available in SQL Server 2008 or higher. Also,...
"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 9, 2014 at 4:48 am
aviadavi (3/9/2014)
one more thing,How can I know (during load) if the SQL is now in bottleneck ?
You're either seeing long wait times, or blocked processes, or both. If you're seeing...
"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 9, 2014 at 4:36 am
Sqlsavy (3/9/2014)
Thank you all.How frequently Index rebuild job can be run? every night or weekly?
It depends on what you can afford on your system and, how much the indexes fragment....
"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 9, 2014 at 4:34 am
Best of luck. You know where to go if you need more help.
"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 8, 2014 at 12:21 pm
I'd be curious why the plans are choosing to do scans. Assuming the distribution of the data hasn't changed, just having more data doesn't generally affect the statistics that much....
"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 8, 2014 at 10:28 am
Maybe I don't understand the question, but you create a primary key using the add constraint command. It just so happens that any kind of unique constraint, and the primary...
"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 8, 2014 at 10:18 am
MyDoggieJessie (3/7/2014)
"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 8, 2014 at 4:11 am
Viewing 15 posts - 8,731 through 8,745 (of 22,219 total)