2,324 reputation
313
bio website
location
age
visits member for 2 years, 2 months
seen 27 mins ago

6h
answered How to save and then restore permissions after refreshing a database
9h
comment SELECT with lots of left join is very slow in SQL Server 2014
Regards refactoring, I can reproduce this problem locally and successfully refactored using NOT EXISTS instead of LEFT JOIN ... NOT NULL. Normally I would expect these to behave the same, however this did work in my simple test rig, no query hints required.
10h
comment SELECT with lots of left join is very slow in SQL Server 2014
I would read the Joe Sack whitepaper I link to in my answer. It has a great discussion of the new feature, where it will benefit you and where it might not, plus all the options for enabling / disabling it at different levels.
10h
answered SELECT with lots of left join is very slow in SQL Server 2014
2d
comment Connecting SSIS to Oracle using Attunity Drivers
What edition are you using? eg SELECT @@version. These connectors will only work with Developer and Enterprise.
Nov
23
revised Shared Memory with Microsoft Hekaton
quote and reference added
Nov
19
comment Performance Order By large table with Join
Good new @Tiago. The NOEXPAND hint is required to use indexed views in non-Enterprise editions. How long does your complete stress test take now? Remember the effect on INSERT / UPDATE / DELETE operations indexed views can cause. Consider dropping them before loading the table. Also as a best practice, you should consider upgrading your SQL Server to the latest patch level, SQL 2008 R2 is now at SP3, available here.
Nov
18
comment Performance Order By large table with Join
Well there must be something else going on here. Can you confirm the specs of the box you are working on, OS, CPUs, RAM and the SQL Server edition ( eg SELECT @@version ).
Nov
17
comment Oracle 11g SSIS SQL Server 2014 Truncation
Not sure about your truncation issue but have you used the Attunity connectors to extract data from Oracle with SSIS? Superb performance.
Nov
17
answered Performance Order By large table with Join
Nov
14
comment Clustered Index improvemens for particular queries
So you could use the same indexes I've applied against the indexed views to your original table to get similar results.
Nov
14
comment Get a specific row from a TSQL common table expression
Glad that worked!
Nov
14
comment Clustered Index improvemens for particular queries
Why indexed views as opposed to just indexes @wBob? I suppose I was thinking they give you the opportunity to roll in more complex criteria then we see here for really custom reporting, aggregations etc, but yeah, ordinary indexing would be simpler if requirements allow. OK thanks Bob!
Nov
14
answered Clustered Index improvemens for particular queries
Nov
14
comment Clustered Index improvemens for particular queries
There is also a problem with the datatype on your id column. Specifying NUMERIC without precision or scale defaults to NUMERIC(18,0) and takes 9 bytes to store. This can therefore store numbers up to 999,999,999,999,999,999 aka 999 quadrillion or 999 million billion (ok I had to Wolfram Alpha that : ). As you already know your table will only ever store ~1 million rows, consider NUMERIC(6,0) at only 5 bytes or INT at 4 bytes would actually be much more appropriate here. Spend some time studying your datatypes here.
Nov
13
answered Keep track of time intensive stored procedure with prints
Nov
12
answered Get a specific row from a TSQL common table expression
Nov
12
answered Is there a way to minimally log insert under Always on?
Nov
12
answered How to store immutable, unique, ordered, lists?
Nov
10
comment SQL Server 2012 Standard using too much memory
Any update on this? How are you getting on?