SQL Server Keyboard Shortcuts
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you...
2014-08-22 (first published: 2014-08-18)
9,769 reads
SQL Server Keyboard Shortcuts for Management Studio
SQL Server Management Studio is filled with lots of optional settings that lets you...
2014-08-22 (first published: 2014-08-18)
9,769 reads
How Business Intelligence Can Help
Effective business intelligence starts with questions that will help your organization make better decisions. For example,...
2014-08-04
670 reads
Regardless of the type of development (application or reporting) that you are performing on SQL Server. There are 5 items...
2014-07-23 (first published: 2014-07-17)
9,721 reads
Azure HDInsight Overview
HDInsight is a cloud based implementation hosted in the Microsoft Azure cloud. It enables you to quickly create,...
2014-07-10
492 reads
SQL Server 2014
Below is a listing of the SQL Server 2014 new features and where you can find more information...
2014-07-02
1,926 reads
Azure Data Services
Microsoft’s Azure data services provides you with a method to enhance your enterprise architecture and business intelligence options. ...
2014-06-21
1,115 reads
ETL Process
Reporting databases need to consolidate data from across many applications within an organization. In order to successfully pull data...
2014-06-11
1,499 reads
Languages of Big Data
Big Data is here and rapidly growing. If you are just starting to learn about Big Data...
2014-05-26
854 reads
SharePoint 2013 External Data Connections
SharePoint 2013 External Data Connections are part of the Business Connectivity Services (BCS) that can be...
2014-05-18
1,252 reads
How does MongoDB Store Data?
What is MongoDB? MongoDB is a document oriented database. This means it stores its data in...
2014-05-12 (first published: 2014-05-04)
3,864 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
Comments posted to this topic are about the item The "ORDER BY" clause behavior
Comments posted to this topic are about the item Are IT Certifications Still Relevant?
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers