Creating a Filetable
How do you create a filetable? I assume you’ve enabled Filestream and created a filegroup for your filestream and filetable...
2012-06-11 (first published: 2012-06-05)
5,448 reads
Blog Posts
ORM Tools
ORM tools. They’re great. They’re evil.
In the right hands, used the proper way, they can be a very powerful, very...
2012-06-11
3,494 reads
Performance reviews – Self-evaluations
My annual performance review at work is coming up shortly, and this year they’ve decided to do things a bit...
2012-06-11
3,073 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using RANK() function.DECLARE @StudentScore TABLE(StudentName VARCHAR(1),StudentScore INT)INSERT @StudentScore VALUES ('A',85),...
2012-06-11
65 reads
RANKING Function in plain SQL
Below examples will show that we can still write a pure sql query for RANK, DENSE_RANK and ROW_NUMBER without using...
2012-06-11
321 reads
Slipping in a Break
I know some people like long holidays, but I tend to prefer short ones. Today is one of those breaks...
2012-06-11
861 reads
Sorry, Mikko, the box was already open
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,398 reads
SQL Server 2012 Diagnostic Information Queries (June 2012)
Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including...
2012-06-11
1,723 reads
Data Quality; the road to Accurate Reporting
I am sure you have heard of the term; garbage in garbage out. This maxim is even more true when...
2012-06-10
925 reads
PASS 2012 Summit: November 6-9
I just received an email message from the PASS Global Summit 2012 organizers after submitting session abstracts a few weeks...
2012-06-10
1,207 reads
Blogs
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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...
Forums
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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...
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