Survey: tempdb file configuration (code to run)

Posted on: December 10, 2015 4:27 pm

Survey: page life expectancy

Posted on: May 12, 2015 11:45 am

Survey: how much server memory on your largest machine?

Posted on: November 12, 2014 12:38 pm

Survey: target uptime – planned and actual

Posted on: May 12, 2014 8:40 am

Survey: what is the most worrying cause of log growth?

Posted on: March 3, 2014 2:11 pm

Survey: what is the most worrying wait type?

Posted on: February 13, 2014 10:49 am

Survey: using DBCC WRITEPAGE

Posted on: January 29, 2014 9:57 am

Survey: restoring and rebuilding master

Posted on: January 8, 2014 2:24 pm

Survey: tempdb and transaction log IO latencies

Posted on: August 25, 2013 3:42 pm

Survey: what SQL Server build number are you running?

Posted on: May 30, 2013 11:16 am

Survey: data files and filegroups per database (code to run)

Posted on: May 1, 2013 12:37 pm

Survey: what’s the newest version of SQL Server that you have in production

Posted on: April 24, 2013 11:54 am

Survey: what’s the oldest version of SQL Server you have in production?

Posted on: April 17, 2013 5:25 pm

Easy automation of SQL Server database maintenance

Posted on: April 16, 2013 1:32 pm

Survey: what mechanism do you use for regular database maintenance?

Posted on: April 5, 2013 8:56 am

Survey: how often do you perform a full backup?

Posted on: December 6, 2012 6:41 pm

Survey: where do you store your database backups?

Posted on: December 4, 2012 10:49 am

Survey: do you have a baseline?

Posted on: October 16, 2012 8:38 am

Survey: transaction log files per database (code to run)

Posted on: August 29, 2012 12:11 pm

Most common latch classes and what they mean

Posted on: August 21, 2012 12:24 pm

Survey: most prevalent latch waits (code to run)

Posted on: May 10, 2012 2:26 am

Max server memory configuration survey results

Posted on: April 18, 2012 1:56 pm

Importance of how you run consistency checks

Posted on: April 5, 2012 2:07 pm

Survey: how do you run consistency checks?

Posted on: March 20, 2012 1:35 pm

Survey: memory configuration

Posted on: February 7, 2012 1:26 pm

How cluster key size can lead to GBs of wasted space

Posted on: January 2, 2012 6:46 am

Survey: wasted space from cluster keys (code to run)

Posted on: November 8, 2011 2:49 pm

Over and under indexing – how bad is it out there?

Posted on: November 1, 2011 1:15 pm

SharePoint in a SQL Server environment

Posted on: August 22, 2011 10:31 am

Survey: nonclustered index counts (code to run)

Posted on: August 4, 2011 3:27 pm

OT survey results: browsers and email clients

Posted on: August 2, 2011 1:18 pm

Using database snapshots

Posted on: July 26, 2011 10:59 am

OT Survey: internet browsers and mail readers

Posted on: July 20, 2011 12:57 pm

Survey results on rebooting – is it good or bad?

Posted on: July 6, 2011 4:26 am

Survey: do you use database snapshots?

Posted on: July 4, 2011 11:31 am

MAXDOP configuration survey results

Posted on: June 23, 2011 3:50 am

Survey: do you regularly reboot SQL Server?

Posted on: June 2, 2011 1:34 pm

The pros and cons of trace flags

Posted on: June 2, 2011 12:59 pm

Performance issues from wasted buffer pool memory

Posted on: June 1, 2011 10:13 am

Survey: cores vs. MAXDOP

Posted on: May 26, 2011 10:44 am

Survey: what’s your comfort level with trace flags in production?

Posted on: May 5, 2011 5:05 pm

Salary survey results – are YOU being paid enough?

Posted on: May 4, 2011 8:59 am

Anonymous survey: salaries in the SQL Server world

Posted on: April 19, 2011 1:55 pm

Job security, loyalty, and employee retention: you need to take control

Posted on: April 19, 2011 10:50 am

Survey: how much server memory is being wasted? (code to run)

Posted on: April 15, 2011 8:52 am

Advanced SQL Server performance tuning

Posted on: April 13, 2011 7:32 am

Surveys: what’s your company doing for you, and vice versa?

Posted on: April 6, 2011 7:50 am

Survey results: Common causes of performance problems

Posted on: April 6, 2011 6:37 am

Survey: have you ever used these DMVs?

Posted on: March 24, 2011 8:57 am

Human nature is a significant hurdle to successful disaster recovery

Posted on: March 23, 2011 12:10 pm

Survey: what are the most common causes of performance problems?

Posted on: March 17, 2011 9:45 am

Query plan analysis first steps

Posted on: March 16, 2011 2:28 pm

Surveys: DR plan testing and considering human nature

Posted on: March 11, 2011 10:14 am

Tempdb configuration survey results and advice

Posted on: March 9, 2011 10:42 am

Better together – the importance of great inter-team relationships

Posted on: February 24, 2011 7:03 am

