Viewing 15 posts - 1,801 through 1,815 (of 2,007 total)
Yes, if you plan to store 126M rows in a table, you need to do some serious optimization
Agree. And best way to achieve it would be partitioning (transparent to...
October 20, 2011 at 8:51 am
Thats a design issue that I need to take up with my boss.
That's the best idea. 🙂
He wants all the data (Yes, the entire 7 years)...
October 20, 2011 at 8:47 am
Agree with all this, however the optimizer will change a between to a => <=
This could be another topic of discussion. May not be suitable for this case...
October 20, 2011 at 3:16 am
Also..
Can I use Telnet on any computer?
Yes and no. Telnet is a technology which uses a client (the computer that you are connecting from, such as your desktop computer),...
October 20, 2011 at 3:06 am
Few Suggestions:
•Do you need all columns data for your application? I guess not; so use specific columns in SELECT.
•For instance if you need only 3 (or less than 5) columns...
October 20, 2011 at 2:53 am
I just did it again: this time I noticed the problem might be because the "installation instance" is empty when I installed it.
Would you mind doing this exercise once...
October 20, 2011 at 2:50 am
As a general guideline:
•1 disk (logical / physical) for OS + SQL Server Instance Root
•1 disk (--do --) for Data Files (and many more if planning for table partitions)
•1 disk...
October 19, 2011 at 9:28 am
I am also now going to call our OPs people "serverdudes" 🙂
I believe Steve has not read it yet... (No offence please, just kidding) 😛
October 19, 2011 at 9:20 am
This is the best requirement to justify the use of Central Management Servers.
Administering Multiple Servers Using Central Management Servers
October 19, 2011 at 9:13 am
Name Product ...
October 19, 2011 at 9:05 am
if there's a failover, let them fight for the available memory
I agree with John if and only if the failover period is very small. If you are in Performance SLA...
October 19, 2011 at 8:57 am
there is any automatic script for max memory configuration while the server switch to other node
Not Sure on automated script but you can certainly create alerts for it. Once you...
October 19, 2011 at 8:52 am
You mean 1 plan executed 700 times
If this plan is efficient, you are good to go. It also means the Buffer Cache will have hot data whenever you need.
or...
October 19, 2011 at 8:33 am
Recommeded Reading:
Working with Multiple Versions and Instances of SQL Server
http://msdn.microsoft.com/en-us/library/ms143694.aspx
Considerations for Side-by-Side Instances
October 19, 2011 at 6:25 am
Viewing 15 posts - 1,801 through 1,815 (of 2,007 total)