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...

ismahmoud (10/13/2016)

---

i'm using this script :

select * into LinkedServer.[DB_Name].[dbo].[Table_Name] FROM Server2.[DB2_Name].[dbo].Table2_Name

but give this error:

Msg 117, Level 15, State 1, Line 1

The object name 'LinkerserverName.DB_Name.dbo.Table_Name' contains more than the maximum number...

mcfarlandparkway (10/10/2016)

---

I have two tables one is temporary and another is main dbo employee

In the main table I have added a column called fullamount. Basically this fullamount column is coming...

ok bulk has to references files ON THE SERVER or a fully qualified UNC path

so unless the SQL server is on your local machine, you need to move the...