SQLSaturday #2 (Tampa 2008) Notes
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
Congratulations to Wes Dumey, Pam Shaw, and the rest of the Tampa volunteers for building a very nice event. Very...
2008-02-18
1,414 reads
User groups have to be about more than technical content if you want to sustain them over the long term,...
2008-02-14
487 reads
Recently I posted about making sponsorship work to lay out some ideas for events that are seeking sponsors. My friend...
2008-02-13
632 reads
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
2008-02-12
13,015 reads
I wrote this article on computed columns to support some of the teaching I do for my beginner to intermediate level...
2008-02-12
444 reads
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
2008-02-12 (first published: 2007-02-27)
25,447 reads
My friend Mike Antonovich was kind enough to really go through my draft and provided some great feedback which I've...
2008-02-12
978 reads
This article shows how to initialize a subscriber from a backup in SQL 2005. It's a niche technique, but it...
2008-02-11
341 reads
This topic came up during the speaker reception at the South Florida Code Camp and while I've posted here and...
2008-02-11
799 reads
For those of you in Orlando our next meeting will be held on Feb 12 from 6-8 pm at the...
2008-02-11
509 reads
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
The Joyful Craftsmen has become the new owner of Revolt BI. The merger creates...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0821-8154-398 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
WhatsApp:0821-8154-398 Wisma BCA Pd. Indah, Jl. Metro Pondok Indah No.10, RT.3/RW.17, Pd. Pinang, Kec....
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