Viewing 15 posts - 5,401 through 5,415 (of 6,041 total)
phual (10/26/2011)
E.g.
@Param1 = NULL
@Param2 = 'Value1'
@Param3...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2011 at 10:30 am
On the laptop I use to VPN into the office, I have separate boot and data partitions for personal use and then work, where one is not visible to the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 27, 2011 at 7:13 am
I think the article presents a good enough solution to a specific problem. If I ever have a need to select the TOP X columns from a table, then it...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 26, 2011 at 7:06 am
sanjay.patel 30254 (10/25/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2011 at 8:00 am
If possible, try running a schema comparison including indexes and statistics between the new database and the previous database instance. Perhaps in the process of migrating to the new server...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2011 at 7:03 am
CELKO (10/24/2011)
Why did you encourage him? Sounds like time for re-education:w00t:
On a slow day, even the best of us may become so distracted by the challenge of solving some small...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 25, 2011 at 6:41 am
For more complex type record matching problems, I turn to the ranking functions.
Example:
select * from
(
select *,
...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 24, 2011 at 3:54 pm
liebesiech (10/21/2011)
As mentioned by others, sometimes you cannot remove a database as it is the only source for important legacy information.Just to give you an idea...
Ideally all relevent legacy...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 21, 2011 at 7:46 am
Know the the Standard Model, the six types of quarks, their intrinic properties and interactions. Also know at least the Wizard's First and Second Rule.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2011 at 3:28 pm
Sending out a broadcast email asking if it's OK to retire a database is good, but depending on the size and organization of the IT department, it's entirely possible for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2011 at 12:12 pm
If this were Oracle, I could do it all with an inline expression using the DECODE() and LEAST(<value>, <value>, ....) functions.
However, after deriving a version of your table that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2011 at 11:29 am
I agree that, if your application needs to reference very large entity-attribute-value datasets, then it would perhaps be best to move those specific tables out of SQL Server and into...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2011 at 8:55 am
Is it really true that we can't anonymize data?
It is possible to remove or hash the personally identifying attributes (name, ssn, contact info, etc.) from a flat dataset or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 20, 2011 at 7:36 am
Steve Jones - SSC Editor (10/12/2011)50, years that is.
An amazing view
A touch of danger
Steve, this is just a guess, but has Red Gate offered you a lofty executive position?
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 12, 2011 at 7:28 am
Several years back, I was working on a government contract to develop the database backend for a web application that would query a large accounting datamart, and then build a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 11, 2011 at 12:38 pm
Viewing 15 posts - 5,401 through 5,415 (of 6,041 total)