Viewing 15 posts - 6,211 through 6,225 (of 22,226 total)
RamSteve (4/30/2015)
"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
April 30, 2015 at 7:32 am
YOu can do either, but I'd recommend setting it for the database.
"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
April 30, 2015 at 6:55 am
Shrinking the database files is shrinking the database files. Backing up a database is doing a page by page copy of the database and backing up the log is copying...
"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
April 30, 2015 at 6:54 am
TheSQLGuru (4/30/2015)
This is coming from the Database Manager at our new company.
That seems to have been missed. Sadly it is MANAGEMENT/LEADERSHIP that is forcing these ridiculous requirements, not 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
April 30, 2015 at 6:38 am
Use extended events[/url]. They have great filtering and can capture just the queries executed by a given user.
"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
April 30, 2015 at 6:04 am
I'm going to punt. I haven't used page restore in a production system, so I'm not going to try to advise you since important data is on the line.
"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
April 29, 2015 at 4:08 pm
Tom_Sacramento (4/29/2015)
I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than...
"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
April 29, 2015 at 4:05 pm
Tom_Sacramento (4/29/2015)
I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than...
"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
April 29, 2015 at 4:04 pm
SQLRNNR (4/29/2015)
Steve Vassallo (4/29/2015)
"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
April 29, 2015 at 3:54 pm
Steve Vassallo (4/29/2015)
"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
April 29, 2015 at 3:43 pm
Sure thing. Best of luck. Report back what you get for a grade. I'm curious.
"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
April 29, 2015 at 11:33 am
For a 42gb database, 8gb of memory is not that low really. But, it does depend on the types of queries and everything else.
I put nearly zero faith 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
April 29, 2015 at 9:54 am
The Powershell solution is the way to go. It's using SMO calls in the same way as the GUI. That will generate the code the way you're expecting 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
April 29, 2015 at 9:45 am
While I agree with everyone that these tables are not properly normalized, in an effort to help, can you tell me which tables you're trying to understand the relationships between?
You...
"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
April 29, 2015 at 9:43 am
spaghettidba (4/29/2015)
Grant Fritchey (4/29/2015)
"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
April 29, 2015 at 9:34 am
Viewing 15 posts - 6,211 through 6,225 (of 22,226 total)