Viewing 15 posts - 1 through 15 (of 39 total)
and if testing shows their is IO contention add four more to another volume, is that what you meaning?...thanks
August 26, 2014 at 2:45 pm
GilaMonster (8/26/2014)
4 files is fine to start with. Add more and spread across volumes if you see allocation contention or IO contention.
Thank you for the reply, I did mean...
August 26, 2014 at 12:57 pm
Thank you for the reply. So as long as the file system on Win 2012 is NTFS (I am assuming Win 2012 has the option to install as NTFS) then...
March 13, 2014 at 12:25 pm
The change was done as described worked without any issues.
EdVassie -- as you also run some DB's in EC2 hopefully you will not mind if I ask you a question?
How...
August 7, 2013 at 9:16 pm
[
1> SELECT convert(float, 3.56)2> go
------------------------
3.5600000000000001
(1 rows affected)
Thank you for your reply. Your example is exactly the issue and also is what I am struggling...
July 30, 2013 at 6:47 pm
rather than put more work on the tempDb, you could create them a dedicated Staging Database and put this in simple mode so that log backups are not needed.
Yes...
July 24, 2013 at 1:46 pm
Thanks to both Posters.
Out of curiosity -- what does this line "WHERE st.objectid IS NULL" do?
I notice when this line is in the query no database name is...
June 13, 2013 at 7:00 pm
I have read the articles and understand the "Parameter Sniffing" issues and some of the methods that may prevent / reduce this.
In my case I am still unsure why an...
June 10, 2013 at 8:45 pm
I suppose that next question is how do I handle this?
Assuming I can get the front end code changed(unsure about this though):
1. Simplify the query if possible?
2. Add RECOMPILE option...
June 10, 2013 at 1:00 pm
Obviously I could be wrong but thought the downside of Parameter sniffing could mean the same plan being used for two queries that return different size result sets. i.e the...
June 10, 2013 at 1:18 am
Or maybe stale stats.
The large tables do have a number of updates / inserts during the day but this varies depending if a campaign is being run or not.
I do...
June 10, 2013 at 12:24 am
Thanks for the reply.
As you allude to at least one view has multiple joins in it.
If I move the data from to second database and alter the join (so it...
May 9, 2013 at 5:07 pm
Thanks for that.
I was thinking that it would only store a new plan for a new query when the Plan Guide with N'OPTION(PARAMETERIZATION FORCED)' was set.
but it still seems...
May 6, 2013 at 8:19 pm
I followed the steps at this link "http://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/"
which only by coincidence seems to be by a previous poster on this thread.
The steps are similar to those steps DEVDB highlights...
April 16, 2013 at 1:35 pm
Steve Jones - SSC Editor (4/4/2013)
Especially in a small company, I'd use one account per instance per service, so in general, 2-3 per instance (Agent, SSRS, SSIS, etc)
I have only...
April 4, 2013 at 4:32 pm
Viewing 15 posts - 1 through 15 (of 39 total)