Viewing 6 posts - 1 through 6 (of 6 total)
Have you tried this?
Select top 100 * from (
select * from table1
left outer join table2 on table1.id = table2.id
...
July 28, 2014 at 12:47 am
Lowering security permissions to minimum should help too.
GRANT CREATE TABLE to user
and ALTER permission on the schema should be enough:
March 20, 2014 at 3:58 am
GilaMonster (5/27/2013)
ivan.peter (5/27/2013)
Have you read about In-Memory Hash Join (or this link[/url])?
The MSDN entry several times, as well as blog posts by members of the dev team. Written a few...
May 28, 2013 at 1:06 am
GilaMonster (5/27/2013)
ivan.peter (5/27/2013)
- even an execution plan of some queries can be different (faster), if the database knows, the table fits into memory
The optimiser never considers whether...
May 27, 2013 at 5:44 am
Your proposed change will definitely improve performance (if the table isn't empty), because:
1. It's less work to do with the table
- less space means less I/O operations...
May 27, 2013 at 12:50 am
setting password for extraction is similar to archiving 7z e -pPWD archive.zip
July 31, 2012 at 12:56 am
Viewing 6 posts - 1 through 6 (of 6 total)