Simon's SQL

SQL,DBA,tuning,Trouble Shooting,Performance

Archive for February, 2017

sys.sysobjvalues

Posted by Simon Cho on 02/23/2017

 

https://jongurgul.com/blog/tag/sysobjvalues/

Posted in Common | Tagged: , | Leave a Comment »

SQL Angeles Meeting 2/14 – Los Angeles

Posted by Simon Cho on 02/15/2017

SQL Angeles,

We had a meeting at 2/14, Los Angeles.

Here are the presentation file and Demo script.

Topic : Transaction Management and the Transaction Log

DownLoad

SQLPassNew February : sqlpass_news_chapter-deck-february-2017-2

 

SQL Angeles is the Local Chapter based on Los Angeles area.

Our community is for Korean SQL people.

So, we do speak in Korean during the presentation.

This time is the first try with Skype Business Online.

 

We had 5 people from Local and 9 people joined in Skype Business and shared the session together.

Thank you very much for participated in.

 

Here is the detail information how to register and join us.

http://sqlmvp.kr/220936150336

 

 

Posted in Common | Tagged: , | Leave a Comment »

Delayed Durability

Posted by Simon Cho on 02/14/2017

  • ALTER DATABASE SET DELAYED_DURABILITY = {option}
  • Disabled –Normal behavior durability guaranteed.(Default)
  • Allowed –Allowed at the DB Level, Transaction has to specify durability options, default is a durable transaction.
  • COMMIT TRAN……. WITH (DELAYED_DURABILITY=ON)
  • FORCED –Changes default durability for the DB to “delayed”. Can be useful for Applications bottlenecked on Log IO, that can tolerate some Data loss on a failure.

 

https://msdn.microsoft.com/en-us/library/dn449490(v=sql.120).aspx

 

http://info.tricoresolutions.com/blog/delayed-durability-diminishes-i/o-throughput-to-improve-performance-in-the-sql-query

Posted in Common | Tagged: | Leave a Comment »

parameter sniffing recompile options

Posted by Simon Cho on 02/06/2017

https://sqlperformance.com/2013/08/t-sql-queries/parameter-sniffing-embedding-and-the-recompile-options

Posted in Common | Tagged: , | Leave a Comment »

SQLCMD mode in SSMS

Posted by Simon Cho on 02/01/2017

SQLCMD mode in SSMS

Here are some commands very useful. Things help to deploy complicated queries.

 

:CONNECT localhost
:setvar DBA “DBA”

:on error exit
GO

USE [$(DBA)]
go
SELECT DB_NAME()

print ‘abc.sql – Simon’

:r c:\temp\abc.sql
GO
print ‘abcdef.sql – Simon’
:r c:\temp\abcdef.sql
GO

Posted in Common | Tagged: | Leave a Comment »