Viewing 15 posts - 18,901 through 18,915 (of 49,552 total)
GilaMonster (4/21/2012)
SET Statistics Time 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
April 21, 2012 at 6:46 am
balasach82 (4/21/2012)
So, now my understanding it that, during reboot, tempdb does make use of model to an extent, but it does not get the size details. Those are got...
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
April 21, 2012 at 6:40 am
SET Statistics Time On
You can compare the exec plans, but do note that lower cost does not always mean faster query, the costs are estimates created at compile time.
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
April 21, 2012 at 5:48 am
It's a lot more complex than 'TempDB uses model as a template'. TempDB isn't actually recreated on startup. It's just cleared and the contents made the same as model.
Now,...
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
April 21, 2012 at 5:46 am
You can if you want, but there's not huge, massive changes in SQL 2012. Some stuff's changed, lots of new stuff, but the fundamentals are the same. There's no guarantee...
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
April 21, 2012 at 5:44 am
balasach82 (4/21/2012)
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
April 21, 2012 at 4:40 am
Rohit Khare (4/21/2012)
Each forum has its own plus and minus. Stack Overflow is not dedicated to SQL Server but a common platform to ask any type of questions.
I didn't suggest...
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
April 21, 2012 at 4:39 am
Rohit Khare (4/21/2012)
The person asking the question will come to know whether the answer is correct or not by trying out and seeing the output.
So, let's say there's a...
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
April 21, 2012 at 4:16 am
No architecture or internals. Later. Basics first, advanced features, architecture and internals later when you have the basics well covered.
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
April 21, 2012 at 4:09 am
If you're fairly new, don't worry about 'mastering' the product. Worry about getting the basics down solid.
For dev, try Itzik Ben-Gan's T-SQL Fundamentals. Fantastic book
For admin, try Beginning 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
April 21, 2012 at 3:43 am
There were massive changes in the optimiser between 2000 and 2005.
First thing. Update your statistics. SQL 2005+ doesn't effectively use the SQL 2000 format statistics.
Run an UPDATE STATISTICS <table name>...
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
April 20, 2012 at 2:43 pm
If you search through the suggestion forum, this comes up every 6 months or so.
What is the 'best answer'? One of the first rules about SQL is that there's seldom...
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
April 20, 2012 at 2:35 pm
Edit: NM, misread.
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
April 20, 2012 at 11:07 am
Lynn Pettis (4/20/2012)
By putting the NOT in the where clause you are basically forcing a table scan.
Not if there's a suitable index.
AdventureWorks (of some version or other)
CREATE INDEX...
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
April 20, 2012 at 10:38 am
A recoding is not going to improve performance.
Perhaps an index on MyColumnName? It'll have to be covering to be of any use if more than about 1% of the table...
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
April 20, 2012 at 10:33 am
Viewing 15 posts - 18,901 through 18,915 (of 49,552 total)