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
414 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
414 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,069 reads
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
341 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,377 reads
Tom Roush The SQL Family lost a much admired member to cancer last month, Tom Roush. In our little community,...
2018-02-07
398 reads
Victoria is on an island off the coast of Vancouver, British Columbia. The island is wisely called Vancouver Island. It...
2018-01-31
526 reads
As I mentioned a couple of weeks ago, I will be presenting for the first time at SQLBits in London,...
2018-01-24
334 reads
By now you have probably seen the news about a major flaw in the design of CPUs from all major...
2018-01-17
339 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
372 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
312 reads
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Comments posted to this topic are about the item Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers