Quick Roundup of Intel Ivy Bridge Reviews
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,047 reads
Blog Posts
Run SSMS as different Windows user
When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...
2012-04-23
2,437 reads
SQL Server 2012 Core Factor Table for AMD Processors
As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can...
2012-04-23
2,970 reads
Sysprocesses CPU and CPU Percentage - utilization
I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...
2012-04-23
1,259 reads
The Importance of a SQL Server Inventory
Pop quiz!
It’s time to true-up with Microsoft, what are your current license counts?Operations needs to schedule maintenance on ServerY, what...
2012-04-23
2,728 reads
2012-04-23
1,240 reads
Windows 2008 Server : Moving Cluster Quorum Disk to New SAN
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,486 reads
2012 DDL for Roles
TweetG’day,
I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored...
2012-04-22
1,337 reads
SQLSaturday in Houston Presentation
Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.
Here is the PowerPoint presentation: Scaling...
2012-04-22
935 reads
SQL Saturday Houston #107 - SQL Server Best Practices with DMV Presentation Files
Thanks for joining me for a standing room only presentation this morning at 9:45am at SQL Saturday #150 Houston. This...
2012-04-21
846 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