Script to analyse space usage by your Service Broker
I believe that service broker is one of the best features from SQL server 2005, well along with the xml...
2012-04-16
2,508 reads
Blog Posts
SQL Saturday #111 Atlanta recap and links and stuff and things….
I particularly enjoy SQL Saturdays in Atlanta for a few reasons. It gives me an excellent excuse to come out...
2012-04-16
700 reads
SQL Saturday 136 – Wellington. Speakers review.
TweetG’day,
On Saturday 16th April 2012, I attended SQL Saturday #136 in Wellington, New Zealand.
The day was run by Dave Curlewis [Blog...
2012-04-16
1,114 reads
SQLSaturday #151 Announced–Orlando!
Just got the email, Orlando will be having its sixth annual SQLSaturday this year on September 29th, 2012, at Seminole...
2012-04-16
571 reads
SQLSaturday in Houston
I will be speaking at the Houston SQLSaturday this upcoming Saturday (April 21st). Below is info on my session, which...
2012-04-16
632 reads
Three Mistakes Managers Make
I suppose there is an almost limitless number of mistakes that managers can do and do make, it’s the nature...
2012-04-16
1,020 reads
Adding , Deleting and Updating a Column in a table
Many times we need to alter the table definition by adding , deleting or updating a column in the table. In...
2012-04-15
1,437 reads
Derived Table In Sql Server
Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It is...
2012-04-15
18,014 reads
Massively Parallel Processing and the Parallel Data Warehouse
Data growth is related to Moore’s law. As computers get faster and more powerful, we are using them to process...
2012-04-15
7,810 reads
New road to the SQL Server 2012 Certifications
MS has announced the new road for the SQL Server Certifications. All of the interested folks knows that the old...
2012-04-14
2,080 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
Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure
Comments posted to this topic are about the item Optional Parameter Plan Optimization in...
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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