Quick thought, have a look at Operations That Can Be Minimally Logged for the copy operation.

😎

Thanks Andy for the nice read, certainly a point worth highlighting!

Guess you missed the most dangerous type of threat which are the Administration Lawyers, they have already claimed few victims.

😎

Mast

Quick suggestion, have a look at Jeff Moden's Hierarchies on Steroids #1[/url] and Hierarchies on Steroids #2[/url] articles.

😎

Catamaran

Quick question, have you granted the appropriate permissions to the Service Broker, see GRANT Service Broker Permissions (Transact-SQL) ?

😎

hbk_sql (4/4/2015)

---

Hi,

We have a SSIS package to deploy script (install SP’s) to SQL database and apply permissions to users on newly created SP’s. Basically SSIS package first moves the script...

Quick suggestion, use a template Excel spreadsheet...

Michael Gerholdt (4/3/2015)

---

How do I tell SQL Server what key to use for DES3 decryption? I want to encrypt in Oracle and after ETL to SQL Server, be able to...

coool_sweet (4/4/2015)

---

i have 1 variable whch is integer.

i am using row count transformation and adding values to this variable.

now i want this variable to char(8) instead of int.

how to do...

David Burrows (4/4/2015)

---

Did know someone whose workplace had a life size cardboard cut out of a person called Maud (name not...

Tac11 (4/4/2015)

---

my experience is, I tried to do 'page compression' on a table to gain some 'free space' on the databases level. But when I did it, i got more...

Quick note, use the sys.dm_db_persisted_sku_features to identify Enterprise features in use

😎

SELECT

PSF.feature_name

,PSF.feature_id

FROM sys.dm_db_persisted_sku_features PSF;

Jeff Moden (4/1/2015)

---

tomy200501 (4/1/2015)

---

Hello All,

I am trying to set "Is Identity property" To Yes on a column that has uniqueidentifier as a type and has a primary key constraint on...

You are missing the hash(#) prefix for the #busdetails in the from clause

😎

SELECT @Query = 'SELECT m.bus_id as ID ' + CHAR(13)

+ (SELECT...