Simon Liew @sqlgt0

Microsoft Certified Master: SQL Server 2008 sqlsme.com.au Sydney, Australia Joined September 2012

Tweets

73
Followers

73
Following

5
Likes

6

Simon Liew @sqlgt0

11 months ago

A neat trick to optimise a full wildcard search in SQL Server mssqltips.com/sqlservertip/8…

0 0 0 7 0

An insightful article on SQL Server 2022 TempDB contention enhancements! Dive into the improvements that can optimize your database performance. Read more here #SQLServer mssqltips.com/sqlservertip/8…

0 0 0 18 0

Simon Liew @sqlgt0

a year ago

Everything you need to know (or might not know yet) about filtered indexes in SQL Server mssqltips.com/sqlservertip/7…

0 0 0 15 0

Simon Liew @sqlgt0

5 years ago

This blog would help you to understand SQL Server Lock Pages in Memory, AWE API and Task Manager bit.ly/3aTnUYk

0 0 1 0 0

Simon Liew @sqlgt0

5 years ago

A lot of DBA set and forget on this - Set SQL max memory, grant LPIM to SQL account, restart SQL service and assume SQL memory now is locked and cannot be paged up to the max memory configuration. That's a very wrong assumption! bit.ly/3lnwOAy #sqlserver #database #sql

0 0 0 0 0

Simon Liew @sqlgt0

5 years ago

An article which describes Performance Counter Target vs Total Memory and its behaviour with SQL Server max memory setting. If you've been working on SQL Server in the administration side, you would find this beneficial #sqlserver #sqldatabase #sql mssqltips.com/sqlservertip/6…

0 0 2 0 0

Simon Liew @sqlgt0

5 years ago

This guy’s a legend. I love how he responded to hoarder and would’ve given him a pat on his shoulder had it not for the social distance rule in place news.com.au/finance/busine…

0 0 0 0 0

Simon Liew @sqlgt0

5 years ago

SQL Server sys.dm_exec_query_plan Query Plan is NULL mssqltips.com/sqlservertip/6…

0 0 1 0 0

Simon Liew @sqlgt0

6 years ago

Get SQL Server Delayed Durability Advantages Without Configuration Changes mssqltips.com/sqlservertip/6…

0 0 0 0 0

Simon Liew @sqlgt0

6 years ago

It might seem like a trivial topic, but still a lot of developers wasn't aware the different ways to write cursor in SQL Serve #sql mssqltips.com/sqlservertip/6…