Automatic tuning

Technical Article

RE: SQL Server Maintenanace Plans

  • Reply

I wrote my own. For the simple reason that the maintenance plans are not sufficient enough. You need to create different maintenance plans for different kind of databases etc.I created some scheduled job's for dumping the database, dumping the logs for databases that have the 'Full' option, re-indexing the databases, checking the databases and update […]


Technical Article

RE: AWE and MaxMem settings for SQL2K on WS2003-OS Clustered

  • Reply

From MSDN:On 32-bit versions of Windows, PAE is disabled by default. You must use the /pae boot parameter to enable PAE. However, PAE is automatically enabled when the computer is configured for hot-add memory devices in memory ranges beyond the 4 GB region, as defined by the Static Resource Affinity Table (SRAT). Hot-add memory supports memory […]



What do we want to achieve by encrypting our data?


On the face of it, this is a very obvious question with a very...

Daily Coping 5 Dec 2022


Today’s coping tip is to look for new reasons to be hopeful, even in...

Speaking at SQLSaturday MN 2022


Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Read the latest Blogs


Optimization for Single Table with Thousands of Concurrent Updates

By keith.west-982594

I have a table with 5 million records and each record requires a "Value"...

Pivot not working, pivot without aggregate functions.

By sbhagyalakshmi95

Hi Team,   Can you please help me to get data pivot data. my...

10 years as Sql server dba but still fears of Interview and lack of Confidence

By anoop.mig29

I dont know whether i may asking question at right or worng place but...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers