Viewing 15 posts - 9,631 through 9,645 (of 22,224 total)
Hmmm... This is 2008 right? How about putting extended events to work. You could try a few events like database_created, database_file_size_change, database_started, database_data_file_size_changed, file_written. It's not an investigation I've launched...
"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 29, 2013 at 6:29 am
Sean Pearce (8/29/2013)
http://www.apexsql.com/sql_tools_log.aspxApexSQL Log
Order now from $1,499 :w00t:
But that just reads the log. It doesn't read log backups.
Plus, you don't need a tool to read the log. There's an undocumented...
"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 29, 2013 at 6:20 am
Youch.
First, I'd toss the query hints. Then, get rid of all the functions on columns in the JOIN criteria and WHERE clause. After that... who knows. I'm not even addressing...
"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 29, 2013 at 4:40 am
No, that's pretty abnormal. I just did a test on one of my servers and I didn't see any difference at all in the time to create a database using...
"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 29, 2013 at 4:34 am
Koen Verbeeck (8/28/2013)
JLMayes (8/28/2013)
TravisDBA (8/28/2013)
Agreed, but let's make sure ALL the facts are uncovered first before calling anyone out. Otherwise, it just turns the whole situation into a witch hunt.:-D
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
August 28, 2013 at 3:49 pm
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
Viewing 15 posts - 9,631 through 9,645 (of 22,224 total)