Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: DATETIME2
Compatibility
Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data types to handle dates and… Read More »Dates and Times in SQL Server: TIME
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 types to handle dates and… Read More »Dates and Times in SQL Server: DATE
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with a granularity of three milliseconds,… Read More »Dates and Times in SQL Server: SMALLDATETIME
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the basics of various date and… Read More »Dates and Times in SQL Server: DATETIME
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM)… Read More »Secure or fast? Secure, obviously …
MySQL has this feature that SQL Server needs
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because MySQL is predominantly used for… Read More »MySQL has this feature that SQL Server needs
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to CAST or CONVERT a datetime2… Read More »Why is a value in DATETIME2 8 bytes, but in BINARY it is 9 bytes?
Changes to Service Packs and Cumulative Updates for SQL Server 2017
Edited on 10 October 2018: Please note that this model has changed. See Changes to the SQL Server servicing model (Cumulative Updates) for more. The… Read More »Changes to Service Packs and Cumulative Updates for SQL Server 2017
What you need to know about memory limits on SQL Server
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max Server Memory is *not* just… Read More »What you need to know about memory limits on SQL Server
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing list discussion, one person demonstrated… Read More »Be Wary of Date Formatting in T-SQL
Max Server Memory and SQL Server 2016 Service Pack 1
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work.… Read More »Max Server Memory and SQL Server 2016 Service Pack 1
Testing for Object Existence: CREATE OR ALTER
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped… Read More »Testing for Object Existence: CREATE OR ALTER
Testing for Object Existence: DROP … IF EXISTS
For the longest time, T-SQL writers have had to wrestle with ways of testing for an object’s existence so that it can either be dropped… Read More »Testing for Object Existence: DROP … IF EXISTS
- « Previous
- 1
- 2
- 3
- 4
- Next »