Patrick

Patrick Keisler is a Senior CSA - Engineering for Microsoft with over 20 years of SQL Server experience working in various fields such as financial, healthcare, and government. You can follow him on Twitter or listen to him speak at various SQL Saturdays and user group meetings.

Twitter: @patrickkeisler
Website: https://www.patrickkeisler.com
LinkedIn: https://www.linkedin.com/in/patrickkeisler/

How to Edit Read-Only Non-clustered Columnstore Data

by Patrick

Everyday SQL

As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...

2014-08-06 (first published: 2014-07-29)

8,114 reads

Columnstore Table Analyzer

by Patrick

Everyday SQL

As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...

2014-07-08

761 reads

Columnstore Memory Grant Issue

by Patrick

Everyday SQL

In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...

2014-06-03

2,182 reads

Comparison of Columnstore Compression

by Patrick

Everyday SQL

SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...

2014-05-20

1,834 reads

What is a Non-Clustered Columnstore Index?

by Patrick

Everyday SQL

First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...

2014-04-29

5,580 reads

The system_health Extended Event Session

by Patrick

Everyday SQL

When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...

2014-04-21 (first published: 2014-04-08)

4,053 reads

How Long is that SQL Command Going to Take?

by Patrick

Everyday SQL

Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is...

2014-03-04

3,238 reads

My Experience Aboard SQL Cruise 2014

by Patrick

Everyday SQL

Where do I begin? First let me say, WOW what an experience!

How it All Began
When I first heard about SQL...

2014-02-11

1,370 reads

Collecting Historical IO File Statistics

by Patrick

Everyday SQL

In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using...

2013-12-17

1,470 reads

Collecting Historical Wait Statistics

by Patrick

Everyday SQL

As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...

2013-12-16 (first published: 2013-12-11)

2,506 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers