DBCC CHECKDB

gerritjan.soede (7/13/2012)

---

You wrote:

On the General page, click on the Timeline button, and we can use the new Timeline slide to repeat the entire RESTORE operation, but this time setting the...

yup (7/11/2012)

---

Here is an image attached.

Also if you can get some one to share details from some where s/he is using an MDF / NDF on MBR above 2 TB....

You have to convert the run_date and run_time columns into a meaningful value. Steve Kass provided the following solution to calculate the datetime value from both columns years ago:

CONVERT...

vinay.kumar (7/6/2012)

---

HI,

Thanks For the Post.

I tried the sample Event Notification given in the blog. And it looks all fine.

For the each Event(ERRORLOG) it is using one Conversation Group for all...

For what you've spec'd already, I wouldn't even go after a new laptop. I've gone the path of buying my own SSD in the past and asked permission to use...

Koen Verbeeck (6/4/2012)

---

The hardware is just a standard Dell laptop, with 8Gb RAM and i7 Intel processor.

I'm at work now, so I'll post the details later.

I created the columnstore index...

What hardware are you using for the test? What kind of disk is this on? I would suspect that if you monitor the I/O latency and block sizes you...

It is a VM running in VirtualBox on my laptop. The VM is configured with 2 vCPU and 4GB RAM and is running on a USB3 external drive using...

I can't reproduce the behavior that you are describing on my SQL 2012 VM at all. As a heap it takes 36 seconds to run the query after generating...

Read this blog post which explains what sql_text is:

Understanding the sql_text Action in Extended Events

In SQL Server 2008 there is no SQL Batch Completed Event, this was only added in...

What is an example of the output and which event is the one being repeated? My first guess would be that you have a user defined function in use...

First off, lets start off with, what Hypervisor are you using? It makes a difference because VMware doesn't do things the same way as HyperV which is then different...

kfarlee (4/24/2012)

---

While much of this article is accurate, I need to correct a few misconceptions.

I am a PM, working on the storage engine for SQL Server, specifically on access to...

This is incredibly inefficient when compared to the very simple implementation using Event...