Viewing 15 posts - 4,156 through 4,170 (of 6,026 total)
Rick Todd (2/10/2015)
February 10, 2015 at 3:26 pm
jarick 15608 (2/10/2015)
February 10, 2015 at 2:35 pm
You can attempt the following, but I doubt it would work, even if the target were another SQL Server instance.
INSERT INTO MYSQL..OC_Abiertas
( DocNum, DocEntry, DocDate, CardCode, CardName, SubTotal, DiscPrcnt
,...
February 10, 2015 at 2:18 pm
I've found that building up a list of keys shared across multiple tables into a temp table using EXCEPT keyword is very efficient. Deleting or updating against an inner join...
February 10, 2015 at 2:06 pm
Reply back with the actual OpenQuery statement.
February 10, 2015 at 1:40 pm
Robert.Sterbal (2/10/2015)
Our main purpose for something like this is to do a database restore. Which method of killing processes do you prefer to do that?
ALTER DATABASE <database> SET RESTRICTED_USER WITH...
February 10, 2015 at 8:27 am
bdcoder (1/31/2015)
Ha! - store *every* column as VARBINARY(max) and never worry about data types again!
You may laugh, but actually SQL Server's symmetric key encryption requires that any encrypted columns...
February 10, 2015 at 8:20 am
The script can be handy as a starting point, if you want to kill multiple connections for a specific application or user. You must be careful to filter on Login...
February 10, 2015 at 7:43 am
Jeff Moden (2/9/2015)
Eric M Russell (2/9/2015)
axc_67 (2/9/2015)
I am just pulling a simple data extraction from remote server with where conditions....which...
February 9, 2015 at 1:02 pm
axc_67 (2/9/2015)
I am just pulling a simple data extraction from remote server with where conditions....which is why I don't understand...
February 9, 2015 at 11:21 am
axc_67 (2/9/2015)
Your solution seem to work faster:
Exec ('Select ...) at linked Server
It took about 14mins...which is still longer than access but atleast it takes half the time of OpenQuery.
Thank...
February 9, 2015 at 11:11 am
Gary Varga (2/9/2015)
February 9, 2015 at 10:54 am
Experimenting with a different provider or linked server property configuration may offer marginal performace gains. But when it comes to performance of remote queries, what's most important is that the...
February 9, 2015 at 9:59 am
It's easy to walk away from a job when you're young, your coworkers are difficult, and the pay is low. In that situation there is no internal conflict and debate,...
February 9, 2015 at 8:26 am
Gary Varga (2/6/2015)
Eric M Russell (1/12/2015)
February 6, 2015 at 9:48 am
Viewing 15 posts - 4,156 through 4,170 (of 6,026 total)