2022-05-20 (first published: 2019-02-05)
3,116 reads
data type
Reclaiming Space After Column Data Type Change
A brief overview of how to reclaim storage space after altering the data type of a column.
2016-08-09
4,990 reads
2016-02-29
1,677 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
how to output date of when a SP was created and last modification?
Hi everyone I have a query that gives me the list of all SP...
Getting error in sql server 2022
Hi folks We have migrated database from sql server 2014 std to sql server...
Source to Target Mapping (Lineage)
Hi all, I work with an unusual warehouse and I was wondering if anyone...
Question of the Day
The Character choice
What happens when I run this code in SQL Server 2022?
create table Names ( namestring varchar(20)) go insert Names select 'Steve' go select choose(namestring, 'steve', 'andy', 'brian') from NamesSee possible answers