First question I would have is, are you having performance issues now? or is this for a baseline?

Total Server Memory is the total memory that has been allocated to...

Why do you think that SS is leaking memory? When you set Max Server Memory it only applies to the buffer pool. SQL Server can use memory in other areas...

This article should help you walk through the process: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914288

Is this for an on-going processes? Is there always two search criteria? Or does this vary?

Take a look at this article:http://support.microsoft.com/kb/75291

So if I understand it correctly you want this:

WHERE

[Serial Query].SER_OR_ADM_IND) = 'A'

AND

t1.DISCHARGE_DISP ! = 'VVX'

AND

t1.VISIT_DATE = CONVERT(varchar,GETDATE(), 101) -- See Gail's comment

AND

(t1.Diag_Code1 =...

if the string has 'Branch is in' and replace with ,

if the string has 'Branch is not in' and replace with ,

I expect...

Nice work! Please post you answer so that we can see what you did to get it to work.

Can you please supply use with the DDL for the create tables and also create insert statements for the example data you provided?

Here is one from a colleague that I haven't used before, so please test first:

http://www.robusthaven.com/products/production-management/SQL-Data-Obfuscator

One more for jumbledb http://www.orbiumsoftware.com

You are missing and END and you also have a period after count(*).CREATE TRIGGER tgr_XXXX

on dbo.XXXXX

AFTER INSERT

AS

BEGIN

SELECT COUNT(*) FROM EVENTS

IF COUNT(*)=2

RAISERROR ( 50004,16,1)

end

I'm not sure what is being asked now? There is no default password that I know of for every instance. I'm also not sure how strong the password is that...

You could run a profiler trace (server side trace) to capture Text Data that contains %xp_cmdshell% and then add the columns you want to see i.e. Host Name, Login, etc.

I would say that if you don't need to use the SA account leave it disabled. If you need it make your own password that is secure enough. The one...

rajashreesql2014 (1/13/2014)

My current output after using a full outer join is :

Year2013Year2014Branch2013Branch2014

10 0 ...