SQL RNNR

Blog Post

NULLIF

Do you use NULLIF?  For me, this command has been seldom used.  Because of that, I have been dabbling with...

2011-03-30

3,895 reads

Blog Post

NULLIF

Do you use NULLIF?  For me, this command has been seldom used.  Because of that, I have been dabbling with it a bit lately to make sure I have...

2011-03-30

16 reads

Blog Post

Do You Solution?

Do you ever find yourself working on different scripts at once?  Maybe you are working on something that tests certain functionality in SQL Server, you have some presentation scripts...

2011-03-29

10 reads

Blog Post

ShowPlan XML

I just ran into something that I hadn’t noticed in SQL Server.  It struck me as somewhat interesting but is...

2011-03-28

1,942 reads

Blog Post

ShowPlan XML

I just ran into something that I hadn’t noticed in SQL Server.  It struck me as somewhat interesting but is really not too big of a deal. While demonstrating...

2011-03-28

23 reads

Blog Post

Tools note

I was asked a few months ago to allow some advertising on my blog.  I hadn’t given the idea a...

2011-03-24

846 reads

Blog Post

Tools note

I was asked a few months ago to allow some advertising on my blog.  I hadn’t given the idea a whole lot of thought but was reminded again today...

2011-03-24

12 reads

Blog Post

SQL Server Startup

From time to time I see a question asking how to determine the last time a SQL Server was either restarted or when the last time was that the...

2011-03-23

11 reads

Blogs

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

New article – migrating from a named instance

By

Do you have a case where you have a named instance you'd like to...

Read the latest Blogs

Forums

Understanding Temp Tables and Table Variables in SQL Server

By sabyda

Comments posted to this topic are about the item Understanding Temp Tables and Table...

The Data API Builder MCP Server Tools

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Data API Builder MCP...

Collecting Data Is Hard

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Collecting Data Is Hard

Visit the forum

Question of the Day

The Data API Builder MCP Server Tools

The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?

See possible answers