MS SQL Server : Nested Transaction and Partial Rollback of Transaction
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,107 reads
Couple of days back, one of my colleague came to me and asked about partial rollback of a transaction.He was trying...
2012-05-20
13,107 reads
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,455 reads
In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance....
2012-04-20
11,645 reads
When I was working with couple of frequent blocking issue in our live server, I have noticed different types of...
2012-04-12
28,312 reads
When I had a discussion with couple of my friends about index fragmentation, I realized that they have different understanding...
2012-04-06 (first published: 2012-04-05)
35,003 reads
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,934 reads
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,871 reads
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,234 reads
OR
How do you allow non-administrator to use xp_cmdshell ?
From the day I started working with SQL server, I have heard
about...
2012-03-22
4,496 reads
Yesterday evening one of the developer asked me that he need a help in importing images into a table. It...
2012-03-15
10,845 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
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