Quick tip: WMI alerts and SQL Server Agent permissions.
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,377 reads
I came across an issue today while trying to create a WMI alert for a mirroring state change. The error...
2013-08-15
1,377 reads
SQL Server 2014 CTP is available for download and evaluation and it contains a couple of exciting performance enhancements. One...
2013-07-08
2,494 reads
I was asked a good question the other day, one that I wasn’t sure of the answer. The question was...
2013-05-22
1,358 reads
In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...
2013-04-11 (first published: 2013-04-03)
3,985 reads
I’ve been looking into the behaviour of statistics in SQL Server 2008 – so I’d like to present an overview from...
2013-02-20 (first published: 2013-02-14)
7,012 reads
Introduction:
I came across a couple of subtle gotchas around the permissions required to restore a database in SQL Server 2008+...
2013-01-10
5,569 reads
There’s a lot of things to consider when migrating databases between SQL Server instances. I want to provide some tips...
2012-11-26 (first published: 2012-11-13)
4,054 reads
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...
2012-11-02 (first published: 2012-10-31)
4,406 reads
Here are a couple of quick database and table level queries that I have found useful lately.
How many rows in...
2012-10-30
1,610 reads
A question that a DBA will often be asked is what databases are actively being used on my SQL Server?...
2012-10-17
2,937 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