Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • Two Myths About ‘Lock Pages in Memory’

    calendar Oct 12, 2010 · Configuration SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This Month’s T-SQL Tuesday topic comes from Sankar Reddy (blog | twitter) and he’s asking for SQL Server myths and misconceptions to be de-bunked. I’ve got 2 myths I’d like to set the record straight about. They’re rather closely related, and concern the "Lock Pages in Memory" setting. What’s it do? Without …


    Read More
  • Optimizing for Ad hoc Workloads

    calendar Jul 6, 2010 · Configuration SQL Server  ·
    Share on: twitter facebook linkedin copy

    One of the nifty features available in SQL Server 2008 is the "Optimize for Ad hoc Workloads" option, which is at the instance level. If your workload involves a high number of ad hoc queries that are used only once, your plan cache (also known as the "procedure cache") may benefit from enabling …


    Read More

Bob Pusateri

Data and Kindred Subjects
Microsoft MVP Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • How To Remember SQL Clause Ordering
  • Building A Redirect Service with Cosmos DB and Azure Functions
  • New and Improved - Now With Static!
  • Presenting at PASS Data Community Summit 2021!
  • How I Digitally Capture Videotapes

Tags

SQL-SERVER 83 SPEAKING 37 SQL-SATURDAY 37 TSQL-TUESDAY 37 THOUGHTS 36 PASS-SUMMIT 34 COMMUNITY 33 EVENTS 27 PRESENTATIONS 17 T-SQL 12 SOFTWARE 11 PERSONAL 10 TOOLS 10 CLOUD-STORAGE 9
All Tags
24-HOURS-OF-PASS1 ARTIFICIAL-INTELLIGENCE1 AUDITING1 AZURE-DATA-STUDIO4 AZURE-FUNCTIONS1 AZURE-SQL-DATABASE1 AZURE-VMS1 BACKUP2 BACON8 BIG-DATA-CLUSTERS1 BLOGGING3 BOOK-REVIEW3 CERTIFICATION2 CHICAGO-SQL-ASSOCIATION2 CLOUD-STORAGE9 COMMUNITY33 COMPRESSION2 COMPUTING2 CONFIGURATION2 COSMOS-DB3 DATA-SETS1 DATA-TYPES2 DESIGN3 EIGHTKB1 EVENTS27 FILEGROUPS1 HARDWARE4 HIGH-AVAILABILITY1 HUGO1 INDEXING3 INTERVIEWING3 LINUX1 LITERATURE2 MICROSOFT-CERTIFIED-TRAINER1 MVP1 OFF-TOPIC1 PASS4 PASS-SUMMIT34 PERSONAL10 POWERSHELL7 PRESENTATIONS17 PROFESSIONAL-DEVELOPMENT9 RECOVERY-MODELS1 SECURITY1 SNAPSHOTS1 SOFTWARE11 SPEAKING37 SQL-SATURDAY37 SQL-SERVER83 SQLBITS3 SSMS6 SSRS1 T-SQL12 THOUGHTS36 TIPS-TRICKS3 TOOLS10 TRAINING1 TSQL-TUESDAY37 USER-GROUPS4 VIDEO-CONVERSION2 WINDOWS1 XML2
[A~Z][0~9]
Bob Pusateri

Copyright 2010 -  Bob Pusateri. All Rights Reserved

to-top