Hermetic

You are very welcome.

😎

The image posted does not help much, the only thing one can suggest from this is to add covering indexes to the...

Quick question, can you post the DDL (create table), sample data as an insert statement and the desired output?

😎

My 2 Cents, when working with large and often complex schema, cluttering a detail level ERD into a single diagram does neither make sense nor serve any purpose (apart from...

Have a look at Aaron Bertrand's article Script to create dynamic PIVOT queries in SQL Server[/url]

😎

Quick example

😎

USE tempdb;

GO

SET NOCOUNT ON;

/* XML snip to update, note added a ROOT element */

DECLARE @TXML XML = '<ROOT>

<Name>Assets - Reconciler</Name>

<UpdatedOn>2015-05-20T13:23:09.230</UpdatedOn>

<CreatedOn>2015-05-20T13:22:04.920</CreatedOn>

<UpdatedBy>RLG\JoeBloggs</UpdatedBy>

<CreatedBy>RLG\JoeBloggs</CreatedBy>

<InputDirectory>\\99.999.999.9\Active</InputDirectory>

<OutputDirectory>\\99.999.999.9\Archive</OutputDirectory>

<ErrorDirectory>\\99.999.999.9\Errors</ErrorDirectory>

<LoadId>0</LoadId>

<Type>ExcelFile</Type>

</ROOT>';

DECLARE @NEW_IP VARCHAR(15) = '123.456.789.012';

DECLARE @SAMPLE_TABLE TABLE

(

...

Quick thought, with the negative top directive the estimated execution plan is the same as the input plan (only translation) without any optimization. Change the top directive to n>0 and...

Joshua D Gang (9/10/2015)

---

I have a single 2008R2 windows server with 9 SQL 2008R2 standard instances install. This server is also setup as a three node failover cluster. Two SQL...

drew.allen (9/10/2015)

---

Eirikur Eiriksson (9/10/2015)

---

Quick suggestion (you are almost there)

😎

IF NOT EXISTS (

SELECT SP.Name, SPM.permission_name from sys.server_principals SP

INNER JOIN sys.server_permissions SPM ON SP.principal_id = SPM.grantee_principal_id

WHERE

(SP.name = 'SomeRole' AND SPM.permission_name = 'VIEW...

Quick suggestion (you are almost there)

😎

IF NOT EXISTS (

SELECT SP.Name, SPM.permission_name from sys.server_principals SP

INNER JOIN sys.server_permissions SPM ON SP.principal_id = SPM.grantee_principal_id

WHERE

(SP.name = 'SomeRole' AND SPM.permission_name = 'VIEW ANY DEFINITION')

AND --OR

(SP.name...

Warranty

Quick suggestion, use the Parameters (OleDbParameterCollection) collection which is a member of the OleDbCommand Class.

😎

Barkstuff (9/9/2015)

---

Hi, please only answer if you actually know the answer.

Is it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?

Thanks...

SQL-DBA-01 (9/9/2015)

---

Hello Experts,

Many a times see the below error in SQL Error log.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check...