My Adventures with the SQL 2005 Security Cache
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
483 reads
Introduction
For that past couple of months I have been chasing performance issues with one of the most high profile servers...
2010-03-09
483 reads
Introduction
Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing...
2010-02-25
409 reads
Introduction
I am frequently getting requests for a new server to do this or that. Running through the usual questions to...
2010-02-23
461 reads
Introduction
Here is another one of my utility scripts. Lately it seems like all I am blogging about is utility scripts,...
2010-02-01
1,996 reads
Introduction
Ever need a programmatic way to figure out if a SQL Agent job is running? I did. After spending a...
2010-01-31
2,434 reads
Introduction
Lately it seems like I am being bombarded by Dynamic SQL and people who insist it is the only way...
2010-01-21
613 reads
Introduction
Traditionally when doing a restore, moving a database, etc. a DBA would simply go into Management Studio and use the...
2009-12-31
1,687 reads
Introduction
Tonight on Twitter the call went out on #SqlHelp looking for a way to script just database permissions for a...
2009-12-31
1,411 reads
Introduction
Properly managing VLFs can make or break the performance of your databases. There is a ton of information out there...
2009-12-21
847 reads
Introduction
From time to time you find yourself needing to shrink some space out of TempDB. Shrinking database files is never...
2009-12-17
2,964 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...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
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