String Manipulation - CHARINDEX()
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,432 reads
I see charindex used quite commonly in string manipulation. What I rarely see used is the optional third parameter. Here...
2009-12-19
4,432 reads
For a little more than a year now I've been a part of the PASS BI SIG and have tried...
2009-12-18
431 reads
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
341 reads
I’m not sure it’s true. I don’t think I have iPhone Stockholm Syndrome, as suggested by the article. It’s actually...
2009-12-18
1,472 reads
Many times when I'm teaching a class or working with a group, they express frustration at the load time for...
2009-12-18
487 reads
Yesterday I talked about taking notes using Google Docs. It's a great way if you've got multiple systems (especially with...
2009-12-18
1,562 reads
Although the Delete and Truncate Commands logically does the same work of deleting the rows from the table but still...
2009-12-17
1,261 reads
Most companies do something at the holidays, although it seems to be less with each year, and certainly this holiday...
2009-12-17
1,007 reads
I often work with DBAs who need to copy the results of a T-SQL query from SQL Server Management Studio...
2009-12-17
5,064 reads
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
3,052 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...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
Comments posted to this topic are about the item Spending Time in the Office
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