Viewing 15 posts - 9,871 through 9,885 (of 22,232 total)
I think this might be posted on Ask.SQLServerCentral too. But you want to use sys.dm_tran_session_transactions. That will let you get transactions for a session or a session for a transaction.
"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 6, 2013 at 5:44 am
Forgot about this article[/url] completely. It's got the same title as your question, part of why I alerted to this one.
"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 6, 2013 at 5:22 am
Jason has it right. Unless you're running differentials, you can just run a regular full backup.
Since you're just getting going, you might want to check out Shawn McGehee's book on...
"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 6, 2013 at 5:19 am
Jeff Moden (4/30/2013)
L' Eomot Inversé (4/30/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
April 30, 2013 at 3:37 pm
Evil Kraig F (4/26/2013)
Grant Fritchey (4/26/2013)
TheGreenShepherd (4/26/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
April 29, 2013 at 4:07 am
TheGreenShepherd (4/26/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
April 26, 2013 at 10:08 am
jasona.work (4/26/2013)
As for smuggling back Canucks, do we want the hockey players (in which...
"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
April 26, 2013 at 8:10 am
zi (4/26/2013)
(you may have to run a checkpoint or two before the log rolls over to the free space to allow shrinking) will work,how to run a checkpoint?
Thanks
It's 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
April 26, 2013 at 8:09 am
zi (4/26/2013)
is it correct to convert the recovery model to simple then shrink the log fileThanks
That question is best answered by the people who use your database. How much 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
April 26, 2013 at 7:32 am
ralbers (4/26/2013)
This article is very helpfull. One question: is it also advisable to use these constraints in sqlserver2005?thanx,
Riet Albers
Yes. Same rules.
"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
April 26, 2013 at 5:23 am
After you either backup your log or switch your database to simple recovery, you can shrink the log file. But you need to do one or the other. I have...
"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
April 26, 2013 at 4:16 am
elfishae15 (4/26/2013)
how to insert sql script in flash which will be displayed on the web?? what it could be??Gejala Kanker[/url], Cara Membuat Kue[/url], Cerita Anak[/url]
To get a good set of...
"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
April 26, 2013 at 3:44 am
neeraj.it (4/25/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
April 26, 2013 at 3:36 am
So you're joining one view to another to another to arrive at a final view that contains all the other views nested? That's almost as bad an approach as 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
April 25, 2013 at 11:20 am
As the others have said, it could be anything. They didn't list contention, so I'll toss that out there too.
Posting the query & structure along with an actual execution plan...
"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
April 25, 2013 at 11:17 am
Viewing 15 posts - 9,871 through 9,885 (of 22,232 total)