Viewing 15 posts - 3,331 through 3,345 (of 6,041 total)
Run this to get a breakdown of how much memory is allocated to each memory cache,. The page buffer cache is CACHESTORE_OBJCP and query plan cache is CACHESTORE_SQLCP.
Select [type],SUM([single_pages_kb]) As...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 12:37 pm
I only use triggers as a last resort, and this isn't one of them. One technique you can use is to add a column containing a CHECKSUM() of whatever columns...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 11:04 am
Soundex has been around since 1918 and it's algorithm for letter substitution is documented here:
https://en.wikipedia.org/wiki/Soundex
Perhaps you can use REPLACE() function to massage the keywords before you do SOUNDEX() comparison.
SOUNDEX(replace('Kolton','K','C')) =...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 10:40 am
All the folks committed to psychiatric hospitals during past decades, because they were convinced their TV and refrigerator were spying on them, we can let them all out now.
They're no...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 10:24 am
Kim Crosser (10/7/2015)
...
This is a very useful code pattern I expect to use in more than just this project. 😎
Hey Kim, when you get it all working and identify...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 9:12 am
Personally, I'd rather not deal with 100 separate SSIS packages, even if they are auto generated by BIML. If you can leverage BIML or .NET to programmatically modify the DataFlow...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 9:00 am
Jeff Moden (10/7/2015)
Eric M Russell (10/7/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 8:15 am
Shawn Melton (10/6/2015)
Eric M Russell (10/6/2015)
Symantec Endpoint Protection
Web Attack: Malicious Website...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 7:12 am
Matt Miller (#4) (10/7/2015)
GoofyGuy (10/7/2015)
IoT appliances benefit service providers more than it does consumers.
I guess I'll trot out my capitalist top-hat and say that if consumers are...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 3:36 pm
GoofyGuy (10/7/2015)
IoT appliances benefit service providers more than it does consumers.
I guess I'll trot out my capitalist top-hat and say that if consumers are willing to accept...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 1:37 pm
I'd rather have more generic SSIS packages and manage 100s of views, rather than managing 100s of SSIS packages. I'd also rather deploy 100 views than I would deploy 10...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 1:28 pm
IoT appliances benefit service providers more than it does consumers. Of course groceries stores would love to peek inside your refrigerator and see what you've got in stock. Not only...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 12:01 pm
A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a "centralized repository of information about data such as meaning, relationships to other data, origin,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 11:47 am
mister.magoo (10/7/2015)
Eric M Russell (10/7/2015)
mister.magoo (10/6/2015)
select MBT.refID,
hashbytes('MD5',(select MBT.* from...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 8:07 am
Alex Gay (10/7/2015)
The problem was after that many years we only had three members of staff who could program Clipper well enough to provide support, and they were the IT...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 7, 2015 at 7:29 am
Viewing 15 posts - 3,331 through 3,345 (of 6,041 total)