Adam Kreul | Blog

Combating the CXPacket Wait Type

• by Adam-Kreul

• Adam Kreul | Blog

Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of...

2015-03-24 (first published: 2015-03-17)

7,369 reads

Making Sense of PCIe SSD Use with SQL Server

• by Adam-Kreul

• Adam Kreul | Blog

When Fusion IO burst onto the scene in 2007, offering a PCIe card that was said to be able to...

2015-03-16 (first published: 2015-03-10)

5,821 reads

Configuring a Complete Memory Dump

• by Adam-Kreul

• Adam Kreul | Blog

Imagine this scenario: One of your servers just crashed, and you open a ticket with Microsoft for them to perform...

2014-11-06

1,277 reads

Database Maintenance Plans: A Primer

• by Adam-Kreul

• Adam Kreul | Blog

Databases and newborns have a lot in common.  They both require constant care.  They both require constant monitoring.  They also...

2014-10-20 (first published: 2014-10-14)

7,010 reads

Why I’m Not Excited About Hekaton (In-Memory OLTP)

• by Adam-Kreul

• Adam Kreul | Blog

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure...

2014-09-22 (first published: 2014-09-17)

8,426 reads

A CLR Application: Deleting Three Billion Rows

• by Adam-Kreul

• Adam Kreul | Blog

In one of SQL Server Central’s recent daily newsletters, Steve Jones’s editorial was inquiring whether or not anyone has been...

2014-03-06

1,143 reads

Fight Career Frustration With Learning

• by Adam-Kreul

• Adam Kreul | Blog

If you work in IT, the office becomes your second home.  It’s where we make a living, and most of...

2014-03-11 (first published: 2014-02-28)

2,945 reads

I’m on Twitter! @AdamKreul

• by Adam-Kreul

• Adam Kreul | Blog

I’m just a little late to the party, but no time like the present, right?  I plan to be very...

2014-02-15

625 reads

Make Your Storage Administrator Your Best Friend

• by Adam-Kreul

• Adam Kreul | Blog

That guy or gal over there going on and on about spindles and IOPS – that’s your SAN admin.  For the...

2014-02-17 (first published: 2014-02-12)

1,614 reads

Configuring the RecycleTime SSRS Setting

• by Adam-Kreul

• Adam Kreul | Blog

If you administer a SQL Server Reporting Services server, chances are you’ve had users complain the report manager is loading...

2013-11-07

1,440 reads