also in my experience, every trigger,package,procedure and function in oracle will have to be rewritten, even when they is doing the most trivial CRUD operations, and especially because the...

Eric thanks for prompting me to investigate Server Roles deeper.

this is the role i came up with, that grants select on any user objects as well as the view server...

interestingproblem;

here's how i think i would tackle it;

substitute [ClarkKent] for your [domain\ADGroup]

Create LOGIN [ClarkKent] WITH PASSWORD='NotTheRealPassword'

--see anything in the DMV's

GRANT VIEW SERVER STATE TO [ClarkKent];

--allow to see object definitions, tables...

wouldn't creating a dacpac be an option? i

m not sure if they are SQL Server version agnostic or not, but the dacpac has the object schemas, ; i though...

aliases are your friend, especially with a delete construct like this;

here's an example:

; with cte

AS

(

select * FROM employee

)

delete myTarget

from #temp myTarget

inner join cte MySource ON myTarget.id = MySource.id

this is the kind of annoying projects that make you reach for your nearest programming language;

SSIS is handicapped when it comes to data lengths being dynamic.

I've got an Generic CSV...

sp_help_revlogins will do that for you;

it produces results like this, because it uses a bin to hex function:

-- Login: ClarkKent

IF NOT EXISTS ( SELECT * FROM sys.server_principals WHERE name =...

i've seen things like this, where backups are scheduled at 4am, and then so is an reindexing job AND a statistics job.

all at 4am. once all the sorting in tempdb...

But thats easily fixed with smart code

If exists... and @@SERVERNAME='Production' And db_name='ProdDB'

So i would argue it all belongs in a single procedure.

like Sue_H, i would have the procedure send the email. if you are reusing the procedure elsewhere, add an optiona parameter with a default, like @sendEmailNotification int=0

it looks like...

Texas A&M University offers A bulk cleansing service you could try.

you upload a txt or csv and get back results;

you have to register/create an account, but I believe it's free.

https://geoservices.tamu.edu/Services/AddressNormalization/

i just recently did the opposite of what the OP is looking to do: i expanded all abbreviations to full words;

mine was an investigation to eliminate variations in abbreviations and...

Jeff Moden (10/18/2016)

---

Create a stored procedure to return what they want. Give them privs to run the stored procedure and have the stored procedure execute as owner. That...

Is it truely an archive database, so you can just toggle it to read only mode, or is it somewhere in between?

You could add a file group, and move...

chocthree (10/16/2016)

---

Hi all,

A newbie here wishing to ask for advice on Microsoft Business Intelligence. Hoping this is the right forum to put my questions.

I would like to learn Business Intelligence...