The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog


Home	No Ads ever, except search!

Saturday, June 12, 2021

Recent Posts

EJ Horkay Class of 2021

5/22/2021 5:27:24 AM

Graduation May 13, 2021

Unable to drop Statistics

3/26/2021 10:00:29 AM

Recently ran into an issue where we were unable to drop a column statistic.

We were trying to modify a column and received the following error.

ALTER TABLE [schema].[table] ALTER COLUMN [column1] VARCHAR(MAX)

Msg 5074, Level 16, State 1, Line 1

The statistics 'Stat_52ead462d2bc49009bded731bf1417a8' is dependent on column 'column1'.

ALTER TABLE ALTER COLUMN column1 failed because one or more objects access this column.

Operation cancelled by user.

Notice the odd name of stat_{guid}, this is usually when sql server is auto generating a system name.

Searched for that statistic name and could not find it.

select *

from sys.stats so

where so.name = 'Stat_6c8147e7477849589b585591f65b5843'

I ended up guessing that i needed to drop the statistic on the column, so ran this query to find the statistic on that column and then manually dropped the statistic.

select s.name as statistics_name

,c.name as column_name

, sc.stats_column_id

from sys.stats as s

inner join sys.stats_columns as sc

on s.object_id = sc.object_id and s.stats_id = sc.stats_id

inner join sys.columns as c

on sc.object_id = c.object_id and c.column_id = sc.column_id

where s.object_id = object_id('stg.td_click')

From Here i dropped that statistic and then was able to proceed, notice it is not named like the error, but it worked and allowed me to then alter the column.

drop statistics stg.td_click._WA_Sys_00000010_29D8AC17

Found one similar issue.

https://dba.stackexchange.com/questions/269233/alter-column-fails-due-to-hidden-statistic

Alter column fails due to "hidden" statistic

I'm trying to change a column data type from datetime2 to datetimeoffset. I have db owner permissions. Whenever I run the query: alter table dbo. alter column [TimeStamp] datetime...

dba.stackexchange.com

Monitoring read-only PAAS SQL node

2/7/2021 7:39:34 PM

If you connect to your Business Critical Azure SQL instance with ADS or SMSS and in the Additional Connection Parameters you specify ApplicationIntent=ReadOnly, you are then connected via your admin account to that read only replica and can do some performance monitoring via database scoped DMVs:

Monitoring and troubleshooting read-only replicas

When connected to a read-only replica, Dynamic Management Views (DMVs) reflect the state of the replica, and can be queried for monitoring and troubleshooting purposes. The database engine provides multiple views to expose a wide variety of monitoring data.

Commonly used views are:

MONITORING AND TROUBLESHOOTING READ-ONLY REPLICAS
Name	Purpose
sys.dm_db_resource_stats	Provides resource utilization metrics for the last hour, including CPU, data IO, and log write utilization relative to service objective limits.
sys.dm_os_wait_stats	Provides aggregate wait statistics for the database engine instance.
sys.dm_database_replica_states	Provides replica health state and synchronization statistics. Redo queue size and redo rate serve as indicators of data latency on the read-only replica.
sys.dm_os_performance_counters	Provides database engine performance counters.
sys.dm_exec_query_stats	Provides per-query execution statistics such as number of executions, CPU time used, etc.
sys.dm_exec_query_plan()	Provides cached query plans.
sys.dm_exec_sql_text()	Provides query text for a cached query plan.
sys.dm_exec_query_profiles	Provides real time query progress while queries are in execution.
sys.dm_exec_query_plan_stats()	Provides the last known actual execution plan including runtime statistics for a query.
sys.dm_io_virtual_file_stats()	Provides storage IOPS, throughput, and latency statistics for all database files.

You can also set up xevent sessions : Read queries on replicas - Azure SQL Database | Microsoft Docs

SSRS Missing URL parameter IterationId

2/5/2021 1:00:35 PM

SQL Server Reporting Services SSRS Error, Missing URL parameter: IterationId.

