Viewing 15 posts - 3,091 through 3,105 (of 6,041 total)
Matt Miller (#4) (12/22/2015)
Eric M Russell (3/23/2011)
An MP3 player and an automobile engine are two unrelated systems that should not be tightly coupled.
Hmm that reminds me of some quotes I...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2015 at 7:05 am
The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2015 at 6:59 am
Eric M Russell (12/23/2015)
mjh 45389 (12/23/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2015 at 6:54 am
null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2015 at 6:53 am
null
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 23, 2015 at 6:51 am
awarnke 39611 (12/22/2015)
Jacob you are correct it is a virtual environment. We tried giving priority to the processors, but not much change. We...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 7:26 pm
It depends on what they're planning to use CLR functions for.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 2:34 pm
Have you confirmed how many CPU are visible to SQL Server? This could be limited by licensing or configuration.
http://www.eraofdata.com/how-many-cpus-can-sql-server-use/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 9:17 am
GilaMonster (12/22/2015)
Eric M Russell (12/21/2015)
Try unit testing using (MAXDOP 1) query hint.
Why? Parallel execution is good, it means SQL's using resources effectively to return results quickly. A parallel query is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 9:06 am
Remotely hacking another driver's Bluetooth component system is a way cooler and less violent way to express road rage than pulling out a handgun. 🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 7:50 am
Remember the story about the 5 year old kid who accidentally discovered he could hack through XBox user authentication by padding the password field with a spaces?
http://www.cnn.com/2014/04/04/tech/gaming-gadgets/5-year-old-xbox-hack/index.html
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 7:17 am
Ivanova (12/21/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 22, 2015 at 6:54 am
Ed Wagner (12/21/2015)
Eric M Russell (12/21/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 21, 2015 at 3:28 pm
Let me guess... the table is 100 GB, there are twenty foreign key dependencies, and they want it deployed to production before Christmas? 😛
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 21, 2015 at 3:12 pm
If the new columns are required by the business and there is a 1x1 normalized relationship between them and the original table, then add then to the original table. What...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 21, 2015 at 2:51 pm
Viewing 15 posts - 3,091 through 3,105 (of 6,041 total)