Haven't see this before. Hard to determine what 0x84C90001 concerns. The Microsoft Exchange Server Error Code Look-up (don't let the name dissuade you) reports 60 header files that define...

DECLARE @DML CHAR(6) =

CASE WHEN

EXISTS(SELECT 1 FROM inserted)

AND EXISTS(SELECT 1 FROM deleted)

THEN 'Update'

WHEN

EXISTS(SELECT 1 FROM inserted)

THEN 'Insert'

WHEN

EXISTS(SELECT...

There is no fool-proof answer that will allow you to check before you alter, if dependent objects use dynamic SQL, but outside of that problem, you can use sys.sql_expression_dependencies. Or...

That is not unusual. The different between two polls of sys.dm_os_wait_stats is likely to show SQL Server is waiting upon significant amount of wait_time_ms for PAGEIOLATCH% wait_types. Perfmon.msc's Physical Disk...

--USE DatabaseInQuestion

SELECT

'ALTER ROLE '

+ QUOTENAME(drp.[name])

+ ' ADD MEMBER '

+ QUOTENAME(dmp.[name]) COLLATE DATABASE_DEFAULT

+ ';'

FROM sys.database_role_members drm

JOIN sys.database_principals drp

ON drm.[role_principal_id] = drp.[principal_id]

JOIN sys.database_principals dmp

ON drm.[member_principal_id] = dmp.[principal_id]

;

SELECT

CASE

WHEN dperm.[state] <> 'W'

THEN...

https://msdn.microsoft.com/en-us/library/dn205318.aspx

https://msdn.microsoft.com/en-us/library/ms162843(v=sql.120).aspx

I believe you should consider rowversion. See https://msdn.microsoft.com/en-us/library/ms182776.aspx

Think about where the slow subscriber is physically located, and the available network bandwidth between the distributor and subscriber. If the weakest link in that chain is 300 bps, the...

SELECT 'select * from test_Figure1 where ' +

STUFF

(

(

SELECT ' AND ' + [column_Nme] + ' ' +

[Comparison_Operator_Code] +

' ''' + [what_Value] + ''''

FROM [test_Figure1_Expression]...

A couple of succinct (and old) MS Access articles that will help you choose a flexible normalized design:

Description of the database normalization basics

How to design a sample table to support...

Lynn Pettis (11/19/2015)

If the source data is supposed to integer data and it isn't, then I actually agree with the developers and the need to hunt down and fix the...

Consider referring to a table [OperatorPrecedence] ([Level] tinyint, [Operator] varchar) - see https://msdn.microsoft.com/en-us/library/ms190276.aspx.

And (from the same URL) consider referring to a table [NestedParenthesis]([NestingLevel] tinyint, [Parenthesis] char(1)) .

Agreed -...

When an IO failure strikes, you do not always know what garbage was written (or failed to be written) until it is read... later... perhaps much later. Not every db...

Luis Cazares (11/17/2015)Even if a strongly typed method is used, I would consider that fixing bad data should be important. Creating a list of integers and splitting it, shouldn't create...