Survey: how is your tempdb configured?

Posted on: February 22, 2011 3:03 pm

Updated database size survey results

Posted on: February 22, 2011 1:22 pm

Survey: what’s the largest SQL Server database at your company?

Posted on: February 14, 2011 12:11 pm

Importance of network latency when using database mirroring

Posted on: February 8, 2011 10:02 am

Survey: what’s your plan for a plan?

Posted on: February 6, 2011 10:00 am

Importance of monitoring a database mirroring session

Posted on: January 31, 2011 12:29 pm

Survey: inter-team relationships

Posted on: January 30, 2011 12:59 pm

Survey: database mirroring latency between servers

Posted on: January 30, 2011 11:10 am

Survey: monitoring database mirroring

Posted on: January 24, 2011 11:12 am

What’s in a job title?

Posted on: January 24, 2011 9:55 am

Results of CPU power saving survey

Posted on: January 16, 2011 10:51 am

Are your CPUs running slowly? Tool tip and survey

Posted on: December 30, 2010 1:39 pm

Survey: what’s in a job title?

Posted on: December 21, 2010 7:14 pm

Survey: what is the highest wait on your system?

Posted on: October 25, 2010 9:21 am

Survey results around purchase and use of SSDs

Posted on: July 23, 2010 8:38 am

Survey: SSD purchasing and deployment plans

Posted on: July 4, 2010 6:00 am

Log file configuration metrics for 17000 databases

Posted on: July 4, 2010 5:20 am

Survey: how are your transaction logs configured?

Posted on: April 23, 2010 1:54 pm

Survey: how do you create and maintain statistics

Posted on: September 15, 2009 12:10 pm

Importance of having a good disaster recovery plan

Posted on: September 15, 2009 11:17 am

Survey: what kind of disaster recovery guide do you have?

Posted on: August 26, 2009 1:50 pm

Adding geo-redundancy to failover clustering

Posted on: August 26, 2009 12:07 pm

Survey: How do you provide geo-redundancy with clustering?

Posted on: August 3, 2009 2:59 pm

Importance of running regular consistency checks

Posted on: August 3, 2009 7:19 am

Weekly survey: how often do you run consistency checks?

Posted on: June 24, 2009 7:00 pm

Importance of data file size management

Posted on: June 24, 2009 6:55 pm

Weekly survey: how do you manage your data file sizes?

Posted on: June 15, 2009 7:22 pm

Becoming an involuntary DBA – you’re not alone

Posted on: June 15, 2009 5:35 pm

Weekly Survey: what’s the hardest part of becoming an involuntary DBA?

Posted on: June 7, 2009 9:35 pm

Important considerations when performance tuning

Posted on: June 7, 2009 7:42 pm

Weekly survey: what’s the most important thing when performance tuning?

Posted on: May 30, 2009 6:38 pm

Importance of defining and measuring SLAs

Posted on: May 30, 2009 4:00 pm

Weekly survey: maximum allowable downtime – target and actual

Posted on: May 25, 2009 1:58 pm

Importance of testing your disaster recovery plan

Posted on: May 25, 2009 1:00 pm

Weekly survey: have you ever tested your disaster recovery plan?

Posted on: May 17, 2009 5:38 pm

Importance of choosing the right architecture and SQL Server Edition

Posted on: May 17, 2009 4:40 pm

Weekly survey: what architecture do you buy? And which SQL Server edition?

Posted on: May 10, 2009 3:57 pm

Importance of having a manageable environment

Posted on: May 10, 2009 11:22 am

Weekly survey: what’s your largest database, and how many do you manage?

Posted on: May 2, 2009 7:58 am

Importance of having the right backups

Posted on: May 2, 2009 6:32 am

Weekly survey: what kind of backups do you take?

Posted on: April 27, 2009 2:44 am

Physical database layout vs. database size

Posted on: April 27, 2009 12:21 am

Weekly survey: still running last week’s survey

Posted on: April 17, 2009 3:35 pm

Weekly survey: does size really matter – or is it what you do with it?

Posted on: April 10, 2009 3:05 pm

Importance of proper transaction log size management

Posted on: April 10, 2009 12:21 pm

Weekly survey: transaction log size management

Posted on: April 3, 2009 9:59 am

Importance of choosing the right LOB storage technique

Posted on: April 3, 2009 8:46 am

Weekly survey: large-value character storage

Posted on: March 27, 2009 9:58 am

Weekly survey: method of running consistency checks

Posted on: March 21, 2009 5:20 pm

Importance of index maintenance

Posted on: March 21, 2009 3:50 pm

Weekly survey: index maintenance plan

Posted on: March 13, 2009 6:06 pm

Importance of validating backups

Posted on: March 13, 2009 5:17 pm

Misconceptions around instant file initialization

Posted on: March 10, 2009 11:51 am

What’s a valid question for a DBA interview?

Posted on: March 8, 2009 5:28 pm

Testing a new survey method: backup validation

Posted on: March 5, 2009 5:54 pm