What Are You Afraid to Ask?
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
599 reads
There are some questions that can’t necessarily be answered in a book or a training video. Those are often the...
2010-08-02
599 reads
This month’s question of the month was:
Tell us your story of how you happened to become a DBA.
This month, the...
2010-08-02
384 reads
I just passed 100,000 views on the blog. That’s from 400 posts over a period of time starting in March...
2010-08-01
660 reads
Writing YTD totals and Running totals using T-SQL can take a little effort. However, with MDX it's not too difficult. ...
2010-08-01
550 reads
Moving to a New Blog Platform
First, I want to say that having my blog on SQL Server Central has been...
2010-08-01
1,021 reads
NOTE: At least one project will be selected every week for the remainder of 2010. Like the Phoenix rising from...
2010-07-31
1,436 reads
To many, August represents the lazy dog days of summer when it’s too hot to even think about going outside....
2010-07-30
1,468 reads
Tuesday
PASS Performance Virtual Chapter - Parallelism and Performance - Are You Getting Full Return on Your CPU Investment? - Adam Machanic
Thursday
SQL Lunch - Analysis...
2010-07-30
1,577 reads
Making a Career Change of My Own
I commented about a month ago on the high profile career changes that seemed...
2010-07-30
2,485 reads
This puzzle may not have been much of a challenge, but it introduced two new MDX concepts. I have to...
2010-07-30
1,561 reads
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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...
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