Viewing 15 posts - 10,321 through 10,335 (of 22,224 total)
harri.reddy (10/22/2012)
they gave me some tables(approx 9) tables and field that they want to fecth only those field.
they all r master table.so do i need to make table that connect...
"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:06 pm
sql-lover (10/22/2012)
Grant Fritchey (10/22/2012)
sql-lover (10/22/2012)
I thought deadlocks (most of them) were due poor or bad code; 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:45 pm
sql-lover (10/22/2012)
I thought deadlocks (most of them) were due poor or bad code; a process pinning other...
"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:12 am
I used to use CodeSmith. But that was when they were hosted on CodePlex. It's moved to GoogleCode [/url]and I'm not sure it's the same. Still, might be worth checking...
"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:08 am
But, you can get it if you need it from 3rd party products such as Red Gate SQL Storage Compress[/url].
"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:05 am
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
Viewing 15 posts - 10,321 through 10,335 (of 22,224 total)