Error : Property Size is not available for Database "[tempdb]"
Today when I clicked Properties of tempdb in SSMS, I got the error message below:
At first I thought the database...
2014-01-23
6,511 reads
Webcast Follow-Up: The Flavors of Non-Clustered Indexes
Earlier today, I presented a session for Pragmatic WorksTraining on the T’s titled The Flavors of Non-Clustered Indexes. In the session,...
2014-01-23
774 reads
Star Schema The Complete Reference – Review
I finished my first book of this year and here’s the review! After I finished the newest edition of Ralph...
2014-01-23
1,185 reads
More on Password Managers
Last week I posted about reviewing passwords and mentioned using a password manager as part of that effort. DaniSQL noted...
2014-01-23
798 reads
Its the little things – Service Master Keys
In advance of the yearly licensing reconciliation with Microsoft at work, I have led the charge to ensure all of...
2014-01-23
628 reads
Rochester – Welcome to the PASS MN Family
It started as a vision for expanding the reach of the Minnesota SQL Server User Group a year ago. At...
2014-01-23
683 reads
Powershell in a Month Day 12 – A Practical Interlude
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-22
872 reads
Get SQL Server Physical Cores, Physical and Virtual CPUs, and Processor type information using Transact-SQL (T-SQL) script
Today, I received email from one of my blog follower asking if there is any DMV or SQL script, which...
2014-01-22
2,313 reads
Tip: Jobs without a scheduled run
It’s awfully comforting to see all those backup and maintenance jobs in your SQL Agent list, isn’t it? It’d be...
2014-01-22
538 reads
Using multiple CTEs in one query
This is a fairly simple thing to do, but I had to look it up the other day and thought...
2014-01-22
1,403 reads
Blogs
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, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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