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 featuring Kevin Kline and Denny Cherry where they discuss keeping data and applications available even during production outages.
Next Webcast
Watch our webcast which was broadcast on April 1st, or April 2nd (depending on which part of the world you are in) as Kevin Kline and Denny Cherry talk about the Top 5 Considerations When Moving Databases to Azure.
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.