http://www.windowsitpro.com/authors/author/author/5570212/rsscomment/5570212en-USSun, 27 May 2012 07:04:29 GMTSun, 27 May 2012 07:04:29 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/quick-look-at-sql-server-configuration-for-performance-indications-139446#commentsAnchorTue, 08 May 2012 06:54:12 GMT
Hi, How i can change these settings? for example the maximum memory.]]>NeowolfTue, 08 May 2012 06:54:12 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/quick-look-at-sql-server-configuration-for-performance-indications-139446#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-the-best-value-for-the-fill-factor---index-fill-factor-and-performance--part-2-139448#commentsAnchorThu, 10 Feb 2011 22:23:52 GMT
Hi Pinal,
I have been reading your articles from last couple of months on your blog and found it very interesting and informative. This series of performance tunning is equally interesting. I like your way of going slow from high level towards the deep into the subject matter. I appreciate your sharing of knowledge with the IT community. Looking forward to your next post. ]]>Shakil MakaniThu, 10 Feb 2011 22:23:52 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-the-best-value-for-the-fill-factor---index-fill-factor-and-performance--part-2-139448#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-the-best-value-for-the-fill-factor---index-fill-factor-and-performance--part-2-139448#commentsAnchorThu, 03 Feb 2011 05:46:24 GMT
Great post Pinal!!! Provided a lot of insight into the subject.

One quick though

How does a reorganize impact fill factor?]]>SoniaThu, 03 Feb 2011 05:46:24 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-the-best-value-for-the-fill-factor---index-fill-factor-and-performance--part-2-139448#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-fill-factor---index-fill-factor-and-performance---part-1-139447#commentsAnchorMon, 24 Jan 2011 12:46:57 GMT
Hi Pinal,

It was very good learning experience by reading through your post. Hope if you could explain bit more about the upcoming topics and also let the readers know why we use this, pros and cons etc. This is just a suggestion.

Thanks
Satya.]]>Satya Prasad VinjamuryMon, 24 Jan 2011 12:46:57 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/what-is-fill-factor---index-fill-factor-and-performance---part-1-139447#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/quick-look-at-sql-server-configuration-for-performance-indications-139446#commentsAnchorTue, 18 Jan 2011 21:22:33 GMT
Really nice article! I’ll be following closely.]]>Andrew BrittainTue, 18 Jan 2011 21:22:33 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/quick-look-at-sql-server-configuration-for-performance-indications-139446#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorFri, 07 Jan 2011 10:56:55 GMT
Nice, just learned much in the few lines of this.
Thanks Dave]]>Raymond.AFri, 07 Jan 2011 10:56:55 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorThu, 06 Jan 2011 16:59:46 GMT
Awesome !! Great to have you on SQLMag Pinal. I’ve been following you for years, your blog has saved me so many times. I’ve also been collecting file and wait stats for about 6 months but can’t make heads or tails out of the data yet, so you’ll be saving me again :)]]>kgerbrThu, 06 Jan 2011 16:59:46 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorThu, 06 Jan 2011 11:28:10 GMT
Awesome! So looking forward to your next post. Thanks]]>sweetchillsThu, 06 Jan 2011 11:28:10 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorThu, 06 Jan 2011 10:00:09 GMT
Nice start Pinal. Looking forward to read more from you.]]>SuriThu, 06 Jan 2011 10:00:09 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorhttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorThu, 06 Jan 2011 06:26:53 GMT
First off! Great Article.
Can’t wait to see others posts and understand how to check and identify problems using system configs. and wait stats and types queries.

