Meme 2 - A Quick Meme Monday Post.....
Well, ok. I'll jump on the bandwagon again.
Power has been restored to Mr. LaRock's Residence, just in time for meme Monday.
(And really,...
2011-06-06
1,170 reads
Column order can matter
Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...
2011-06-06
2,191 reads
The Importance of a Business Recovery Plan
Recently I was in one of those chain restaurants (the middle-priced, sit-down types) and shortly after we got there, we...
2011-06-06
1,902 reads
Is There Something Wrong With The Database?
I can think of no other simple phrase that has the same pent up potential to ignite the most colourful...
2011-06-05
595 reads
Kent .Net/SqlServer User Group – Upcoming events
At the Kent user group we have two upcoming events. Both are to be held at F-Keys Training suite http://f-keys.co.uk/...
2011-06-05
650 reads
Using Nightly Populated Tables For Faster SQL Queries
A discussion about nightly populated tables and how they have reduced SQL Server load.
What’s more important – speed or data accuracy/quality...
2011-06-05
1,302 reads
Static or “global” variables in T-SQL using CLR UDT
I faced problem that I had many lookup tables like ProductType, ClientType etc. and wanted to refer to their values...
2011-06-05
1,786 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
584 reads
Maximum recursion possible with CTE in SQL Server 2005/2008
In my last blog about Tally Tables, we talked about the use of
recursive CTEs to generate Tally Tables. Following that,...
2011-06-04
20,306 reads
What is SSMS Addin
SSMS is abbreviation of SQL Server Management Studio, according to Microsoft description it is “an integrated environment for accessing, configuring,...
2011-06-03
724 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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