Viewing 15 posts - 4,171 through 4,185 (of 6,041 total)
Rick Todd (2/10/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 10, 2015 at 3:26 pm
jarick 15608 (2/10/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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
,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 10, 2015 at 2:06 pm
Reply back with the actual OpenQuery statement.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 9, 2015 at 11:11 am
Gary Varga (2/9/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
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,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 9, 2015 at 8:26 am
Gary Varga (2/6/2015)
Eric M Russell (1/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 6, 2015 at 9:48 am
Viewing 15 posts - 4,171 through 4,185 (of 6,041 total)