Bruce-12445 (10/19/2016)

---

Hi Jeff

I'm trying to add a bit more info into the audit table by adding this:

SELECT client_net_address,local_net_address,host_name,original_login_name,login_name,program_name

FROM sys.dm_exec_connections SCON

OUTER APPLY sys.dm_exec_sessions SES

WHERE SCON.session_id = @@SPID

AND ...

Aaron, I know how exactly you can make them listen.

Go to the project management. Top level.

Ask them what are the expectations of the number of customers, transactions per day, other...

aaron.reese (10/20/2016)

---

I think I will concentrate on data types and what indexes are and what they do for performance. If people want to pick my brains afterwards about the...

What happens to the historical data in the column when...

I guess, a simple INNER JOIN would be too trivial for you. 🙂

SELECT [Address_pk], [Address],

REPLACE([Address],ss.[PrimaryStreetSuffixName],ss.[PostalServiceStandardSuffixAbbreviation]) AS [AddressAbbreviated]

FROM [dbo].[Address] a

INNER JOIN [dbo].[StreetSuffix] ss on a.[Address] LIKE '% ' + ss.PrimaryStreetSuffixName...

That's...

How many columns in that denormalised table?

Why can't you use INSTEAD OF trigger?

Then you could modify rows from [inserted] the way you wish, and only after that put them into the table.

No updates, no joins, no...

You mentioned SSIS, so I assume you need to create some delimited file in the end.

If that's correct, then this should work for you:

SELECT Id, name, ColList

FROM msdb.sys.sysobjects o

CROSS...

where ID = @id

and (name = @name or (name is null and @name is null))

Just do it.

And see what it prints

Incommensurables this:

--PRINT @cmd

.NET classes are not tables.

At most, they are views.

Tables must represent entities and connections between entities.

Classes usually represent roles of entities in relation to other entities.

Say, class "Customer" represents a...

deekadelic (10/17/2016)

---

I thought of that, but when I ran the following code:

use MainReport

select object_name(m.object_id), m.*

from sys.sql_modules m

where m.definition like N'%ImportJobRevenue%'

to find all references to the proc in...

whenriksen (10/13/2016)

---

...

SELECT * FROM @T AS t

WHERE t.c IN ( 1, 2, 10 )

AND ISNUMERIC(c) =...