Viewing 15 posts - 3,061 through 3,075 (of 6,041 total)
At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 11:45 am
Plagiarism is more than just copying and pasting a block of code into a blog post; plagiarism is when you present someone elses original work as your own original work.
The...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 7:54 am
I'll secound Jeff's emotion that ETL staging tables should be contained in a separate dedicated database. Not only would it compete for resources with the OLTP database, but it would...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 7:09 am
Luis Cazares (12/28/2015)
Eric M Russell (12/28/2015)
TheSQLGuru (12/28/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 11:39 am
Well, since the initial publication of this editorial back in 2005, we know have OS virtualization, which "clouds" the issue of "SQL Server running on Linux". 😉
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 11:09 am
I'm not aware of a tool that will automate what I've described above, but if you script out INSERT.. SELECT.. scripts for each of the 500 tables using SSDT or...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 10:28 am
I'm assuming the scenario is that you have two clients in separate SQL Server instances, each having overlapping sequential integer identifiers, and so you need to assign new identifiers as...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 10:11 am
TheSQLGuru (12/28/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 9:45 am
In addition to what's already been mentioned above:
On the fly data type conversion and transformations, both explicit and implicit
Distributed queries (ie: joining tables between multiple instances via linked server...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 7:59 am
To balance out the concerns regarding taxes and health insurance, consider a long term contract ostensibly means less time sitting on the bench between gigs. For that reason, your rate...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 7:05 am
.. One of the primary reference data points in the article is that 34% of US workers engage in freelance work. There's a reference to a study that says 41million...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 28, 2015 at 6:43 am
Well, im still not sure about RegEx in a data warehouse. Parsing text columns suggests things like product descriptions were not identified by category in a way thats useful to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 26, 2015 at 8:19 pm
Phil Parkin (12/26/2015)
Solomon Rutzky (12/26/2015)
Eric M Russell (12/23/2015)
The only practical use for CLR in a data warehouse that comes to mind is perhaps a custom aggregate function.
Just out of curiosity,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 26, 2015 at 10:41 am
The easiest thing to do would be to disable trigger, insert in one shot, and then re-enable trigger.
I cant believe they've got you doing this b.s. on Christmas Eve....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 24, 2015 at 1:16 pm
This should work.
- You didn't need the full name of the tblcall table in the WHERE clause, only the alias + column name.
- Also, in the JOIN clause,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 24, 2015 at 8:59 am
Viewing 15 posts - 3,061 through 3,075 (of 6,041 total)