Viewing 15 posts - 25,981 through 25,995 (of 49,552 total)
SQL 2005 32 bit or 64 bit? Are you installing 32 bit or 64 bit?
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 23, 2011 at 9:33 am
Jack Corbett (5/23/2011)
Just because I've touched it doesn't mean I'm an expert.
It doesn't? Really?
😉
Wish more people thought that way.
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 23, 2011 at 8:59 am
Query Analyser as in SQL 2000? No way to save the plan if dealing with either Query Analyser of a SQL 2000 backend.
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 23, 2011 at 8:35 am
pnr8uk (5/23/2011)
SET @TRem = (select TRem from Test1) -- check only
What happens if there's more than one row in Test1?
Is this a homework exercise?
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 23, 2011 at 8:11 am
CREATE TABLE StudentClass (
std_id INT FOREIGN KEY REFERENCES Student (std_id),
class_id INT FOREIGN KEY REFERENCES Class (class_id),
CONSTRAINT pk_StudentClass PRIMARY KEY (std_id, class_id)
)
(I also fixed your foreign key references)
Why not student_id? Not...
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 23, 2011 at 5:07 am
http://www.google.com/search?q=version+store+%22sql+server%22
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 23, 2011 at 5:04 am
http://www.google.com/search?q=row+versioning+%22sql+server%22
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 23, 2011 at 5:03 am
http://www.google.com/search?q=execution+plan+operators
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 23, 2011 at 5:01 am
http://www.google.com/search?q=SQL+lazy+writer
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 23, 2011 at 5:00 am
They're created by the query optimiser when it needs to know the row distribution of a column and there are no existing statistics.
Read up on statistics and auto_create_statistics in Books...
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 23, 2011 at 4:59 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1113142-149-1.aspx
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 23, 2011 at 4:34 am
What needs elaborating?
Row versions are created with snapshot isolation level. They're historical versions of rows used for transactions/statements that began before the row was changed.
The version store is the place...
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 23, 2011 at 4:32 am
sqlnaive (5/23/2011)
Does having so many statistics on the table harm the performance ?
Nope.
We run our maintenance schedule every Sunday and rebuild indexes [update stats are OFF]. Does stats...
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 23, 2011 at 4:23 am
Version store is where the row versions (created for snapshot isolation) are stored.
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 23, 2011 at 4:22 am
EdVassie (5/23/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 23, 2011 at 4:05 am
Viewing 15 posts - 25,981 through 25,995 (of 49,552 total)