UK SQL Server User Group

UK SQL Server User Group

Community of Microsoft Data Platform Professionals

  • SQLFAQ Home
  • Communities

Category: Execution Plans

A first look at SQL Server 2016–String_split

13th March 2016 davebally

I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO, has been missing.  That is grouped string concatenation (ie forming a delimited string ) and string split ( breaking … Continue reading →

Read more
Development, Execution Plans, SQL 2016, SQLFAQ SQL Server

My favourite wait state– ASYNC_NETWORK_IO

28th February 2016 davebally

Sometimes it does feel that a problem is a database problem until proven otherwise.  When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys.  One of the easiest ( … Continue reading →

Read more
Execution Plans, SQLFAQ, TSQL Tuning Performance, SQL Server

SQL Saturday 496 Exeter – PreCon Agenda

14th February 2016 davebally

Hi Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like to thank the team though for selecting my pre-con.  Let me know if you would have liked to attend and … Continue reading →

Read more
Execution Plans, Speaking, SQLFAQ Performance, SQL Server

Please please tell me now…

15th August 2014 davebally

.. Is there something I should know,  sang Duran Duran many moons ago when I was young and before I knew that query optimization was even a thing.  But,  it is quite a handy little line to keep in mind … Continue reading →

Read more
Execution Plans, SQLFAQ, TSQL Tuning Performance

Reasons why your plans suck : No 56,536

12th April 2014 davebally

I have been working with SQL server for more years than I really care to mention and like to think that I am now quite comfortable with the internals, specifically the Query Optimizer. Every so often though a new problem … Continue reading →

Read more
Execution Plans, SQLFAQ, TSQL Tuning Performance

Sidebar

Please go to Appearance → Widgets and add some widgets to your sidebar.

Powered by WordPress and Courage.