Does sp_rename on a column preserve the ms_description?
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
398 reads
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
398 reads
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the...
2016-08-15
84 reads
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-11
174 reads
The staple of every SQL Server developer's world, SSMS has been impossible to usurp for the majority of us. However,...
2016-07-19 (first published: 2016-07-11)
3,617 reads
Giveaway details at the bottom for those interested
Dealing with development & sql servers, I like to know what type of network...
2016-07-01
1,457 reads
I know there have been a few other folks going into more detail on SQL Compare 12 (beta), but I...
2016-06-25
465 reads
comparing instances
When working with a variety of instances, you can often deal with variances in configuration that might impact the...
2016-06-22 (first published: 2016-06-14)
2,862 reads
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,898 reads
Took a class from Jamey Johnston @ SQLSaturday #516 in Houston. Lots of great information covered. Follow him for a much...
2016-05-20 (first published: 2016-05-14)
2,935 reads
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,237 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Grand Comal Residence, Jl. Raya Ahmad Yani No.20 Blok EA A19, Dusun II,...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers