Table Variable Performance “Fixed” in SQL 2019

• by Matthew McGiffen

• Matthew McGiffen DBA

Reading the new features for SQL 2019 I spotted this:
One of the most popular posts on my blog last year...

2018-10-03 (first published: 2018-09-25)

2,523 reads

Don’t Just Rely on Query Execution Stats for T-SQL Execution

• by Matthew McGiffen

• Matthew McGiffen DBA

I recently had an incident where I was looking into the cause of a long running process for a client....

2018-09-28 (first published: 2018-09-18)

2,070 reads

TRY_PARSE

• by Matthew McGiffen

• SQLServerCentral.com

• T-SQL

Introducing the PARSE function, brought to us in SQL Server 2012.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.55 (11)

Log in or register to rate

2018-09-13

2,076 reads

• Discuss

T-SQL Tuesday #106 – The Trouble with Triggers

• by Matthew McGiffen

• Matthew McGiffen DBA

For this month’s T-SQL Tuesday Steve Jones asks us to talk about our experiences with Triggers:
https://voiceofthedba.com/2018/09/03/t-sql-tuesday-106-trigger-headaches-or-happiness/
In my post I’m going...

2018-09-12

244 reads

Exporting Extended Events Session Data to a Table

• by Matthew McGiffen

• Matthew McGiffen DBA

If you’re a long time Profiler user like me then you probably often take the option of saving (or loading)...

2018-08-23 (first published: 2018-08-08)

1,866 reads

Using the built-in System Health session

• by Matthew McGiffen

• Matthew McGiffen DBA

When Microsoft introduced Extended Events (XE) in 2008, they also gave us a built-in XE session called system_health (though it’s...

2018-08-16 (first published: 2018-08-01)

3,663 reads

There’s Still a Place for SQL Server Profiler

• by Matthew McGiffen

• Matthew McGiffen DBA

Follow a few of the SQL Family on Twitter and you’ll mostly see one view regards SQL Profiler, and it’s...

2018-08-09 (first published: 2018-07-25)

2,246 reads

PARSE

• by Matthew McGiffen

• SQLServerCentral.com

• PARSE()

Introducing the PARSE function, brought to us in SQL Server 2012.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.89 (19)

Log in or register to rate

2018-07-24

1,847 reads

• Discuss

T-SQL Tuesday 104 – Capture expensive queries with query store

• by Matthew McGiffen

• Matthew McGiffen DBA

For this month’s T-SQL Tuesday Bert Wagner invites us to share SQL scripts we’ve written that we’d hate to live...

2018-07-10

282 reads

Alter Multiple Databases at Once

• by Matthew McGiffen

• Matthew McGiffen DBA

This is a quick and dirty method I often use when I want to make a change to multiple databases...

2018-07-03 (first published: 2018-06-26)

2,312 reads