Viewing 15 posts - 1,726 through 1,740 (of 3,221 total)
create table dbo.TEST_TEACHER (
MEMB_ID varchar(10),
SELECTION_DT datetime,
TEACHER_ID varchar(10))
insert into TEST_TEACHER select '123', '2009-10-01', 'P654'
insert into TEST_TEACHER select '123', '2009-11-01', 'P987'
insert into TEST_TEACHER select '123', '2009-12-01', 'P321'
insert into TEST_TEACHER select '123', '2010-01-01',...
September 21, 2010 at 3:08 pm
I would suggest reading these articles, espcially those by Gail Shaw, for guidance.
Finding the Causes of Poor Performance in SQL Server, Part 1 by Gail Shaw
Finding the causes of...
September 21, 2010 at 9:59 am
To answer questions of this nature, uese the SET STATISTICS TIME, IO ON and you can learn for yourself what the effects of with [ ] or without...
September 21, 2010 at 9:30 am
Jeff Moden (9/20/2010)
P.S. I really want to know when you took up mind-reading, Ron. I was about to post and ask for a full run like that. Thanks.
Jeff...
September 20, 2010 at 5:10 pm
Go to this link for the stored procedures and scripts to run them.
http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.aspx
September 20, 2010 at 4:56 pm
You can copy the complete scripts from this link
http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-2005-performance-statistics-script.aspx
September 20, 2010 at 4:18 pm
Jeff using Brad Schulz blog post on using option(Force order,Maxdop 1, Loop Join).
http://bradsruminations.blogspot.com/2010/08/taking-hint.html
Again SQL Server 2008 on my bigger machine
...
September 20, 2010 at 2:13 pm
Jeff ... ran test with the trace flag on (and yes I turned it off when the test completed).
Posted my results at Posted Today @ 11:25 AM
September 20, 2010 at 11:47 am
Brad Schulz
Attempted to view your plans Microsoft Internet Explorer 7 . Result:
The XML page cannot be displayed
Cannot view XML input using style sheet. Please correct the error...
September 20, 2010 at 11:12 am
Jeff tested Brad Schulz's code, as posted by yourself, but I added two lines (DBCC TRACEON(8690,-1) per Paul White NZ and then tested
--===== Do this in a nice safe place...
September 20, 2010 at 9:25 am
Jeff from the AdventureWorks2008 that was utilized in my tests of Brad Schulz's code, as posted by yourself. Table defs from SSMS 2008 using the "Script As" feature.
[USE [AdventureWorks2008]
GO
/******...
September 20, 2010 at 7:33 am
Results using the Brad Schulz (as posted by Jeff)
Again SQL 2005 and SQL 2008 on the larger faster machine, and SQL2005 Express on the smaller slower box.
September 20, 2010 at 6:39 am
Jeff Moden (9/19/2010)
bitbucket-25253 (9/19/2010)
Result for SQL 2005 Express using code...
September 19, 2010 at 1:55 pm
Jeff ran test on the oldest, least amount of memory, slowest desktop, age - older than dirt. Running Windows XP
Result for SQL 2005 Express using code after it was...
September 19, 2010 at 12:27 pm
Results for SQL 2005 Developer edition run on a desk top with slightly more memory and slightly higher speed Running Windows XP
Using the code you edited at 10:48 edit
So...
September 19, 2010 at 10:49 am
Viewing 15 posts - 1,726 through 1,740 (of 3,221 total)