UPDATE [GCDF_DB].[dbo].[People]

SET [educationtext] =

CASE [education]when 1 then 'Post Graduate'

when 2 then '4 Year Degree'

when 3 then 'Associates Degree'

when 4 then 'High School'

ELSE 'Unknown'END

So, what you are saying is you create procedures that are tested in development, and when moved into production, various issues cause them to perform poorly, or cause incorrect results,...

Thanks Michael John. So keeping in considering with license cost and performance benefit. Would below setup sounds reasonable to you?

Primary Replica - Full, Diff and Log backups & Maintenance...

Disable your anti-virus.  See what happens.

As long as you're all going for "jobs like mine" and not my job. I'm not done with it yet.

As to pay cuts. A long time ago (and let's...

I worked at a place where the slightest mistake was met with derision, shouting and a generally abusive atmosphere. On the last day of my probation period I pulled...

This is your query:

SELECT T1.JobNo, T1.ActualHrs, T1.ReworkHrs , T2.Time, T2.Rework

FROM JobSheet.dbo.JobHrs T1

INNER JOIN TimeReporting.dbo.TimeData T2 ON T1.JobNo = T2.JobNo

WHERE T1.JobNo = '19-0228B'

If you are getting no data, then check these...

On each of my servers, we have a "utilities" database that contains the various tables, procs, etc. used by the DBA.

In that database, there is a Calendar table.  There are...

Did you actually right-click on an alert,...

If the audit file is increasing in size, why is this a problem?

Regardless of what method you choose to perform audits, you will need to allocate space for it.  You...

I seem to run into issues from time to time with SQL agent and jobs.  In versions before 18, there would be errors thrown when I attempted to open Job...

Hi All,

I need to monitor a application (service user) action on SQL server DB e.g when application is querying predefined tables and columns.I do not want to user SQL...

A. Why not a trigger?  This is one of the few examples where a trigger makes sense.

B. You do not want to run a SQL job frequently.  Define frequently, and...

Yes, in the alert, response, there is a "notify operators" check box.  You will have to create an operator, and select the appropriate options for the alert.

No.  The select did not process all the rows.

The order of processing is as follows:

FROM

WHERE

GROUP BY

HAVING

SELECT

ORDER BY

LIMIT

I think you may be thinking that the select is processing first, but it's...