Missing URL parameter: IterationId

I began receiving this error when i imported and tried to modify a report from SQL Server performance Dashboard that i was trying to make work with Azure PAAS SQL. I found this was not an uncommon issue.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b44a0452-d71a-4e69-b7e0-af74b9f6bde7/missing-url-parameter-iterationid

I deleted the Line from the report and problem was fixed.

I was getting this error message myself, and it was due to the Line control. For whatever reason, the Line control tries to include a standard blank image right after it, but the URL is missing that parameter in FireFox and Chrome (but not IE, as far as I can tell). When I remove all the Line controls, the error goes away. Make sure you don't have any Lines in your footer (or anywhere else on your report, for that matter.)

Home Butchering Dexter Beef

1/31/2021 12:51:27 PM

Only hung the beef for 7 days, for Dexter beef it doesn't seem too make a difference, and especially considering I'm working in a "less controlled" environment ( Like an out-building / garage), it's best too not hang long.

Meat cutting saw review.

The meat saw performed well, Sold under various names "Stark Meat cutting band saw", "grizzly saw", "XtremepowerUS 2-in-1 Professional meat saw", from various big box retailers, Walmart, Northern Tools, Lowes, even Amazon. Definitely recommend you have a bigger saw for a cow bigger than a Dexter. This saw was barely big enough at 10" for the shoulder chuck roasts, and the rear round steaks. Recognize the saw for what it is, a small, easily to store, meat saw, don't push it hard and watch what your doing and it will work fine.

Cleanup of any meat saw is tedious, I found it easiest to remove the motor / electronics and hook up a hose to the hot water heater, scrub it with bleach, dish soap too cut the grease, dry it, rub it down with an little vegetable oil, dry it again leaving a little film of oil, put the thing away until the next cow. I did not even try to use the grinder, as fortunately my Dad bought me a huge commercial grinder, thanks Pop !

Retrieved most cuts of beef successfully. and wrapped.

Butcher Shop - Step 1

1/25/2021 2:21:05 PM

Raising Dexter Beef from start to finish.

Take care of Animal and Step 1 is on-the Farm kill.

Quartered and hung in the garage.

Trees 2021

1/21/2021 11:33:07 AM

