T-SQL Tuesday #7: T-SQL Enhancements in SQL 2008.
In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008...
2010-06-08
1,120 reads
In this edition of T-SQL Tuesday, Jorge Segarra (Blog | Twitter) asks us what our favorite new feature of SQL 2008...
2010-06-08
1,120 reads
I’ll be at TechEd on Monday/Tuesday. Not going to sessions as I don’t have the time to stay there all...
2010-06-07
358 reads
I recently installed a new SQL Server 2008 instance on a brand new Windows 2008 R2. When I tried to...
2010-06-07
645 reads
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-06-07
482 reads
Today I am finally getting around to the review of the first chapter as promised. I talked about the book...
2010-06-07
799 reads
We all know that indexes on tables help performance. However, sometimes too much indexing could affect performance as well. One...
2010-06-07
599 reads
Sorting results in a tabular style report is a common request from business users. Sometimes, they want to see the...
2010-06-07
846 reads
The S3OLV monthly meeting is being held this Thursday. We will be meeting at the same location and time as...
2010-06-07
488 reads
You need consistent, reliable data. You want data that you can trust.
This is usually data about your transactions, slowly changing...
2010-06-07
547 reads
SQL Saturday #22 was held on Saturday, June 5, 2010, with about 224 attendees participating in this free event. It...
2010-06-07
1,089 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