Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
391 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
391 reads
Last week I spoke about a world wary data type for storing dates and times in a single column, with...
2018-02-28
1,042 reads
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
324 reads
Nested views are bad. Let’s get that out of the way. What is a nested view anyway? Imagine that you...
2018-02-14
2,195 reads
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community,...
2018-02-07
387 reads
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...
2018-01-31
517 reads
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London,...
2018-01-24
324 reads
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
319 reads
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether...
2018-01-10
364 reads
I have been working on a new information session, which I’m hoping to deliver this year. It’s about one of...
2018-01-03
293 reads
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
I wanted to figure out how big (or approximately how big) my dump file...
Comments posted to this topic are about the item Announcing SQL Server 2025
Comments posted to this topic are about the item Running Steve's Code
Comments posted to this topic are about the item New SQL Server 2022 Functions
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; GOSee possible answers