Viewing 15 posts - 9,451 through 9,465 (of 22,224 total)
Yep, Jonathan's blog and the Microsoft documentation are the way to go. Between the two you'll learn most of what you need.
"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 10, 2013 at 5:53 am
yeah, that'll help. The buffers don't get too specific, or rather, they get way too specific. If you expand them out, there's all sorts of information. It's just that most...
"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 8, 2013 at 3:58 am
Storage is just disks (or LUNs, or whatever). Nothing special about it at all. That's a big part of what makes it attractive. You don't have to have an specifics...
"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 7, 2013 at 12:39 pm
SQLRNNR (10/7/2013)
Steve Jones - SSC Editor (10/7/2013)
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Stand up in the middle as if to make an announcement and commence the "fun"?Nope. But have something in mind.
Panel cage match?...
"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 7, 2013 at 9:02 am
Jack Corbett (10/7/2013)
GilaMonster (10/7/2013)
Jack Corbett (10/7/2013)
"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 7, 2013 at 7:56 am
Kurt W. Zimmerman (10/7/2013)
Grant Fritchey (10/7/2013)
Create a script that restores the database and make the procedures you need part of the script (after the restore of...
"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 7, 2013 at 7:53 am
This question was asked in more than one forum. Please put all further responses on this post since two of us have already responded over 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
October 7, 2013 at 7:37 am
Wait, didn't you already ask this question on another forum here at SQL Server Central?
Please don't do that. It leads to multiple answers and confusion across the discussions. As 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
October 7, 2013 at 7:35 am
Don't manually restore the database.
Create a script that restores the database and make the procedures you need part of the script (after the restore of course). You can then schedule...
"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 7, 2013 at 7:33 am
You're going to need to be more specific.
SQL Server comes with a process called SQL Agent which is used for scheduling jobs, setting up alerts and other things. That is...
"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 7, 2013 at 7:32 am
The role of the DBA is generally considered somewhat vital to the organizations that hire one. So, in general, they don't hire people with zero experience. There are exceptions 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
October 7, 2013 at 7:30 am
Jack Corbett (10/7/2013)
Jeff Moden (10/5/2013)
Speaking of "unbelievable", is [font="Arial Black"]THIS[/font] all that a Master's degree + the ability to walk on water is worth nowadays?
In some parts of...
"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 7, 2013 at 7:25 am
Yep. This site is very good. You can also look to ask.sqlservercentral.com for simple question/answer style of issues. You can also look to Simple-Talk.com to for in-depth articles.
"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 7, 2013 at 6:27 am
What about just putting the create procedure scripts into the same set of commands that restore the database. Assuming you're using SQL Agent to automate the execution of the restores,...
"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 7, 2013 at 6:26 am
2gb is a VERY small amount of memory for SQL Server. How much data are you trying to retrieve? How big is the query? The message you're receiving is very...
"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 7, 2013 at 6:21 am
Viewing 15 posts - 9,451 through 9,465 (of 22,224 total)