Viewing 15 posts - 3,211 through 3,225 (of 9,644 total)
A shared lock will have to be taken on Table2 resources in any situation. Think about it this way, you are updating table1 based the relationship with table2. ...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2010 at 7:35 am
From BOL (this article):
Rebuilding an index drops and re-creates the index. This removes fragmentation, reclaims disk space by compacting the pages based on the specified or existing fill factor setting,...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2010 at 7:26 am
Leon Venediktou (3/10/2010)
declare @a int, @b-2 int, @c...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2010 at 7:02 am
Nice article Jason. I'll be interested in what you find from Event Notifications.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 11, 2010 at 6:48 am
Elliott W (3/10/2010)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 10, 2010 at 7:06 pm
Vivek29 (3/9/2010)
It will.I witnessed it.See my post..I said after clearing cache, perform shrink operation.:smooooth:
But why would you need to clear the cache (RAM) to shrink tempdb (disk)? Makes no...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2010 at 2:02 pm
CirquedeSQLeil (3/9/2010)
Vivek29 (3/9/2010)
Run this before performing shrink operation.Use tempdb
go
DBCC FREESYSTEMCACHE(ALL);
DBCC FREESESSIONCACHE;
then perform your shrink operation.
Thanks
Vivek
Why?
Because shrinking TempDB is going to slow everything down, you might as well refresh the cache...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2010 at 1:34 pm
Lynn Pettis (3/8/2010)
Paul White (3/8/2010)
Anyone else noticed the frenzy of poor advice recently? Moderately aggravating.
Yes, I have. I just hope I haven't been a party to some of...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 9, 2010 at 10:44 am
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
The 3 Orlando ones have been between 225-275. I think they've been as small as 75-100 and as big...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 8, 2010 at 11:58 am
WI-DBA (3/8/2010)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 8, 2010 at 7:40 am
I don't know of a way to do it in the report body because the PageNumber and TotalPages items are only allowed in a page footer or header. Why...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 6, 2010 at 9:23 am
Are you re-running your select of next_run_time in the VB.NET app after you set the time.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 6, 2010 at 9:06 am
Hope that works out for you.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 5, 2010 at 1:37 pm
GilaMonster (3/5/2010)
Jack Corbett (3/5/2010)
If you are already known as a top-level person (Grant, Gail, etc..), then the cert is unnecessary.
When you're bidding for work (consulting), a collection of qualifications can...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 5, 2010 at 1:25 pm
Here's a KB Article that talks about how TCP Offloading works and how to enable/disable it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 5, 2010 at 10:00 am
Viewing 15 posts - 3,211 through 3,225 (of 9,644 total)