I’ve recently published a new tip on SearchSQLServer.com called “Configuring SQL Server memory settings“.
Denny
New Article: Configuring SQL Server memory settings
| Published On: 2008-03-02 | By: Denny Cherry |
- Home
- Consulting
- Training
- Publications
- Blog
- Books
- Case Study
- Newsletter
- 2019-05-30 Out of Office Reply: When the CEO Takes Emergency Leave
- 2019-03-19 Power BI: Where should data live?
- 2018-11-19 What’s the difference between the cloud data platform options?
- 2018-09-18 How can Azure customers save money thru performance tuning?
- 2018-07-11 Moving to the Cloud & Cloud Features
- 2018-04-10 The Most Important Azure Services For Your Business
- 2018-01-16 Join us for a Database Security Webcast January 19th
- 2017-09-25 SQL Server 2017 Experts Review
- 2017-08-10 Save On Cloud Licensing
- 2017-05-05 IT Security
- 2017-03-16 SQL Server 2016, The BI Advantage
- 2017-02-09 R Services in SQL Server 2016
- 2016-12-20 Webcast, Expert Tips and More
- 2016-08-02 Azure VS. Amazon RDS
- 2016-07-12 The ROI on SQL Server 2016
- White Papers
- About Us
- News
- Applications
- Contact Us
Search Our 1750+ Blog Posts
Watch our most recent webcast
Register for our Webcast on March 12th, 2020 at 11 am Pacific / 2 pm Eastern where Denny Cherry will cover what steps a copy go through in advance of a Ransomware attack so that you are protected from an attack; what a Ransomware can (and probably will) go after; and what you can do after the fact to bring your company back after a Ransomware attack, without paying the ransom.
Next Webcast
Watch our webcast on Friday November 15th, 2019 at 2pm Eastern / 11am Pacific where Meagan Longoria and Kerry Tyler will present their webcast “Is it time for an SSIS checkup?”.
Watch Now
See All Our Live and Recorded Wedbcasts
Recommended Partner Programs
Hey Denny !
Thanks for the great article ….
Can you please tell me how to compile my sql server to use the 64 bit OS?
How do I make sure that it only runs in 64 bit mode?
Thanks
Erik
You can’t actually recompile Microsoft SQL Server. Microsoft doesn’t release the source code for SQL Server as it’s a closed source project. You would have to use the 64-bit installer. Microsoft has released three different builds via three different DVDs. One is the good old 32bit, one is the x64 edition and one is the 64bit Itanium build. If you have the wrong one you’ll need to contact Microsoft have have then send you the correct media pack. There is no cost difference between the three, but there is usually a small charge to get the media sent out.