Viewing 15 posts - 13,726 through 13,740 (of 22,219 total)
As fast as possible.
OK, maybe not. Usually it's initially set by the business, not by the DBA's. There's going to be a threshold above which your users begin to complain....
"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
January 3, 2011 at 6:30 am
First thing that comes to mind is that setting the ANSI_PADDING value within the procedure or the function will cause recompiles. So that could affect you. How long does 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
January 3, 2011 at 6:25 am
RBarryYoung (1/1/2011)
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.Congrats Gus! (Man, everyone is passing me!)
BARRY! Great...
"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
January 3, 2011 at 6:13 am
Excellent information. Thanks.
"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
December 30, 2010 at 11:04 am
GSquared (12/30/2010)
I just noticed I hit 10k "points" on SSC today. Good way to end the year, as it were.
Excellent job! Congratulations.
"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
December 30, 2010 at 8:33 am
iamsam.sandeep (12/29/2010)
"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
December 30, 2010 at 6:10 am
Ray Mond (12/29/2010)
RESTORE VERIFYONLY is fairly useless (with regards to data integrity in 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
December 30, 2010 at 6:07 am
gmamata7 (12/29/2010)
Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema....
"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
December 30, 2010 at 6:03 am
Jack Corbett (12/29/2010)
You can get the query text yourself...
"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
December 30, 2010 at 5:58 am
Craig Farrell (12/29/2010)
http://balapalani.blogspot.com/2010_12_01_archive.html
It's roughly a copy/paste...
"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
December 30, 2010 at 5:36 am
What's the deal. You guys can't keep your girl friend satisfied? She sent me four messages last night. She's begging for attention. Come on on gentlemen. Do your duty.
"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
December 30, 2010 at 5:35 am
There is no completely reliable method for retrieving this information. Almost any method you use can be spoofed because a given table is only accessed once a month/quarter/year and if...
"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
December 29, 2010 at 1:43 pm
GRANT CREATE TABLE ON SCHEMA::MySchema TO MyUser
You'd need to do that for PROCEDURE, VIEW, etc.
"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
December 29, 2010 at 1:39 pm
Koen (da-zero) (12/29/2010)
Grant Fritchey (12/29/2010)
Yes a full backup every night means that you should be able to recover up to the last full backup. And, yes, you're right, without...
"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
December 29, 2010 at 12:22 pm
ankur_libra (12/29/2010)
Hi Grant,Thanks for the response and Sorry for posting my question here.:crying:
With regards,
Ankur
No big deal. Like I said, for future reference.
It can just lead to confusion when people...
"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
December 29, 2010 at 9:17 am
Viewing 15 posts - 13,726 through 13,740 (of 22,219 total)