Viewing 15 posts - 4,501 through 4,515 (of 22,219 total)
When I've automated restore processes, I've usually had access to msdb to retrieve the data directly. It sure makes things easier. Plus, we usually had standard drive configurations & folders,...
"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
August 24, 2016 at 7:57 am
navtec (8/24/2016)
I'm using sql server...
"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
August 24, 2016 at 7:37 am
It will do the business validations, absolutely. You just have to write the tests. There's not a tool out there that knows your business well enough to automatically generate tests...
"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
August 24, 2016 at 7:36 am
Jeff Moden (8/23/2016)
Grant Fritchey (8/16/2016)
"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
August 24, 2016 at 6:43 am
durga.palepu (8/24/2016)
Hi all,Can somebody explain if there are any tools available to unit test the functional test cases in database?
Thanks,
Durga Prasad.
Yes. See my post above. T-SQLT and SQL Test [/url]from...
"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
August 24, 2016 at 6:34 am
Benki Chendu (8/24/2016)
Will I be able to download evaluation editions of sql 2008/2014 on the VM for free of cost?
For things like this, it's a VM. That means the same...
"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
August 24, 2016 at 6:21 am
The biggest driving factor for seeing any kind of performance benefit (and more frequently, for avoiding a performance degradation), is the ability to absolutely ensure that the overwhelming majority 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
August 24, 2016 at 6:19 am
navtec (8/24/2016)
Ok thanks.Still very strange why SQL Server would pick up on nvarchar data type as a LOB data type though.
Go and read the documentation on the (MAX) setting for...
"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
August 24, 2016 at 6:16 am
You have a timeout as it says in the error message: Timeout expired
Your server could be offline. You could simply have a very low client-side timeout setting. You could 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
August 24, 2016 at 6:12 am
For unit testing within SQL Server, I'd suggest looking at T-SQLT[/url]. It's unit testing for SQL Server and open source. If you want to automate the process and have reports,...
"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
August 23, 2016 at 4:19 pm
curious_sqldba (8/23/2016)
mw112009 (8/23/2016)
I use SQL sever 2012.Need to install AdventureWorks for a tutorial. Can you please provide the URL where I could download
Have you googled? Would have taken you less...
"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
August 23, 2016 at 4:15 pm
SQLRNNR (8/23/2016)
GilaMonster (8/23/2016)
Steve Jones - SSC Editor (8/23/2016)
Lynn Pettis (8/23/2016)
Luis Cazares (8/23/2016)
Gail, you just made my day with this answer. http://www.sqlservercentral.com/Forums/FindPost1811748.aspxI can't stop laughing. 😀
omg
congrats. One day I'll get there
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
August 23, 2016 at 3:54 pm
Ray K (8/23/2016)
Woo-hoo! Just found out that I'm speaking at SQL Saturday #545 in Pittsburgh!
Well done.
"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
August 23, 2016 at 3:53 pm
I'm right there with Lowell. Severely corrupt databases are fixed by restoring a good backup (which also means validation of consistency is a part of the backup process). It does...
"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
August 23, 2016 at 10:19 am
You can get by with one or two DRCs. It depends on how much you're attempting to simulate precise load and how much you just want "a" load.
I would 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
August 23, 2016 at 10:14 am
Viewing 15 posts - 4,501 through 4,515 (of 22,219 total)