|
|
-
Nakul Vachhrajani Commented 3 Months ago through Ask
If I have understood your question correctly, a simple ORDER BY would suffice - no need of an aggregation.
USE tempdb;
GO
--Test Table
DECLARE @countryTable TABLE (CountryName VARCHAR(20), CountryPopulation DECIMAL(20,8));
...
|
-
Nakul Vachhrajani Liked 3 Months ago through Blogs
Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. Three parts have been published till date, and for your kind reference, here are the links to them: What is a S...
|
-
Nakul Vachhrajani refreshed 3 Months ago through Blogs
Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. Three parts have been published till date, and for your kind reference, here are the links to them: What is a S...
|
-
Nakul Vachhrajani Commented 3 Months ago through Ask
Are you looking for something like this?
USE AdventureWorks2008R2 ;
GO
SELECT isc.TABLE_SCHEMA,
isc.TABLE_NAME,
COUNT(isc.COLUMN_NAME) AS NumberOfColumnsInTable
FROM INFORMATION_SCHEMA.COLUMNS AS isc
...
|
-
Nakul Vachhrajani Liked 3 Months ago through Blogs
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
Nakul Vachhrajani refreshed 3 Months ago through Blogs
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
Nakul Vachhrajani Posted 3 Months ago through Blogs
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
An error that is known how to solve it, I was the victim today with it and when I started the SSMS, I saw that error. I’m telling you here how to fix it as fast info and references from MS.
This error usually comes when your DB no longer exists or it is...
|
|
|
-
Nakul Vachhrajani Commented 3 Months ago through Blogs
I would believe that HAVING is just like a WHERE clause - with the only difference being in the sequence of execution....
|