Viewing 15 posts - 3,046 through 3,060 (of 6,041 total)
Somewhat related to SQL Server, when writing remote queries or ETL packages against Oracle, try to remember that an empty string in PL/SQL is equivalent to NULL. At least understand...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 31, 2015 at 9:06 am
If you're using a MERGE statement to perform something like a Type 2 Slowly Chaning Dimension operation, then it helps if you can apply a range condition like: WHERE SaleDate...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 31, 2015 at 8:14 am
joeshu26 (12/31/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 31, 2015 at 8:07 am
Maybe it's just me, but it seems this past year (and 2014 as well) there were a lot of existential discussions here on SQLServerCentral regarding our careers and the industry...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 31, 2015 at 7:54 am
MMartin1 (12/30/2015)
Eric M Russell (12/30/2015)
Orlando Colamatteo (12/30/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 31, 2015 at 6:46 am
Orlando Colamatteo (12/30/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 2:26 pm
David.Poole (12/30/2015)
TomThomson (12/30/2015)
Steve Jones - SSC Editor (12/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 1:11 pm
Orlando Colamatteo (12/30/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 12:35 pm
Grumpy DBA (12/17/2015)
Steve Jones - SSC Editor (11/12/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 10:03 am
Brandie Tarvin (12/25/2015)
Eirikur Eiriksson (12/24/2015)
Brandie Tarvin (12/24/2015)
Oh, has anyone stayed at a Hyatt recently?He he, cash only:-D
😎
I'm genuinely curious how you manage that when all the hotels demand credit cards...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 8:10 am
First, any DBA who tells you the database hasn't been backed up for months; I just wouldn't take their word for it, and they could be wrong. Before proceeding any...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 30, 2015 at 7:30 am
Where are you getting the message from? It looks like a custom programmer defined message. The term "ICD10" relates to healthcare coding not SQL Server.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 1:01 pm
If the data can't be easily re-sourced, meaning it's accumulating change data history, and the goal is tho retain the data permanently, which I'm guessing would be the reason for...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 12:29 pm
Alvin Ramard (12/29/2015)
Eric M Russell (12/29/2015)
At a bare minimum, all you need is Notepad, but the free SSDT tool provided by Microsoft provides some nice to have features too.
Eric, if...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 12:10 pm
I occasionally rip off some ideas from chef Alton Brown and put it to good use in my kitchen. I don't think the guy would mind.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
December 29, 2015 at 11:51 am
Viewing 15 posts - 3,046 through 3,060 (of 6,041 total)