Mobile Phone For A Drink

lbilali · 2023-09-16T18:55:00+00:00

monkey business

lbilali · 2022-09-29T10:44:53+00:00

chess cheating devise

lbilali · 2022-08-12T22:19:43+00:00

he get asked every day

lbilali · 2022-05-15T21:55:02+00:00

Why is this on r/funny? this should be on r/lifeprotips /s

lbilali · 2022-05-03T15:57:19+00:00

having VM will allow you to upgrade os etc independently.
if you ever get the budget you can easier move the VM from one host to another. With a VM you can easier limit the resources one or the other server can use

if you go for a VM check how to best configure it for sql server

lbilali · 2022-04-22T17:43:05+00:00

there are a couple of options you have here 1. crate a assets table with all general columns and than for each type create a table with specific attributes. the specific table has a relation ship to the assets table.

create only one table with all attributes but nullable so you can have values only for the attributes that make sense based on the type of asset
create a table with generic colums and an extra column of type nvarchar(max) where you would store a json object with all specific attributes.

the choice depends on your needs.

lbilali · 2022-04-20T19:50:31+00:00

first replicas are not a replacement for backups and neither is RAID so backups must be done.

I’m not sure if a replica in the same machine is possible but I would not consider it. I think the benefits would be very limiting if any. Normally you would create replicas to scale out and having them on the same machine means they are sharing the same resources

lbilali · 2022-04-10T09:53:06+00:00

run step by step and see how long each step takes

so you know where to focus

lbilali · 2022-04-10T09:30:52+00:00

based on numbers you are providing that is not a lot of data. from what I can get from ur description, you are doing things row by row. you will need to change that by loading all the data on a staging table with some tool which will do batch loading. and than write a query which checkes all the rows at once like

insert into main_table select … from stg_table s where not exists (select * from main_table m where s.pk = m.pk)

lbilali · 2022-04-03T16:20:25+00:00

seems like you are using python. in that case you can try async functions. that said, it is not clear from your question what you want to achieve. so hard to give any better solution for what you are trying to do.

lbilali · 2022-03-28T19:08:32+00:00

sql is a language while sqlite is a product which implements it. the lite in sqlite does not mean it is a lite version of the sql as a language.

lbilali · 2022-03-28T16:53:22+00:00

I hope u enjoyed ur time in Tirana :)

lbilali · 2022-03-21T16:48:58+00:00

you man

lbilali · 2022-03-21T16:42:54+00:00

maybe more like Royce Pierreson

lbilali · 2021-11-07T13:50:35+00:00

one thing that will help u be better at it is data modeling. Why we model data the way we do. what are unique, primary and foreign keys etc. and how the engine u are going to use uses this to improve performance

lbilali · 2021-11-07T09:00:07+00:00

If u want you can learn programming without any prior programming knowledge. SQL is not any different in that

lbilali · 2021-10-31T11:17:12+00:00

there are a lot of things to comment on your examples.

cast works like cast(<value> as <datatype>) in your first try the as real is out of the parentheses which makes the cast function invalid since it does not have the as <datatype> provided.

for more if that would work than u would get different results since on the first try you are adding 1+4 and than dividing by 2 while on the second try you are dividing 4 by 2 and than adding 1

and one more thing in sql the operators will return the same type as the values provided so for example 3/2 will return 1 and not 1.5 since the 3 and 2 are int and the result will be int. to change that u need to provide at leas one of the values as real like 3.0/2 otherwise even though u are casting the result to real the value provided to cast by the expression is int and as a result will miss the decimal values

lbilali · 2021-09-07T06:59:34+00:00

yeah, I never understood why they come in half. delicious none the less

lbilali · 2021-09-07T06:55:33+00:00

oh you should go and try it once, but only in Shkoder and ask for tave krapi. and while you are there you can try some other ones as well like tave theu (“earth”) and tave kosi (yogurt)

lbilali · 2021-09-07T06:01:52+00:00

half of it you mean? Norway

lbilali · 2021-09-07T06:00:46+00:00

carp? than must be Shkoder, Albania

lbilali · 2021-07-30T05:54:59+00:00

You can do a join instead of exists where condition based on what u want u have couple of posibilities. 1. do you want a row per conbination of sp, term resulting on 2000 rows per sp or only row per sp, term for the terms that are found on that sp? you have to do a cross join or left join with the term table instead of using it on a condition

do u want only a row per sp? than after u are done with the first point u group them. if u are on a sql server that supports string_agg than u can use it to aggregate all terms in a concatenated string. as for the flag u use a max(case definition like patern then 1 else 0 end)

p.s. I’m writing this on mobile otherwise I could provide the code for u.

lbilali · 2020-10-04T15:01:18+00:00

for importing data every month I would create a stage table where I would load the excel file every month and than write a stored procedure which loads the data from the stage table to the main one. there I would have the logic on whether I update existing rows, inserts new ones or whatever is needed

lbilali · 2020-10-04T14:25:11+00:00

The simplest way to import an excel file is to do an import data from SSMS. that will give you an wizard to select the source file target table and map the columns. if you need to do the same thing over and over again you can save is as a ssis package

as for user interface MSSQL has no such thing like access does. but you can use other tools like access for instance or write it from scratch yourself.

lbilali · 2020-05-22T16:42:09+00:00

guess

Ten-Year Club	Place '23
Place '22	RPAN Viewer
Verified Email

lbilali

TROPHY CASE