Virtual Teams: 3 Ways to Improve Efficiency and Performance #virtual #teams
How to enhance the performance of virtual teams
Virtual teams have some advantages, from allowing the best talent recruitment regardless of...
2014-02-18
477 reads
Create Database Error "operating system error 112(There is not enough space on the disk.)"
I try to create database by generating script of another database, which was a huge Database. When I run the script below
USE [master]
GO
CREATE DATABASE [YourDB] ON PRIMARY
( NAME...
2014-02-18
85 reads
Improving SQL Server Performance by using Instant File Initialization
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-02-21 (first published: 2014-02-18)
3,637 reads
Why Sales Organizations Fail
Companies face specific challenges at each stage of their lives. This is a great article on why many sales organizations...
2014-02-18
574 reads
How to check for last SQL Server backup
As a database professional, I get asked to review the health of database environments very often. When I perform these...
2014-02-24 (first published: 2014-02-18)
3,127 reads
THE IIF statement – SQL has it at last.
TweetG’day All,
While I was writing my last blog post about the new SQL SERVER 2012 CHOOSE statement, it also came...
2014-02-20 (first published: 2014-02-18)
13,693 reads
#Stinger : Interactive Query for Apache #Hive #hadoop #bigdata
Apache Hive is the de facto standard for SQL-in-Hadoop with more enterprises relying on this open source project than any...
2014-02-17
587 reads
What Is a Throwout Bearing?
A throwout bearing is a part of an automotive clutch system that temporarily disengages the engine from the manual transmission while shifting....
2014-02-17
448 reads
@Toyota #Hilux Claims Second Pole Position
Toyota Hilux Claims Second Pole Position in Antarctic Race. Have you Hiilux’d?
via Toyota Hilux Claims Second Pole Position (2009).
2014-02-17
512 reads
Capture the Colors of the Olympic Rings for Our Photo Challenge
Monochromatic photos are eye-catching and can bring out details we might miss in regular shots. You can share a single...
2014-02-17
477 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...
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