Viewing 15 posts - 4,171 through 4,185 (of 6,035 total)
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
Try all three methods (CASE, ISNULL, and COALESCE) and see which is faster in your specific scenario. If you're encountering performance issues, then it's probably the sargability of the query...
February 4, 2015 at 10:07 am
He may also want to consider placing a unique key constraint on session + product + time or date with the ingore_dup_key option set to insure that redundant click events...
February 4, 2015 at 6:42 am
Jeff Moden (2/3/2015)
February 4, 2015 at 6:26 am
Viewing 15 posts - 4,171 through 4,185 (of 6,035 total)