Viewing 15 posts - 6,106 through 6,120 (of 22,221 total)
Build a database that categorizes your books, movie collection, My Little Pony collection, whatever. Take the time to normalize, think about the possible reports you could run 'All science fiction...
"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
May 15, 2015 at 6:12 am
If you connect to the server using SQL Server Management Studio, you'll see which database is offline or in suspect mode. Otherwise, you can query sys.databases to see the current...
"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
May 15, 2015 at 6:08 am
There are a couple of small ways you can manipulate plan cache though. You can drop an individual plan from cache by passing the plan handle. You can also avoid...
"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
May 15, 2015 at 6:06 am
I would probably look to Extended Events to track this. You'd probably need to capture individual statements. If you use Causality Tracking, you should be able to see the chain...
"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
May 15, 2015 at 6:02 am
It is possible for the backup itself to become corrupted. I'm with Eirikur, test it on the client side first to see if they get the same issue.
"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
May 15, 2015 at 5:59 am
GilaMonster (5/14/2015)
Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...
"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
May 15, 2015 at 4:22 am
Vyper426 (5/14/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
May 15, 2015 at 4:10 am
jasona.work (5/13/2015)
:hehe:
On an unrelated note, does anyone here have any experience with Barracudda Networks backup appliance, both...
"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
May 14, 2015 at 1:01 am
Paul Randal (5/13/2015)
If you're offloading DBCC...
"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
May 14, 2015 at 1:00 am
Jeff Moden (5/13/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
May 14, 2015 at 12:56 am
SQLRNNR (5/13/2015)
Grant Fritchey (5/13/2015)
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
Maybe in...
"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
May 14, 2015 at 12:52 am
For a point lookup (one row) against a clustered index, there really isn't a major performance hit.
But, some of the places where there are issues. First, pages in memory. By...
"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
May 13, 2015 at 10:07 am
Also, I need a new head, FILESTREAM data is stored apart from the database, but is backed up and restored through the backup process.
"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
May 13, 2015 at 9:57 am
One point. i said that BLOB storage was outside the database. That's not right. Not sure where my head was. Gail spotted it and corrected me.
"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
May 13, 2015 at 7:38 am
GilaMonster (5/13/2015)
Grant Fritchey (5/13/2015)
Because you can have physical corruption that doesn't get backed up or restored.
How?
I keep hearing this advice, but the problem is it doesn't bear out. Backups are...
"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
May 13, 2015 at 7:32 am
Viewing 15 posts - 6,106 through 6,120 (of 22,221 total)