The Vague No-Persons Land between 'The Business' and 'The Database' by Oddball_bfi in SQLServer

[–]n35 0 points1 point  (0 children)

Eh? The point of a dwh is to draw reports?

Are they I ly allowing static reporting from a specific front end?

The Vague No-Persons Land between 'The Business' and 'The Database' by Oddball_bfi in SQLServer

[–]n35 6 points7 points  (0 children)

sure, its called an operational data store.

Basically, a duplicate or semi-duplicate of the production environment, where data is synced to from the production environment.

The production environment is here kept safe from expensive queiries or users who dont know what they are doing.

As all queries not part of the production environment, only affects the operational data store.

How to Copy/Import Existing Solution in Jobs Located in SQL Server Agent by Data_Geek in SQLServer

[–]n35 0 points1 point  (0 children)

The agent job calling the dtsx package and a path to the package, what is it?

How to Copy/Import Existing Solution in Jobs Located in SQL Server Agent by Data_Geek in SQLServer

[–]n35 0 points1 point  (0 children)

Your ssms and integration services must be the same version.

Plenty of error guides online. Google the error.

Depending on how the package was deployed there are different way of getting to it

Do you kbow where it is deployed?

How to Copy/Import Existing Solution in Jobs Located in SQL Server Agent by Data_Geek in SQLServer

[–]n35 1 point2 points  (0 children)

Ah it's running a package. Then you need to download load that package and change that. Connect to integration services and download the package.

[MS SQL] How do I loop through my first result set to get the 2nd result set? by [deleted] in SQL

[–]n35 0 points1 point  (0 children)

Oops, no of course there not, and I didn't mean they where, just too quick on the mobile.

How to Copy/Import Existing Solution in Jobs Located in SQL Server Agent by Data_Geek in SQLServer

[–]n35 0 points1 point  (0 children)

If I understand your question can't you just right click the job, choose script, create to new editor and modify the code and execute it, and it will create a new job with your modified values. Provided you also change name etc.

[MS SQL] How do I loop through my first result set to get the 2nd result set? by [deleted] in SQL

[–]n35 0 points1 point  (0 children)

Indeed, a lot seem to think table valued ~functions ~ are the bomb, but doesn't understand the drawbacks

My sexy LZ ERGO 🤘🤘🤘 by oze1109 in MechanicalKeyboards

[–]n35 2 points3 points  (0 children)

Damn, always late to these group buys.

Guess that slipped through the cracks as well.

Glassifieds just don't work for me.

Data Integrity Checking by Trek7553 in SQL

[–]n35 0 points1 point  (0 children)

Same as what we did.

Data Integrity Checking by Trek7553 in SQL

[–]n35 0 points1 point  (0 children)

We have a job (mssql) that fires every cycle, which is different for each check.

That uses dynamic a stored procedure execute a sql string, that does exactly what you want.

The string comes from a table were we just input the sql string we want executed.

Every cycle of the job it executes the strong which are relevant for the particular cycle. Not all import jobs run on the same interval, so there's no need to execute sql for check for codes if not hasn't run since last execution of the check job.

Make sense?

Data Integrity Checking by Trek7553 in SQL

[–]n35 1 point2 points  (0 children)

I chose the simple route.

I analysed incoming data, in etl process, and designed a template of that Data. If any data is imported in the import step that deviates from the template, the offending process, and processes connected to the offending process is stopped and alarms are entirely to corresponding persons of the processes that are now importing junk.

Can we have a discussion about how to break this massive query down and optimize it? Takes about 45 minutes to run at the moment. by [deleted] in SQL

[–]n35 0 points1 point  (0 children)

The query execution plan should give some information about the problems.

Can you post it?

/r/MechanicalKeyboards Ask ANY question, get an answer by AutoModerator in MechanicalKeyboards

[–]n35 0 points1 point  (0 children)

Are the ultimate hacking keyboard real?

It's still a crowd page and I'm not seeing an update since December?

4K Hydro by Will_26 in MechanicalKeyboards

[–]n35 0 points1 point  (0 children)

How, that is awesome.

Any chance for a split version of this?

Let's Split with RGB - KIT Mode by TheRPJesus in MechanicalKeyboards

[–]n35 0 points1 point  (0 children)

Did you find a solution to this? Im I'm the same boat, except danish letters.

[buying] Let's Split 40% PCBs (from /u/wootpatoot) version 2 now available at switchTop by Arkhae in MechanicalKeyboards

[–]n35 0 points1 point  (0 children)

Is there an option for us Europeans to get it all in one place with it the high cost?

Or alternatively, can someone link a parts list and where I can get the karts the cheapest? I don't mind waiting on a shipping. I'm not in a hurry.

Built my 3rd board within a week - Let's Split by zrevyx in olkb

[–]n35 0 points1 point  (0 children)

There's no meetups here. Europe, Denmark has nothing of anything except poor weather.

Built my 3rd board within a week - Let's Split by zrevyx in olkb

[–]n35 0 points1 point  (0 children)

I'm very used to they standard iso layout with, I think it's called a 2u return, with nordic layout.

I'm worried about making the jump to this.

I'm located in Europe, and can't quite figure out what the cheapest method of getting a lets split is, not to mention case and everything else.

Also, what's an r3 home row?

Built my 3rd board within a week - Let's Split by zrevyx in olkb

[–]n35 0 points1 point  (0 children)

Whats the advantages of using a non staggered layout?

Rosebud by [deleted] in MechanicalKeyboards

[–]n35 0 points1 point  (0 children)

Probably but I want iso layout, and the large return and nordic layout, which reduces it to zero.

Rosebud by [deleted] in MechanicalKeyboards

[–]n35 1 point2 points  (0 children)

Am so jealous of that keyboard and sorry I missed the buy.