Storage

Tag: storage

3 Lessons Learned About Azure SQL Database

3 Lessons Learned About Azure SQL Database

Hosted cloud databases make a lot of administrative tasks easier, or take care of them for you altogether.

But here are three things that I’ve found a little too easy to forget about Azure SQL Database.

Continue reading

Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)

Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)

Dear SQL DBA, What do you say to a SAN admin when you think that the billion dollar SAN *may* be the bottleneck and you just want to look into it. What are the technical things I need to say to make them believe there might be something to my questions?

Continue reading

Indexes: Do Included Columns Always Go on a Non-Root Page? (video)

Indexes: Do Included Columns Always Go on a Non-Root Page? (video)

Recently, I was thinking about nonclustered indexes in SQL Server, and how included columns are stored.

Is SQL Server smart enough to optimize the storage for small indexes with includes? Find out in this free seven minute video.

Continue reading