Qty	Item #	Description
1		Autumn Frost Hybrid Squash - 20 seeds Fruits store up to 4 months! Ribbed, rounded, 5 to 7 inch fruits average 4 pounds each and ripen to dark tan with a frosty overlay. Inside they have golden orange, high quality flesh that tastes like butternet squash, but richer. Medium length vines have intermediate resistance to powdery mildew allowing for exceptional yields of the 5 to 7 rounded fruits. Ideal for roasting in halves, or cut the top 2 inches off and bake it whole. It's perfect for stuffing!
2		Berry Poppins Winterberry Holly Feed the birds with these super colorful berries! Ideal for adding a bit of cheer to a blustery landscape. Much smaller than the native species, these compact versions grow only 3 to 4 feet tall. Easy care plants hardly ever require pruning. This heavy-fruiting female requires a pollinator, such as Mr. Poppins®.
1		Blush Hybrid Onion - 50-75 plants A pink onion that resulted from a cross between yellow and red varieties. The pretty bulbs average 3 to 4 inches in diameter with a quick drying, tight skin. Inside you'll find delicate, purple-pink rings that have a sweet, yet pungent taste. Stores well up to 6 months. A widely adaptable, long-day type perfect for norther locations.
1		Duchess Of Oldenburg Standard Apple Brought to this country over 150 years ago from Russia, Duchess is extremely hardy and has resistance to Apple Scab, Cedar-Apple Rust and Fire Blight. Fruit is medium size with skin color pale yellow with crimson stripes and splashes. Flavor is sprightly tart, superb for pies and sauce. Ripens mid-August to early September.
1		Karl's Favorite Dwarf Pear Big fruits, some over one pound each! This excellent quality pear originated near Akron, Ohio in 1928. Yellow fruits have slightly russeted skin and are quite large. Flesh is fine-grained, melting and juicy, superb for fresh eating and canning. The hardy, vigorous trees are very productive, bear annually and have moderate resistance to fire blight. Fruit ripens in September.
1		Meader American Persimmon An American persimmon selected by Professor Elwyn Meader in New Hampshire. The delicious orange fruits are extremely sweet with a tomato-like texture when ripe. A frost enhances their flavor. Unripe fruits can be frozen or dried. Use them in puddings, cakes and cookies, as desserts or toppings, or dry them for a date-like flavor. Fruit ripens in late September. The tree is ornamental with lustrous, dark green leaves turning crimson in the fall. Grows up to 30 feet tall, but it can easily be kept smaller. A self-fertile variety, and if it is not pollinated by other persimmons the fruit is usually seedless.
1		Mountain Ash Offer Rabina Shipova Rabina A unique true mountain ash found growing in the wild in Russia. Unlike other mountain ash, Rabina has remarkably good tasting fruit with a sweet-tart, non-bitter flavor. High in vitamins A and C, the abundant bright orange berries are good for fresh eating, juice, preserves, pastry and wine. The small ornamental trees grow up to 20 feet tall and have attractive pinnate foliage that turns orange-red in fall. Shipova Large delectable fruits! This unique hybrid of mountain ash and pear originated in Yugoslavia. Attractive trees produce round, yellow-orange fruits the size of large apricots. The mouth-watering, seedless fruits are aromatic with a slight rose-like scent. The 15 to 20 foot trees have attractive dark, silver-grey foliage and a nice pyramidal shape. Hardy and scab resistant. Partially self-fertile, but planting two Mountain Ash varieties will produce more fruit. 3 to 5 ft. bareroot trees
1		Mr. Poppins Winterberry Holly A male plant that does not set fruit, but can provide pollen for up to 5 plants of Berry Poppins. Plant within 50 feet of female plants.
1		Nikitas Gift Hybrid Persimmon A special self-fertile persimmon from the Ukraine. Introduced by the Nikita Botanic Garden in Ualta, Ukraine, this unique cross of Asian and American persimmons bear abundant crops of 2 1/2 inch diameter, reddish- orange, delectable sweet fruits that ripen mid to late October and stay on the tree until frost. Fruits must be allowed to soften before eating. The naturally dwarf tree has beautiful orange-yellow fall color.
2		Pilgrim Cranberry You don't need a bog to grow American cranberries. A sunny, well-drained bed with acidic soil and good moisture content will do. These versatile, nutritious fruits are lovely ornamental, fruiting ground covers. Only 6 inches tall, they have dainty evergreen foliage and small pink flowers in spring followed by abundant crops of large, tasty red berries that ripen in fall. Pilgrim is self-fertile and hardy to -30 degrees F. Plants begin bearing 1 to 2 years after planting.
2		Redlove Odysso Red Fleshed Apple Unique dark pink to red fleshed fruit with a phenomenal taste. The bright redd fruits resemble a normal apple from the outside, but that's where the similarities stop. The firm, red flesh is crisp and refreshingly sweet, with a hint of berries that fully develops after 3 to 4 weeks in storage. Vigorous trees grow 6 to 10 feet tall and bear delightful pink flowers in spring, Fruits are ready to harvest in early October and store well for several months. Resistant to scab. Not self-fertile, so plant with another apple or crab apple.
1		Russian Quince Our Russian quince are unique for their tender and mild flavored fruit which can be eaten right from the tree. The ornamental trees display beautiful, cup-shaped, white flowers in late spring followed by large, waxy yellow, highly fragrant, round to pear-shaped fruits in early fall. Flavor is described as lemony or pineapple. Pick in October and allow to soften. High in Vitamin C and pectin, they are used for jams, jellies, baked goods, flavoring and for canning. Small, well-behaved, disease-resistant trees grow 10 to 15 feet tall. Budded on quince rootstock.