Viewing 15 posts - 5,791 through 5,805 (of 8,761 total)
Quick thought, have a look at Operations That Can Be Minimally Logged for the copy operation.
😎
April 4, 2015 at 11:49 am
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.
😎
April 4, 2015 at 11:44 am
Revenant (4/4/2015)
Eirikur Eiriksson (4/4/2015)
TomThomson (4/4/2015)
crookj (4/3/2015)
djj (4/3/2015)
HouseCards
pontoon
Catamaran
Sail
Mast
April 4, 2015 at 11:34 am
Quick suggestion, have a look at Jeff Moden's Hierarchies on Steroids #1[/url] and Hierarchies on Steroids #2[/url] articles.
😎
April 4, 2015 at 11:30 am
TomThomson (4/4/2015)
crookj (4/3/2015)
djj (4/3/2015)
HouseCards
pontoon
Catamaran
April 4, 2015 at 10:55 am
Quick question, have you granted the appropriate permissions to the Service Broker, see GRANT Service Broker Permissions (Transact-SQL) ?
😎
April 4, 2015 at 10:52 am
hbk_sql (4/4/2015)
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...
April 4, 2015 at 10:44 am
coool_sweet (4/4/2015)
hieven if i calculate in my sql script it will come as a column
i need last row only sum in my excel sheet
Quick suggestion, use a template Excel spreadsheet...
April 4, 2015 at 10:36 am
Michael Gerholdt (4/3/2015)
April 4, 2015 at 10:32 am
coool_sweet (4/4/2015)
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...
April 4, 2015 at 7:20 am
David Burrows (4/4/2015)
SqlSanctum (4/3/2015)
Sounds like you need to invest in a duck
Did know someone whose workplace had a life size cardboard cut out of a person called Maud (name not...
April 4, 2015 at 6:40 am
Tac11 (4/4/2015)
April 4, 2015 at 6:36 am
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;
April 4, 2015 at 6:30 am
Jeff Moden (4/1/2015)
tomy200501 (4/1/2015)
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...
April 4, 2015 at 4:17 am
You are missing the hash(#) prefix for the #busdetails in the from clause
😎
SELECT @Query = 'SELECT m.bus_id as ID ' + CHAR(13)
+ (SELECT...
April 4, 2015 at 4:05 am
Viewing 15 posts - 5,791 through 5,805 (of 8,761 total)