Viewing 15 posts - 9,631 through 9,645 (of 22,219 total)
I have done something similar in the past, although it was all within a single domain. However, you should be able to adjust the basic scripts I've posted to my...
"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 28, 2013 at 11:36 am
Just a suggestion, you should start a blog or write an article for SQL Server Central on something like this. You can get a lot more hits that way rather...
"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 28, 2013 at 11:25 am
I'm not aware of a tool that lets you directly read a log backup file. I'm sure there's a way to do this (for example, Red Gate has a tool...
"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 28, 2013 at 11:22 am
craig.schlieve (8/28/2013)
I am incredibly disappointed in you. This article is disgusting. You are advocating that groups form that will cause fractures in the community to do 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
August 28, 2013 at 7:31 am
I'm floored by this one too.
And while I absolutely agree with the sentiment that the idiot, uh, I mean, the alleged offender, should be publicly called out, the situation 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 28, 2013 at 6:35 am
Simplest suggestion I can make here is to let the relational system work like a relational system. Use the tools provided because they are a part of how 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 28, 2013 at 4:40 am
Don't forget the "one true index." All we need is a single, perfect, clustered index that will be all things to all people for all queries for all time. Any...
"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 26, 2013 at 6:35 am
jcrawf02 (8/22/2013)
I always suspected Grant was really an owl
Nice! I like 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
August 22, 2013 at 7:12 am
hunchback (8/21/2013)
SQL Server uses different approach to estimate cardinality when you use parameters or...
"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 21, 2013 at 12:33 pm
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.
No, the same thing, 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 20, 2013 at 9:33 am
GilaMonster (8/20/2013)
Grant Fritchey (8/20/2013)
I thought the internal/hidden snapshot was a different critter than the snapshots we create. But, hey, happy to be wrong.
No, the same thing, same behaviour, same mechanics.
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
August 20, 2013 at 9:11 am
GilaMonster (8/20/2013)
Grant Fritchey (8/20/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
August 20, 2013 at 8:20 am
HanShi (8/20/2013)
Grant Fritchey (8/20/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
August 20, 2013 at 7:24 am
First question, always, slow as compared to what? You need to understand where to focus your efforts.
Assuming, as Jeff points out, we have indications of a database problem, then move...
"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 20, 2013 at 7:19 am
A backup is a page by page copy of the database. A restore is therefore also a page by page copy of the database. There is no way to modify...
"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 20, 2013 at 7:07 am
Viewing 15 posts - 9,631 through 9,645 (of 22,219 total)