Viewing 15 posts - 39,436 through 39,450 (of 49,552 total)
Paul White (4/28/2009)
Would that not work then? :laugh:
It'll work, that ain't the point
The latest suggestion in the date-time to date precision discussion, is to store the date part in 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 28, 2009 at 7:34 am
http://sqlinthewild.co.za/index.php/2008/11/04/what-are-statistics-and-why-do-we-need-them/
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 28, 2009 at 7:28 am
Kurt W. Zimmerman (4/28/2009)
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 28, 2009 at 7:27 am
Tao Klerks (4/28/2009)
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 28, 2009 at 7:22 am
Grant Fritchey (4/28/2009)
SELECT * FROM TEST101
WHERE CODE=105 AND ACNO=14000
ORDER BY CODE
--WHY IT IS GOING FOR CLUSTRED INDEX OF COLUMN "ID"
--Now it is going for non clustered index, this 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
April 28, 2009 at 7:21 am
Paul White (4/28/2009)
On a separate subject, can I ask: Are articles checked or reviewed before publication on SSC?
There's no technical review done, if that's what you're asking. Firstly Steve's vision...
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 28, 2009 at 7:11 am
johny (4/28/2009)
Yes. The records that end with '9' take more time every time.
Can you post output of statistics IO and Statistics 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 28, 2009 at 7:08 am
Schadenfreude-Mei (4/28/2009)
We are thinking of putting in a log shrink after the backup, but i wanted to check that this was also going to be replicated to the mirror.
Why,...
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 28, 2009 at 6:55 am
Simon Smith (4/28/2009)
For example the concept of locking seems to have bypassed them and locking whole tables whilst reporting is common.
*twitch* Ouch
I could do without the hassle of setting...
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 28, 2009 at 3:12 am
From Books Online:
Use the remote query timeout option to specify how long, in seconds, a remote operation can take before Microsoft SQL Server times out. The default is 600, which...
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 28, 2009 at 3:10 am
mithun.gite (4/27/2009)
SELECT * FROM TEST101--WHY IT IS GOING FOR CLUSTERED INDEX OF COLUMN "ID"?
Because there's no filter of any form. That query reads the entire table, hence the only 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
April 28, 2009 at 2:58 am
Bear in mind that there have been changes to what's considered valid SQL in SQL 2005. If the app uses any of that it will break on SQL 2005.
Perhaps I...
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 28, 2009 at 2:56 am
riga1966 (4/27/2009)
or you need to configure SQL to start capturing this type of things?
How do I...
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 28, 2009 at 2:46 am
Simon Smith (4/28/2009)
Are there any reasons as to why you can't upgrade a database straight from SQL2000 to SQL2005.
You can. I've done so on a number of occasions.
There are...
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 28, 2009 at 2:41 am
Any chance you can post the plans as .sqlplan files (zipped)? The xml should be the same across all languages so, if I load it into my management studio, I'll...
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 28, 2009 at 2:35 am
Viewing 15 posts - 39,436 through 39,450 (of 49,552 total)