Firstly Task Manager is a really bad tool for checking server memory.

Second, you say 'its using 91% of the memory'. What is 'it'? Do you see SQLServr.exe with 91% next...

NO!

Don't touch the resource DB. You don't need to, there are no user-defined objects in there, and you could easily toast the SQL instance. Leave the resource DB alone.

If Lowell's...

Hang on...

You repeatedly mention Always On cluster, and then ask about SYNCHRONIZING. Which do you have, Always On Failover Cluster or Always On Availability Groups?

sys.sql_modules

Don't try to modify a system object (sys.server_triggers), just query the tables directly (and you don't need that conversion function, so omit the lines that use it). sysschobjs is probably...

You'll probably need to read the underlying system tables from the master DB restore, rather than the view which (since it isn't in master at all) is probably referencing the...

Partially full pages, as a fragmented index will have more free space on pages than it needs (due to the page splits that caused the fragmentation. Hence reading more pages...

Logon triggers will be in a backup of master, not of user databases (they're server objects)

3rd of April, of course.

But yes, dates in datetime, datetime2 or one of SQL's other datetime data types and format for presentation. Makes date comparisons and ordering much easier (unless...

Luis Cazares (6/7/2016)

That's why...

What have you got so far and where are you stuck?

You don't need a cursor or a function to do that.

CREATE PROCEDURE work.uspProcessName

AS

SET NOCOUNT ON

BEGIN

WITH SourceData AS (

SELECT DISTINCT ID,FirstName,LastName

FROM dbo.Names

)

INSERT INTO dbo.Name (ID,FirstName,LastName)

SELECT ID,

CASE WHEN CHARINDEX('FirstName',FirstName,1) >...

To be honest, I would recommend a different approach.

You've got a function that returns one row, and a stored procedure that loops over all the rows in the table one...

afaIK, there isn't a separate dev/dba track. Last time I looked at the certs, the split (which is at the MCSE level) is DB engine vs BI

TempDB is used for temp tbles, table variables, sort and hash spills, spools, version store and a few other things. If your queries aren't using temp tables theyn thyey may...