Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dmilam
Posting Yak Master
185 Posts |
 Posted - 2011-02-21 : 19:44:07
|
| for the developer (not the DBA)Good links that YOU have learned from? I have one for 2000 but I'd like a few for 2005. |
|
|
dmilam
Posting Yak Master
185 Posts |
Posted - 2011-02-21 : 19:54:56
|
| Just added a primary key to one of my tables and the query time was significantly shortened! |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-02-22 : 04:18:31
|
| Its not the primary key that has improved the performance.It is rather the clustered index which gets created by default when you define a column as a primary key.PBUH |
|
|
|
dmilam
Posting Yak Master
185 Posts |
Posted - 2011-02-22 : 12:35:09
|
| That makes sense, thanks. I can see why Azure requires a clustered index. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-22 : 13:12:14
|
Graz posted a list of his favorite sites/blogs a while back: http://weblogs.sqlteam.com/billg/archive/2009/05/22/SQL-Server-sites-I-visit.aspxquote:
for the developer (not the DBA)
There's no such thing as performance tips for a "developer" vs. DBA, it's all the same engine regardless of who uses it. In fact I just read this excellent article today:http://sqlblog.com/blogs/paul_white/archive/2011/02/23/advanced-tsql-tuning-why-internals-knowledge-matters.aspxNow it deals with internal structures and storage for SQL Server...not something a developer typically worries about, but he makes the case near the end WHY a developer should know about them because of how they impact performance. It's a long read but definitely worth it, and a model for the kind of articles you should read. |
|
|
|
dmilam
Posting Yak Master
185 Posts |
Posted - 2011-02-22 : 16:58:25
|
| Thanks, Rob. There are some analyses/tests I cannot perform, however, which I see in many an article, because I don't have permissions to run them. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-02-22 : 17:15:39
|
| Don't you have a development or test server to run them on? |
|
|
|
dmilam
Posting Yak Master
185 Posts |
Posted - 2011-02-22 : 17:44:46
|
| Sadly, no. I work in an organization that does not provide such. I think it's time for a new job... |
|
|
|
|
|
|
Performance tips