Viewing 15 posts - 4,171 through 4,185 (of 6,038 total)
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
In some organizations, because of the way the pay grades and scales are structured, getting promoted to management is the only way for a senior level IT employee to get...
February 6, 2015 at 8:11 am
First, I'm assuming that these user login accounts are properly assigned as members of default [public] server role and NOT [sysadmin]. There is nothing you can do to hide things...
February 5, 2015 at 3:37 pm
I also got my start back in late 80s and early 90s working with FoxPro and dBase on DOS, and later Clipper on OS/2. I thought I could build an...
February 5, 2015 at 9:45 am
Viewing 15 posts - 4,171 through 4,185 (of 6,038 total)