2018-11-19
5 reads
Vivek's SQL Notes
2018-11-19
13 reads
Know How to Import SQL Server database From One to Another
Looking to import SQL Server database from one server to another ? Confused how to copy from one to another or...
2018-10-05
1,833 reads
Blog trasfering to new hosting server
Hi Friends,
This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry...
2018-04-10
277 reads
Blog trasfering to new hosting server
Hi Friends,This blog is now transferring to different hosting server. So you may got some issue in accessing it. Sorry for the inconvenience caused
2018-04-10
22 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server...
2018-03-30
9,756 reads
SQL Script to find the database & their files details on a SQL Server
Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name2) Database ID3)...
2018-03-30
19 reads
SQL Script: - How to find the database restoring history of SQL Server databases
Sometime we need to find out the history of database restoration to get the answers of following questions: -
1) Do...
2018-03-30
8,167 reads
SQL Script: - How to find the database restoring history of SQL Server databases
Sometime we need to find out the history of database restoration to get the answers of following questions: -1) Do we need to restore the database again as there...
2018-03-30
20 reads
SQL Script: - How to find the last access date of a database
Sometime we create databases on Test/ Development database servers for temporary uses for short duration and forgot to delete them...
2018-03-29
1,919 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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