SQL Saturday Houston #107 Recap
I enjoyed a long weekend in Houston starting with Kalen Delaney’s Pre-con on Query Tuning. I have learned over the...
2012-04-27
1,654 reads
Blog Posts
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it...
2012-04-27
21 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune
the DefaultBufferMaxRows and DefaultBufferSize, so here goes.
When a source is pulling in data, it places them into...
2012-04-27
226 reads
SSIS Data Flow Tuning
During my SSWUG webcast I was asked to give some examples on how to tune the DefaultBufferMaxRows and DefaultBufferSize, so...
2012-04-27
2,826 reads
AlwaysOn Failover Bug
I just found a little bug in AlwaysOn. It’s actually not that big a deal, but it’s interesting. In a...
2012-04-26
1,251 reads
April Hammond .net User Group Presentation - SQL Server Security and Permissions
Here's the slide deck and sample files from last night's presentation at the Hammond .net User Group. We discussed SQL...
2012-04-26
978 reads
Beer, Cheese and SQL Saturday 118 Madison
This past weekend I (w|t) headed up to Madison, WI to attend and present at SQL Saturday 118. The MADPASS...
2012-04-26
997 reads
Offset without OFFSET
A while ago Robert Cary posted an article on SQL Server Central entitled 2005 Paging – The Holy Grail which is,...
2012-04-26
2,035 reads
See you at SQL Saturday 130 Jacksonville!
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
901 reads
SQL Server 2012 Diagnostic Information Queries (April 2012)
It is hard to believe, but SQL Server 2012 has been GA for nearly a month now. Because of this,...
2012-04-26
2,706 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
Kontak Bank BCA KCP Purwosari [083178278662]
Alamat BCA KCP Purwosari WHATSAPP:083178278662 Solo Center Point, Ruko No. A11 & A12, Sondakan,...
Alamat Bank BCA KCP Palur [083178278662]
WHATSAPP:083178278662 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa Tengah...
Question of the Day
ORDER BY alias
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