Viewing 15 posts - 25,816 through 25,830 (of 49,552 total)
If I'm understanding you correctly...
Inner join is a join that's specified either as JOIN or INNER JOIN. The join predicate (comparison) can be anything. It requires matching rows.
An Equi-join is...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 11:47 pm
In 2008 it should be treated just as if it were a dll, a library file for SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 2:05 pm
SQLRNNR (5/31/2011)
Oh, and one more - DNR
Dot Net Rocks? (http://www.dnrtv.com)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 1:22 pm
By the way, what you're proposing is no different from taking regular log backups and deleting the resultant log backup files.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 1:21 pm
carloscolombo 39235 (5/31/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 12:41 pm
The Dixie Flatline (5/31/2011)
Bob Hovious - MBSCSDD/FUBAR/BOHICA
Bob! Where you been?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 12:33 pm
Damian Widera-396333 (5/31/2011)
What is the *REAL* question here?
The one the thread started with 3 years ago, or the current ones being discussed (26000 posts later)?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 11:56 am
SQLRNNR (5/31/2011)
I like the AAO, CSF and OCD acronyms personally.
What do AAO and CSF stand for?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 11:49 am
SQLRNNR (5/31/2011)
Craig Farrell (5/28/2011)
*chanting*I will not smack Syed with a heavy hand...
I will not smack Syed with a heavy hand...
I will not smack...
*mumbles off to another room, still chanting*
I'm thinking...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 11:44 am
RTaylor2208 (5/31/2011)
Company policy deems this as maintenance that has to be performed during a maintenance window.
Hmmm... do the people that wrote the company policy know that SQL automatically updates statistics...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 8:11 am
greg.wollman (5/31/2011)
1.) What could be causing the Index degradation so early in the day when the Maintenance Plans were just complete the night before?
Incorrect statistics? Sounds like it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 8:08 am
Why do you need a maintenance window to update statistics?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 7:57 am
Yeah, don't use detailed.
As per Books Online
The LIMITED mode is the fastest mode and scans the smallest number of pages. For an index, only the parent-level pages (that is,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 7:46 am
ashok.faridabad1984 (5/31/2011)
Please explain then why execution plan is index seek for the below query in the same situation ,index created on the table is still non clustered :
Please read the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 6:59 am
forsqlserver (5/31/2011)
Thanks Gail, I have already said this is my test DB,I have 2 GB RAM ...
That it's your test DB is irrelevant. You do not have enough memory on...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 31, 2011 at 6:47 am
Viewing 15 posts - 25,816 through 25,830 (of 49,552 total)