Viewing 15 posts - 16 through 30 (of 50 total)
I don't necessarily think this is an indexing problem. You want to try and keep the number of included columns to a minimum. Looking at your image, this...
May 19, 2011 at 9:01 am
In 2008+, you can issue ALTER TABLE dbo.TableName REBUILD. However, you are still going to be rebuilding all of the nonclustered indexes automatically.
May 18, 2011 at 1:24 pm
Is there any possibility with having different collations across the databases that you could run into issues when running queries that cross databases especially involving joins? What about any...
May 11, 2011 at 8:06 am
It may be a good idea to look at using AUTO_UPDATE_STATISTICS_ASYNC as well so queries do not have to wait for the statistics to update.
April 21, 2011 at 7:51 am
I also noticed that there are a lot of unlimited max file size settings for the databases. I personally prefer to set those limits to something reasonable and monitor...
March 9, 2011 at 1:08 pm
One of the other things I noticed was that the collations are different for some of the databases. SQLServerCentral, as well as others, use Latin1_General_CI_AS as where some of...
March 9, 2011 at 12:59 pm
Besides the obvious filegrowth setting issues mentioned previously, one thing I found was there was not much use of filegroups. One of the things I like to do is...
March 7, 2011 at 7:08 pm
Does any one know if R2 allows for partial/suffix word searching in FTS? I had heard that was the plan a while back but am not able to find...
April 22, 2010 at 8:22 am
I do actually use a "*" after the word and it returns more records which is correct. I have tried a "*" in front of the word but it...
September 11, 2009 at 6:58 am
PaulB,
Unless I have a misunderstanding about partitioning, I thought it fit very well into what we are trying to accomplish. The main thing we are trying to do is...
September 9, 2009 at 7:50 am
You can can have up to 1000 partitions. I do not know what the limit is on filegroups per table. I did not start off planning on creating...
September 9, 2009 at 7:28 am
PaulB,
At the moment, we only have one customer so we don't have to worry about restoring for an individual company but as we start adding companies in the next few...
September 9, 2009 at 7:07 am
I am looking at multi-tenant because I am going to have multiple companies accessing the database and only their information along with the global tables. I am interested in...
August 31, 2009 at 2:45 pm
Thanks fore the links Barry. I believe I am leaning towards the shared database shared schema approach and partitioning based on CompanyID. When you use partitioning, do you...
August 31, 2009 at 2:03 pm
Viewing 15 posts - 16 through 30 (of 50 total)