ASP Is Fun

ASP Is Fun

ASP Classic Code and Contracting

  • Home
  • ASP Course
  • Functions / Commands
  • Sample ASP Code
  • ASP Books
  • ASP Contract Programming
  • Blog

SQL Commands

SQL Commands on ASPIsFun

Lock Wait Timeout Exceeded; Try Restarting Transaction – SQL Error 1205

July 1, 2022 Lisa Shea 0

If you work with really large tables (or, I suppose, a really slow server), you are eventually going to risk hitting this error. Lock wait […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

You Are Using Safe Update Mode / SQL Error 1175

July 1, 2022 Lisa Shea 0

Have you ever had this happen? You’re just trying to run a SQL script to update a table. Suddenly the SQL system balk at you. […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
SQL Commands on ASPIsFun

Lost Connection to MySQL Server During Query – Fixing a SQL Error Message

July 1, 2022 Lisa Shea 0

It’s probably happened to every SQL developer at least one time during their coding projects. They are running queries. Suddenly they get the error message […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

Query Execution was Interrupted in ASP

June 1, 2022 Lisa Shea 1

It’s one of the more frustrating errors you can get in ASP coding against a SQL database. Query execution was interrupted, maximum statement execution time […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Notifier Error Cannot Initialize Main Application

June 8, 2021 Lisa Shea 0

What do you do when you get the error from MySQL Notifier that says: Error – Cannot initialize main application. Root element is missing. If […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Bin Files Adding Taking Up Disk Space

June 8, 2021 Lisa Shea 0

MySQL is a database built on underlying files. What happens if you look into your MySQL data directory and realize that huge BIN extension files […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

MySQL vs MSSQL Updating Based On Two Tables

December 1, 2019 Lisa Shea 1

In most cases, MySQL code and MSSQL code is fairly similar. If you have a website running on MSSQL you can reconnect it to a […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

Tuning Your MySQL my.ini File for High Website Traffic

November 14, 2019 Lisa Shea 0

If you’ve got high website traffic on your MySQL blog or site, you can quickly find that MySQL bogs down and slows. You’ll need to […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Tuning – increasing thread_cache_size to allow more simultaneous users

November 14, 2019 Lisa Shea 1

As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. One of the values to work with is […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...
MySQL Settings

MySQL Tuning – increasing max_connections to allow more simultaneous users

November 14, 2019 Lisa Shea 1

As your website gets more traffic, you’ll find that you run into problems where MySQL slows down. It has to wait for existing users to […]

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Posts navigation

1 2 3 »

Follow Us

  • Twitter
  • Facebook

Recent Posts

  • Setting a Default Font in Word
  • Android Zoom Not Working with Bluetooth Speakers
  • Google *Services on Credit Card Statement
  • Calendar in Microsoft Outlook – Printing Multiple Calendars on One Page
  • Errors Upgrading PHP for a WordPress Blog

Categories

  • ASP Course
  • Basics
  • Books
  • Contracting
  • Functions
  • Hosting
  • Musings
  • News
  • Sample Code
  • SQL Commands
  • Windows and IIS
  • WordPress

Ebooks

Newsletter

Subscribe to our mailing list

* indicates required

Advertising

Archives

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

RSS Link for ASPIsFun

  • RSS - Posts
All content on this site is written by ASP programmer Lisa Shea who is available for contract work. Content copyright (c) 2021. This site is part of the Minerva Webworks site suite.
Hosted By
Tweets by ASPIsFun
Follow Us
  • Twitter
  • Facebook

Copyright © 2023 | WordPress Theme by MH Themes

%d bloggers like this: