Tomáš Rybnický, Author at Wetory

Browse: Wetory / Articles by: Tomáš Rybnický

Check if login exists (SQL Server 2000)

Scripts November 6, 2019November 15, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Verify if required login exists in SQL Server 2000 instance and affect workflow. This is simple query to system view sys.syslogins. Checking for existence of principal with given name. So...

Check if login exists

Scripts November 6, 2019November 6, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Verify if required login exists and affect workflow. This is simple query to catalog view sys.server_principals . Checking for existence of principal with given name. So this is useful in...

Byte converter

Posts October 30, 2019October 30, 2019 by Tomáš RybnickýNo Comments Reading Time: 2 minutes

The byte is a unit of digital information that consists of eight bits. You can find it everywhere when storing or processing some information. Especially when working with databases, every...

Posts

Pages September 28, 2019September 30, 2019 by Tomáš Rybnický Comment Closed Reading Time: < 1 minutes

[wp_sitemap_page display_category_title_wording="false" only="post" sort="post_name" order="ASC" display_title="false"]...

Pages

Pages September 28, 2019September 30, 2019 by Tomáš Rybnický Comment Closed Reading Time: < 1 minutes

[wp_sitemap_page only="page" display_title="false"]...

Create admin account

Scripts September 26, 2019September 26, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Simply create new account directly in WordPress database. If you have access to WordPress database running on MySQL but not to WordPress admin you can "hack" it....

Buffer pool usage

Scripts September 10, 2019September 10, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Check buffer pool usage for every database. Returns information about all the data pages that are currently in the SQL Server buffer pool. Use output of this view to determine...

Buffer pool pages distribution

Scripts September 10, 2019September 10, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Check page count stored in buffer pool for every database. Returns information about all the data pages that are currently in the SQL Server buffer pool. The output of this...

Force parameterization for query plan

Scripts September 8, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Let your SQL Server know what query to parameterize if beneficial. When the PARAMETERIZATION database option is set to SIMPLE, the SQL Server query optimizer may choose to parameterize the...

Single use execution plans

Scripts September 6, 2019September 6, 2019 by Tomáš RybnickýNo Comments Reading Time: < 1 minutes

Get execution plans that were used only once. SQL Server from its nature caches all execution plans, even for queries that are executed once. This behavior can be suppressed by...

Byte converter calculator

Author: Tomáš Rybnický