Deleting a lot of data
I recently had the task of deleting a bit over a billion rows from a table. Now I could have...
2018-04-12
2,108 reads
Blog Posts
Machine Learning Server at the CBusPass User Group
Come out Thursday, April 12 to learn how to leverage Microsoft Machine Learning Server. Machine Learning Server HopATopBikeShop BACPAC and Demo Scripts
2018-04-12
14 reads
New Azure SQL Database Pricing Model
Azure SQL Database has some great built-in features that are included in the price like automatic backups, high availability, auditing...
2018-04-12
1,361 reads
New Azure SQL Database Pricing Model
Azure SQL Database has some great built-in features that are included in the price like automatic backups, high availability, auditing and threat detection, transparent data encryption. No matter how...
2018-04-12
26 reads
Please join me for my PASS Summit Pre-Con with Melissa Coates
I’m excited to announce that I’m joining forces with Melissa Coates (aka SQL Chick) to do a full-day PASS Summit...
2018-04-12
664 reads
SQL Server Logical Query Processing
Recently, while reviewing one of the stored procedure performance, I suggested a couple of changes to a developer to improve...
2018-04-12
19,734 reads
What is a Foreign Key & How many foreign keys can you have on a single table?
Yesterday, I was attending a database design meeting. In the meeting, I was asked one of the questions – “How many...
2018-04-12 (first published: 2018-04-05)
12,093 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton Rouge .Net User Group does the same at the...
2018-04-11
7 reads
Baton Rouge SQL Server User Group – Execution Plans
Tonight, April 11th starting at 6PM, the Baton Rouge SQL Server User Group will hold its monthly meeting. The Baton...
2018-04-11
315 reads
Checking for temporary table existence
Database Code Smells
I was recently reviewing a newly created T-SQL stored procedure. This procedure was verifying temporary table existence with...
2018-04-11
2,183 reads
Blogs
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers