Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
378 reads
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
378 reads
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
476 reads
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
850 reads
I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two...
2018-04-04
276 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-28
697 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-21
332 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-14
755 reads
The future, 100 months from now: It’s Monday, 6 July 2026. It’s been quite a week since SQL Server Update...
2018-03-13
276 reads
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
389 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,028 reads
By James Serra
(Shameless plug: The price of my book “Deciphering Data Architectures: Choosing Between a Modern...
By Steve Jones
I was working with a customer and discussing how to do error handling. This...
By DataOnWheels
The 14th annual Ability Summit is a global event that I attended a few...
Comments posted to this topic are about the item The Journey to Change
Comments posted to this topic are about the item Check Azure SQL DB Space...
Comments posted to this topic are about the item The Cloned Database Size
I have a small test sandbox database on an instance with default master, model, msdb, and tempdb settings. The database has these files:I now run this command:
DBCC CLONEDATABASE(sandbox, sandbox_clone); GOWhen I examine the database file properties, what do they show? See possible answers