Snapshot isolation levels improve performance but there are some things to take into consideration when using this feature. Arshad Ali discusses what snapshot isolation levels are, their variants, and why and when we should use them.
A guide to the SQL Server 2008 Business Intelligence exams.
This week Steve Jones wants to know if you can find time for your professional development. Regularly improving your skills is an important part of your career in technology, and the poll this weeks asks what time you can make for improvement.
Despite the neglect of the basic ODBC drivers over the years, they still afford a neat way of reading from, and writing to, CSV files; and to be able to do so in SQL as if they were tables is somewhat magical. Just to prove it is possible, Phil Factor creates a CSV version of AdventureWorks as a linked server.
Performance test of new SQL 2012 functions DateTimeFromParts and Format
Steve Jones attended a day out from the Red Gate offices recently and he talks about the value of those experiences.
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
Learn how you can set up a new SQL Server instance painlessly on Amazon's Relational Database Service (RDS)
Amazon now offers SQL Server 2008 R2 in their RDS service. It's an easy way to get working with SQL Server with a minimal investment.
Identify resource bottlenecks in a stressed transaction replication topology using PERFMON/PAL and system wait stats
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
Comments posted to this topic are about the item AI Experience Gap that we...
There is a table tmp_tab:
CREATE TABLE tmp_tab ( id int, val int );
INSERT INTO tmp_tab VALUES (1, 1), (2, NULL), (3, 3), (4, 4), (5, 5);You want to order the rows ids by the following expression:
ISNULL(val, id) + 1Which of the following queries produces the expected ordering and why? (Select all correct) See possible answers