At SQL Server Geeks 2015 - Pre Conference Session - Benjamin Nevarez
Attended SQL Server Geeks Annual Summit 2015 on last Wednesday (26/8) at Bangalore, India. Due to few urgent responsibilities at...
2015-08-31
1,264 reads
SQL and SQL Only
Query cost and Query Execution time - Difference
This post is my 100th post 🙂 Was inactive in blogging for few years in between. Now back in full flow....
2015-08-25
1,446 reads
Hekaton Part 4: Simple Performance comparison - In Memory vs Disk table
Continuing on the Hekaton Series, this post will attempt a very basic performance comparison of In Memory and disk based...
2015-08-18 (first published: 2015-08-14)
2,926 reads
Hekaton Part 3: Table Creation and Parameters
Part of a Series on "Hekaton". Refer below for previous posts
Introduction to Hekaton - Part 1Creating a Hekaton Database - Part 2
Having...
2015-08-13
589 reads
Hekaton - Creating a Database :- 2
With a Gentle intro done on Hekaton - In Memory tables, let us continue exploring further. Today, we will quickly create a database...
2015-08-06
540 reads
Hekaton - In Memory OLTP - Getting Started / FAQ :- 1
SQL Server 2014 introduced a major feature called "In Memory - Hekaton" Tables, in which even the fundamental concepts of SQL...
2015-08-04
1,061 reads
Detach and Attach All User Databases
Sometimes you are in a scenario where you need to transfer a large number of databases from one server to...
2015-05-29
1,036 reads
DDL Auditing - Article on SQL Server Central
My article on SQL Server Auditing has been published on www.SQLServerCentral.Com. Article discusses how default trace can be used effectively...
2015-05-22
593 reads
How to Size the SQL Server Memory & Why is it important?
The following blog post has 2 objectives.
 1) How to size the memory correctly ( or atleast being close to correctly )
 2)...
2013-05-27
2,798 reads
Xp_readerrorlog in SQL Server 2012
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,246 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers