Viewing 15 posts - 10,321 through 10,335 (of 22,219 total)
They gave you fields & data lengths, cool. But are they defined as tables or as objects or just as interesting pieces of information that the business wants to see?...
"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 22, 2012 at 11:04 am
And the godfather of Extended Events has an XEvent A Day series of blog posts. Jonathan is frequently a better resource for this stuff than Microsoft.
"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 22, 2012 at 7:12 am
You have to include the database name if the database resides on the same server:
SELECT *
FROM MyDatabase.MySchema.MyTable;
That will get it done. You can then join on the appropriate column.
"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 22, 2012 at 7:07 am
Just know that the backup size is not just the data size. It also includes some header information (very small) and open transactions that are rolled forward or rolled back...
"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 22, 2012 at 7:05 am
If you look to the left side of the screen there is a link there labeled "Stairways." That is a series of lesson plans on various aspects of becoming a...
"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 22, 2012 at 6:55 am
Yes, someone who achieves Senior should have special knowledge of parts of SQL Server and should be a go-to resource. I agree.
"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 20, 2012 at 5:34 am
You can use PowerShell in combination with the ability to generate scripts to do it for multiple databases. If you search Allen White's blog I know he has a script...
"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 19, 2012 at 11:34 am
You're getting the stalls from the DMO. That's the thing to use.
"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 19, 2012 at 11:29 am
GilaMonster (10/19/2012)
Sean Lange (10/19/2012)
"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 19, 2012 at 11:19 am
Sean Lange (10/19/2012)
"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 19, 2012 at 11:12 am
A stall isn't the amount of time it took to write to the disk, rather it's the time spent waiting during the writes to the disk. I wouldn't compare 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
October 19, 2012 at 11:11 am
I'm not sure this is a schema question. There are technologies within SQL Server that will allow you to track changes, such as Change Data Capture. I'd suggest those before...
"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 19, 2012 at 11:10 am
I'm sure I won't use the appropriate terms, but usually I've seen the break downs something like this:
Junior DBA
DBA
Senior DBA
Data Architect
At my last place of employment they didn't have Data...
"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 19, 2012 at 10:24 am
Threadizens!
Who will be at Connections in Vegas? Steve and I will be. Anyone else?
And then, the week after is the Summit. Oi or is it Oy or do both apply?
"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 19, 2012 at 6:44 am
Microsoft doesn't support backward compatibility like that. However, you can try. You'd have to uninstall SQL Server and the install the older version. You'll want to test a backup and...
"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 19, 2012 at 5:56 am
Viewing 15 posts - 10,321 through 10,335 (of 22,219 total)