Automatically name primary key constraints in SSDT
Automatically name primary key constraints There are some things you see when writing t-sql code and schemas that just look...
2015-11-16
34 reads
SQL Server Error Log Reader
Reading the SQL Server Error Log is miserable. It contains very useful information you should address as soon as possible,...
2015-11-16
709 reads
SQLNewBlogger, Week 3
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
227 reads
SQLNewBlogger, Week 3
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
222 reads
SQLNewBlogger, Week 3
I have a confession to make: I haven’t been writing much this week.
Last weekend, I didn’t feel well and didn’t...
2015-11-15
329 reads
Duplicate MySQL Table Using phpMyAdmin
There many reasons for creating copies of existing relational database tables. Sometimes you create duplicate tables for the purposes of...
2015-11-14
3,591 reads
Thankful in November
I’m taking a short break from technical talk today to spend a few minutes thinking about life. My wife started...
2015-11-13
554 reads
How to identify the source of page splits in a database
Page splits can slow down your queries and increase the amount of I/O needed to retrieve your data.
So, how do...
2015-11-13
2,194 reads
Add Dependencies to a SQL Server Resource in Windows 2003
Read My Article "Here"
For more updates:
Subscribe for Blog posts [Click Here]
Follow FB Page [Click Here]
Follow FB Group [Click Here]
For Suggestion & Feedback mail us at gana20m@gmail.com
2015-11-13
101 reads
How do we insert the results of the stored procedure in a table?
This question has two crinkle answers –· When the table is already created.
· When the table is to be created run...
2015-11-13
152 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers