Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
performance
»
Query Tuning
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
April 1st
Bugs
Community
DDD
Entity framework
LINQ
PASS
Speaking
SQL 2011
SQL Engine
SQL Profiler
SQL Server 2005
SQL Server 2008
SSAS
SSIS - Integration Services
Tips and Tricks
Training
TSQL
undocumented
SQL Server Training in the UK–SSIS, MDX, Admin, MDS, Internals
If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb. Why this company rather than any others? Training based on real world experience...
Posted to
SimonS Blog on SQL Server Stuff
by on Wed, Nov 23 2011
Filed under:
Filed under:
Training
,
Performance
,
Query Tuning
,
SSIS - Integration Services
,
SSAS
Great article on costs of query plans
I’ve not seen anyone go into this details before in explaining costing of queries. Whilst I would avoid getting hung up on the specifics of a cost as these will change from release to release. Its a very interesting read about how and why cost optimisation...
Posted to
SimonS Blog on SQL Server Stuff
by on Fri, Sep 3 2010
Filed under:
Filed under:
Performance
,
Tips and Tricks
,
Query Tuning
,
undocumented
Scream if you want to go faster
My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...
Posted to
SimonS Blog on SQL Server Stuff
by on Wed, May 19 2010
Filed under:
Filed under:
SQL Server 2008
,
SQL Server 2005
,
Performance
,
Tips and Tricks
,
Query Tuning
,
PASS
Microsoft guarantees the performance of SQL Server
I have recently been informed that Microsoft will be guaranteeing the performance of SQL Server. Yes thats right Microsoft will guarantee that you will get better performance out of SQL Server that any other competitor system. However on the flip side...
Posted to
SimonS Blog on SQL Server Stuff
by on Thu, Apr 1 2010
Filed under:
Filed under:
Performance
,
Query Tuning
,
SQL 2011
,
April 1st
Entity Framework how to stop your DBA having a heart attack
My code and presentation from my session at Developer Day 8 are now available here DDD_8-Entity_Framework Code Entity framework presentation Any questions let me know Read More...
Posted to
SimonS Blog on SQL Server Stuff
by on Sat, Jan 30 2010
Filed under:
Filed under:
Community
,
Performance
,
Query Tuning
,
Entity framework
,
DDD
,
Speaking
,
LINQ
User defined function performance is awful, Micorosft please sort this out
User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone...
Posted to
SimonS Blog on SQL Server Stuff
by on Thu, Jan 14 2010
Filed under:
Filed under:
SQL Server 2008
,
SQL Server 2005
,
Performance
,
Tips and Tricks
,
Query Tuning
,
TSQL
,
SQL Engine
,
Bugs
,
SQL Profiler
DDD 8 vote for the sessions you want
DDD8 is at the end of the month. They've now opened voting for the sessions that are to be held. http://developerdeveloperdeveloper.com/ddd8/Users/VoteForSessions.aspx so get voting. By the way I've submitted two sessions, one an extended version...
Posted to
SimonS Blog on SQL Server Stuff
by on Tue, Jan 12 2010
Filed under:
Filed under:
Community
,
Performance
,
Tips and Tricks
,
Query Tuning
,
DDD
,
Speaking
Entity Framework - MergeOption.NoTracking and CompiledQuery.Compile
Two things that people tell you about Entity framework performance are, use the Compiled Queryies and potentially remove tracking when its not needed. You can achieve this by using the CompiledQuery.Compile function to obtain a function that is your compiled...
Posted to
SimonS Blog on SQL Server Stuff
by on Sat, Jan 2 2010
Filed under:
Filed under:
Performance
,
Tips and Tricks
,
Query Tuning
,
Entity framework
Page 1 of 1 (8 items)