Viewing 15 posts - 1,681 through 1,695 (of 6,041 total)
Debates over primary keys and clustered indexes never get old.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2017 at 11:21 am
Code compilation isn't much of an issue in my realm. However, if a user runs a query that joins two or more billion row tables using a non-indexed expression and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2017 at 11:06 am
... This is attributed to the user clicking the operation, waiting a bit for a response, and when one was not presented, clicking the button again. I know what...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 22, 2017 at 10:52 am
There is no compelling reason to avoid cursors and dynamic sql when you're doing something like coding an administrative script that is occasionally used to iterate across databases or servers....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2017 at 8:58 am
You might as well disable the login until the application is fixed.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2017 at 7:21 am
A lot of application developers only work with transient persistence layers, something like session state for an embedded application or the shopping cart for an eCommerce website. In that case,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2017 at 6:40 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 21, 2017 at 6:28 am
I'll bet Google knows exactly where Steve is, right this minute. They know where he was exactly one year ago, and they probably have an algorithm that can predict where...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2017 at 12:42 pm
Perhaps start with the AdventureWorks sample database, and then extend it by modeling additional tables for Payroll or Invoicing.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2017 at 12:37 pm
Some people may (even subconsciously) be using their work life as an escape from home life.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2017 at 11:55 am
If you lose a decision, do you resort to violence...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2017 at 8:43 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 20, 2017 at 7:48 am
... The news cycle seems to be dominated by discussion of politics. Regardless of where you fall on the political spectrum, the talk of politics is inescapable and is...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 19, 2017 at 6:28 am
Thanks for finding what tables contain the catalog permissions. Based on this I'll code up a script to generate GRANT_PERMISSION statements from SSISDB. There should have been a way to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2017 at 12:48 pm
First, is the workload on the new server the same as what was typical on the old? Also, list and compare the server level settings between the new and old...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 18, 2017 at 12:41 pm
Viewing 15 posts - 1,681 through 1,695 (of 6,041 total)