Viewing 15 posts - 2,896 through 2,910 (of 6,041 total)
roger.plowman (2/5/2016)
Eric M Russell (2/3/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 5, 2016 at 11:27 am
TomThomson (2/4/2016)
Eric M Russell (2/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 5, 2016 at 7:39 am
It sounds like your concerns are to load data from old table into a new table while mimimizing transaction logging, downtime, and risk.
Consider this approach.
1. Using BCP, bulk copy your...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 5, 2016 at 7:23 am
Luis Cazares (2/4/2016)
...Of course, it would be better to store dates in date columns. But that's none of my business. 😀
Yes, it is best to create the table with real...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2016 at 1:26 pm
TRY_CONVERT() is also useful for check constraints. For example, below we are requiring that "date" values stored in a VarChar column called FooDate can be casted as an actual Date.
create...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2016 at 11:44 am
To quantify the overhead cost of TDE, one approach is to run a test workload, something like replaying a profiler trace, against both a TDE version of your database and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2016 at 11:31 am
Some good ideas (like open source software, open IT floor plans, and telecommuting) come out of startups and are adopted by the larger corporate establishment. However, much of the "big...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2016 at 9:14 am
Years ago, I started working for a company where the developers didn't check their .sql scripts into version control, or at least the smaller team I worked with didn't. However,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 4, 2016 at 7:02 am
Orlando Colamatteo (2/3/2016)
Eric M Russell (2/3/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2016 at 3:30 pm
Let's assume that the business requests a high priority modification to functionality currently in production. Let's also assume that the development team has recently made an unrelated bug fix or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2016 at 1:23 pm
What matters most is outcome. At the risk of sounding like an apostate; I'll assert that methodologies, souce control repositories, and roles are just frameworks and tools that exist only...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2016 at 9:58 am
Coincidentally, just last week I was just searching the web for a good pattern for implementing a queue in SQL Server. How well this works depends on dequeue volume and...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2016 at 9:13 am
Orlando Colamatteo (2/2/2016)
Eric M Russell (2/2/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 3, 2016 at 7:22 am
From the perspective of a DBA, I'm sure most of us would prefer that stored procedures an views be stored in clear text and that we have the option to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2016 at 2:25 pm
Are we talking about management, monitoring, or both? There is this thing called Microsoft Operations Manager, which is used to manage and collect operational stats for servers across the enterprise.
......
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 2, 2016 at 1:48 pm
Viewing 15 posts - 2,896 through 2,910 (of 6,041 total)