Robot | Path | Permission |
GoogleBot | / | ✔ |
BingBot | / | ✔ |
BaiduSpider | / | ✔ |
YandexBot | / | ✔ |
Sitemap: http://www.jesshudzik.com/sitemap.xml Sitemap: http://www.jesshudzik.com/news-sitemap.xml User-agent: * Disallow: /wp-admin/ Allow: |
Title | Jess’ Blog | Building BI and Fighting |
Description | Jess’ Blog Building BI and Fighting CF Home About ← Older posts SQL WHILE Loop is Slow and Takes a While (WRITELOG Wait Type) Posted on September 16, 2017 |
Keywords | N/A |
WebSite | erikhudzik.com |
Host IP | 173.236.158.206 |
Location | United States |
Site | Rank |
US$1,209,647
Last updated: 2023-05-11 18:05:31
erikhudzik.com has Semrush global rank of 8,749,912. erikhudzik.com has an estimated worth of US$ 1,209,647, based on its estimated Ads revenue. erikhudzik.com receives approximately 139,575 unique visitors each day. Its web server is located in United States, with IP address 173.236.158.206. According to SiteAdvisor, erikhudzik.com is safe to visit. |
Purchase/Sale Value | US$1,209,647 |
Daily Ads Revenue | US$1,117 |
Monthly Ads Revenue | US$33,498 |
Yearly Ads Revenue | US$401,975 |
Daily Unique Visitors | 9,305 |
Note: All traffic and earnings values are estimates. |
Host | Type | TTL | Data |
erikhudzik.com. | A | 295 | IP: 173.236.158.206 |
erikhudzik.com. | NS | 14400 | NS Record: ns2.dreamhost.com. |
erikhudzik.com. | NS | 14400 | NS Record: ns3.dreamhost.com. |
erikhudzik.com. | NS | 14400 | NS Record: ns1.dreamhost.com. |
Jess’ Blog Building BI and Fighting CF Home About ← Older posts SQL WHILE Loop is Slow and Takes a While (WRITELOG Wait Type) Posted on September 16, 2017 | Leave a comment SQL WHILE Loops can be a convenient way to add various amounts of mock data to a table for testing. But the WHILE Loop itself can also be a good way to test different functionality within SQL Server itself. When using a WHILE Loop to insert hundreds of thousands of rows, you might find it taking a lot longer than you expect; even minutes just to insert half a million narrow rows. Now of course this could be caused by any number of issues, but in this post I am going to focus on a particular cause of the WRITELOG wait type that I recently ran in to. Setup Lets start with a simple example. First create a simple example table. CREATE TABLE [dbo].[MyTable]( [Id] [int] IDENTITY(1,1) NOT NULL, [SomeText] [varchar](10) NULL, [MoreText] [varchar](50) NULL ) ON [PRIMARY] Then execute a WHILE Loop that will insert 500k |
HTTP/1.1 301 Moved Permanently Date: Tue, 09 Nov 2021 09:04:12 GMT Server: Apache Vary: Accept-Encoding,Cookie,User-Agent X-Redirect-By: WordPress Upgrade: h2 Connection: Upgrade Location: http://www.erikhudzik.com/ Cache-Control: max-age=600 Expires: Tue, 09 Nov 2021 09:14:12 GMT Content-Type: text/html; charset=UTF-8 |
Domain Name: ERIKHUDZIK.COM Registry Domain ID: 2024126639_DOMAIN_COM-VRSN Registrar WHOIS Server: whois.dreamhost.com Registrar URL: http://www.DreamHost.com Updated Date: 2021-03-25T07:51:33Z Creation Date: 2016-04-25T22:11:37Z Registry Expiry Date: 2022-04-25T22:11:37Z Registrar: DreamHost, LLC Registrar IANA ID: 431 Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited Name Server: NS1.DREAMHOST.COM Name Server: NS2.DREAMHOST.COM Name Server: NS3.DREAMHOST.COM DNSSEC: unsigned >>> Last update of whois database: 2021-11-09T08:26:20Z <<< |