Wilton M.]]>WiltonThu, 06 Jan 2011 06:26:53 GMThttp://www.windowsitpro.com/blog/beginning-sql-server-one-step-at-a-time-blog-43/net-framework/beginning-performance-tuning-with-sql-server-139445#commentsAnchorhttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-routines-and-clauses#commentsAnchorFri, 17 Jul 2009 01:08:02 GMT
Excellent write up]]>CurtisFri, 17 Jul 2009 01:08:02 GMThttp://www.windowsitpro.com/article/sql-server/sharpen-your-skills-routines-and-clauses#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorFri, 18 Jul 2008 15:54:35 GMT
"A table can have maximum of one unique, but a maximum of 249 non-unique indexes" is not a true statement in SQL server. This statement only applys to clustered vs. non-clustered index and it does not apply to unique vs. non-unique constraints. A table can not more than one unique constraints.]]>PETERFri, 18 Jul 2008 15:54:35 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98299#commentsAnchorThu, 17 Apr 2008 20:13:14 GMT
Hi Pinalkumar, The topic above is interesting. I would like to know where the configuration file is, when sp_configure/sac utility is run. I would copy the configuration file into other SQL Server box. Thanks. Kasim Wirama]]>KevinThu, 17 Apr 2008 20:13:14 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills98299#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorFri, 14 Mar 2008 19:38:59 GMT
@daarthur, Thank you for your comment and pointing out that it will work on SQL Server 2000. @bobhen, Yes, there is error when I said that. Correct answer is it’s only possible to have one CLUSTERED index but 249 NON-CLUSTERED indexes. Clustered index does not have to be unique. Again thanks for pointing out.]]>PinalkumarFri, 14 Mar 2008 19:38:59 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorWed, 12 Mar 2008 11:35:24 GMT
It is possible to have more than one unique index in a table! What your are reffriing to is that it’s only possible to have one CLUSTERED index but 249 NON-CLUSTERED indexes. And the clustered index doesn’t have to be unique. If it is attached to a primary key it will of course be unique. The index attached to the primary key doesn’t have to be Clustered but it is as default :)]]>BobbyWed, 12 Mar 2008 11:35:24 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorWed, 05 Mar 2008 10:00:42 GMT
Marcos, thanks for your feedback. As the name of Pinal’s column implies, the article is geared toward SQL Server novices. What type of material (skill level) would you have found more helpful? P.S. You have a point about editors rating articles; I admit, I feel a little silly rating an article on a publication I work for, but that’s the limitation of our current commenting mechanism.]]>AnneWed, 05 Mar 2008 10:00:42 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorWed, 05 Mar 2008 06:15:58 GMT
I felt a little lost with the article. I mean, if you are an advanced DBA it is pointless and if you are a novice, it doesn’t explain too much, not even direct you to a more detailed material. Shame on you.]]>MarcosWed, 05 Mar 2008 06:15:58 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorWed, 05 Mar 2008 05:57:34 GMT
Megan, since you work in the magazine (at least, looks like) you shouldn’t rate the article. Don’t you think so?]]>MarcosWed, 05 Mar 2008 05:57:34 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorMon, 03 Mar 2008 12:49:55 GMT
This works in SQL Server 2000 as well.]]>daarthur Mon, 03 Mar 2008 12:49:55 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97936#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorFri, 15 Feb 2008 11:51:17 GMT
Thanks for informing us about the problem, tilleymf@hotmail.com. The downloadable code should be available to you now. And thanks so much for reading! Christan Humphries, Your Savvy Assistant]]>ChristanFri, 15 Feb 2008 11:51:17 GMThttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorFri, 15 Feb 2008 08:10:42 GMT
Hi While reading the article "Sharpen Your Basic SQL Server Skills " I have attempted to save/open the "Download the Code" item 97337.zip and it appears to be empty. Tried this from multiple workstations, but to no avail. Thanks - Michael]]>MICHAELFri, 15 Feb 2008 08:10:42 GMThttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorTue, 29 Jan 2008 11:20:04 GMT
Thanks for pointing out this problem stefbauer! I have replaced the link so you should be able to access that article now. Megan Bearly assistant editor mbearly@sqlmag.com]]>meganbearly Tue, 29 Jan 2008 11:20:04 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorMon, 28 Jan 2008 12:20:37 GMT
Link to "tail-log backups" in the Learning Path section is broken.]]>StefanMon, 28 Jan 2008 12:20:37 GMThttp://www.windowsitpro.com/article/sql-server-2005/sharpen-your-basic-sql-server-skills97768#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorWed, 26 Dec 2007 22:03:41 GMT
Solution to pop-up ads: Stop playing with your pointer... The pop-up key words are green and double-underlined so aren’t really "booby-traps". Eliminating pop-ups is a good way to increase the cost of everyone’s subscription.]]>SaleemWed, 26 Dec 2007 22:03:41 GMThttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchorWed, 21 Nov 2007 15:25:19 GMT
Here’s a comment from a new subscriber after two minutes of trying to look at my first "subscriber-only" article: I really hate those annoying fly-over links that pop up an irrelevant advertisement as I am trying to follow the text with my mouse pointer. I believe the fact that I’ve subscibed indicates that I paid for this content. Therefore, I do not understand why you feel compelled to plant advertising booby-traps in the paid content. Does anyone, including the advertiser imagine that inclination to purchase is increased by the use of these obnoxious pop-ups?]]>RobertWed, 21 Nov 2007 15:25:19 GMThttp://www.windowsitpro.com/article/sql-server-2000/sharpen-your-basic-sql-server-skills#commentsAnchor