1,999 reputation
311
bio website
location
age
visits member for 2 years, 1 month
seen 47 mins ago

10h
revised WITH Clause UNION Issue
typo
11h
answered WITH Clause UNION Issue
20h
comment Transaction Isolation level different threads massive number of Writes
Writes to a SQL Server 2014 in-memory OLTP table are "superfast". Enterprise-only though.
Oct
20
answered How can I use expressions as arguments to EXEC?
Oct
20
answered How to get OUTPUT $action, Inserted.*,Deleted.* records in In SSIS
Oct
20
comment Strange query results for DELETE with ROW_NUMBER
@ypercube Irrelevant.
Oct
20
comment Strange query results for DELETE with ROW_NUMBER
@MartinSmith By unsafe, I'm referring to the fact that when attempting to use this method and attempting to inspect the output using the OUTPUT clause, you run into an unexpected bug in the current SQL Server implementation. Imagine if some logic was based on that output? eg Composable DML. That would then lead to a bug in app code. Unsafe. Regarding set-based, I am referring to the fact that my approach is a classic set-exception approach. The original approach, assigning an artificial row identifier to every record in the set using window function extensions just to delete them, is not.
Oct
19
comment Strange query results for DELETE with ROW_NUMBER
@martinsmith No I am suggesting set-based DELETE rather than DELETE with window function. On reflection it's safer too.
Oct
19
comment Strange query results for DELETE with ROW_NUMBER
@ypercube It's a workaround for what I believed to be the general logic requrid for the query: "Delete some rows, keep these". OP has also indicated it's a "valid workaround".
Oct
19
answered Strange query results for DELETE with ROW_NUMBER
Oct
18
awarded  Explainer
Oct
18
comment Subqueries in SQL Server 2014
Where you in the right database when you ran the script? I am using 'student' as an alias for FeeStudent, as per your original question.
Oct
18
revised Subqueries in SQL Server 2014
Code Sample included
Oct
18
suggested suggested edit on Subqueries in SQL Server 2014
Oct
18
answered Subqueries in SQL Server 2014
Oct
17
comment Clustered Columnstore indexes in SQL Serer 2014 for data warehousing
Also regarding "no value", non-clustered columnstore is a separate structure, taking separate space and although you can partition switch data in it wasn't updateable in the usual way. The clustered columnstore is completely writeable and basically is the data stored in columnar format, offering two levels of compression (COLUMNSTORE and COLUMNSTORE_ARCHIVE). The documentation advertises up to 7x, but I've seen much higher values, depending of course on the data. YMMV.
Oct
16
comment Filtering the results of a SELECT query to avoid certain words in the value of a column?
Translated to MySQL here: sqlfiddle.com/#!2/94adef/13/0
Oct
10
revised Terrible Bad Query Plan
SQL Server 2008 R2 tag added
Oct
10
suggested suggested edit on Terrible Bad Query Plan
Oct
10
comment Terrible Bad Query Plan
The sql plans show build 10.50.4319.0 which is SQL 2008 R2 SP2 CU 13.