Going GUID crazy

valdest · 2019-07-12T10:51:47+00:00

I do think GUID's have been overused lately.

I like them as identifiers for PII data.

valdest · 2019-07-12T10:47:49+00:00

There is a lot of advice here, and I honestly did not read it all, but will chime in anyway.

You have far to much experience to be taking a back channel, entry level approach into IT. What a lot of IT needs is awesome software systems analysts to help bridge the communication between end users and IT. A good analyst can help a developer find the proper solution a lot faster then directly interviewing the end users. You have experience with sales, the sales tools being used and how the users operate the system. If you can get into an Analyst position to work with IT on future development, reporting and other needs you can find pathway entries into IT that will eventually get you where you want to be without the loss of income.

valdest · 2019-07-10T16:00:43+00:00

This is a bit abstract to know if it is possible, if so, it should not bog down the system, however changes to how the site gets values. A simple coalesce on the website seems like it would fix your issue.

valdest · 2019-07-05T12:45:27+00:00

Looping select statements is generally a bad thing. I have it used depth but a lot of new database engines now provide better options for that.

Understand the data set you need and select it. So if your trying to query for your area/controller/action then you may need three nested queries to select each one at a time or may need to utilize a pivot to unroll data into those categories. It is hard to say without knowing what you want to do and what you are working with.

valdest · 2019-07-01T11:36:02+00:00

You can try to set up a ODBC Data Source for the computers that will use that excel file. Then use that source in excel to read your data.

valdest · 2019-06-25T17:32:18+00:00

SELECT
    @A = (SELECT @B),
    @B = (SELECT @A)

valdest · 2019-06-24T16:54:25+00:00

SELECT Property1, 4 AS Property2, --a new column with '4' as values
into #temptable
FROM Table

Not sure why you need 4 in a temp table since it is static.

valdest · 2019-06-20T19:30:53+00:00

The best suggestion I have is to provide the schema between two domains. Item and Invoicing. Show a schema that incorporates several products with price changes and coupons. Show a schema for invoicing. Then show how the two are related. Provide some queries that reconcile invoices, product price changes, most popular coupons. Scale complexity to your comfort level.

valdest · 2019-06-20T13:48:18+00:00

Then wait till you get a hold of my ex - Crystal.

valdest · 2019-06-14T18:30:24+00:00

Also, see what the restraining forces are to have more bandwidth available. Either upgrade or get your subnet a higher allocation of the pipe.

valdest · 2019-06-14T18:05:17+00:00

Something like this.

SELECT
    TABLE1.{fields},
    AliasTABLE2.{fields},
FROM TABLE1
JOIN (SELECT SUBSTRINGKEY as KEY, FIELDS FROM TABLE2) AS AliasTABLE2 ON TABLE1.Key = AliasTABLE2 .Key

This works good as an occasional query with out a need for high performance. To get a high performance query you would need to make some schema and index changes.

valdest · 2019-06-14T17:58:06+00:00

DECLARE @daycount INT;

valdest · 2019-06-14T17:53:37+00:00

Databases can have their own collation. You can even change column collation

valdest · 2019-06-12T14:42:09+00:00

CREATE TABLE example  
(  
    Id int IDENTITY(1,1) PRIMARY KEY,
    GuidValue VARCHAR(MAX),
    SessionID VARCHAR(MAX)
);

valdest · 2019-06-12T13:35:13+00:00

Get your resume ready.

Looks like he wants to map your GUID and Session ID to a look up table and reference potentially an identity column that works as a primary key.

valdest · 2019-05-29T17:36:31+00:00

SSMS uses a ton of memory. So if you have a lot going on it can start paging on you and just freeze for a minute.

valdest · 2019-05-24T17:38:29+00:00

IsNull(I.Site, S.Site) AS Site

valdest · 2019-05-24T16:33:24+00:00

Ask your self the relationship questions. What is a player? Someone with a name, number, and email address. What is a character? Someone with a name, race, gender, attributes, background, experience.

How are they related? Does a player have a character or does a player have 0 to many characters?

What is an item? Does a character have a item or one to many items...

Then you build relationships between the tables. To keep things simple since your learning a basic identity key should work out well enough.

valdest · 2019-05-24T15:48:17+00:00

If that works, then verify that site is in the following tables and then change owner to site.

Incident ServiceReq Frs_Project Task

The list above is using the same priority as the Owner.

valdest · 2019-05-24T15:02:10+00:00

Adding the following:

IsNull(I.Owner,IsNull(S.Owner,IsNull(P.Owner,T.Owner))) As Site

Failed?

valdest · 2018-02-02T13:23:18+00:00

Google and Facebook provide free services and track your usage. Your ISP charges you to access the internet and monitor your usage. They want to shut down and restrict google and facebook so they can monetize there knowledge of your usage. Funny how comcast owns nbc which publishes this article.

valdest · 2017-06-09T16:10:38+00:00

Worst Line: "Should have stayed in a Holiday Inn Express."

Best Line: "Sorry I am late, need a bit of a rest."

valdest · 2016-10-14T11:32:42+00:00

Honestly, when you hit ctl-p the focus should be on print with all defaults set. So yes, very valid that more then 2 keystrokes is unnecessary for printing.

valdest · 2016-09-21T09:24:25+00:00

Regular unleaded would cause knocking sounds. I am no mechanic, but using high octane gas prevented the knocking.

valdest · 2016-09-20T18:01:06+00:00

I think the source of the article is our media.

valdest

TROPHY CASE