Viewing 15 posts - 1,486 through 1,500 (of 6,041 total)
SELECT * FROM OPENROWSET( "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
‘Microsoft.ACE.OLEDB.12.0’
,‘Excel 12.0;Database=C:\Temp\OrderValues.xlsx;HDR=YES’,results)
May 9, 2017 at 8:46 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 9, 2017 at 8:41 am
To understand the purpose of TEMPDB, why it can occasionally increase dramatically in size, it help to know what objects are allocated in TEMPDB during peak periods of growth. For...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 9, 2017 at 8:39 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 8, 2017 at 12:48 pm
The ubiquitous presence of devices is a blessing in many ways, but one consequence is that we generally spend less time deep thinking. I mean, twenty years ago those occasions...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 8, 2017 at 6:36 am
I second the motion to use UPDATE with OUTPUT clause and thus avoid multiple statements and explicit batch transaction.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 8, 2017 at 6:17 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 7, 2017 at 9:46 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 5, 2017 at 10:40 am
Using EXCEPT to isolate those handful of rows that are different, copy the results from both tables into WinMerge to do side by side flat text comparison.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 4, 2017 at 2:07 pm
I can see the potential for IoT devices in nature conservation and border enforcement. For example, IoT devices placed in remote woodland areas can leverage sound recognition technology to detect...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 4, 2017 at 9:02 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 4, 2017 at 6:45 am
A hotel reservation system is certainly an application where you want to have each user accessing a central database. If it's important to have an operational fail-over mode, just in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2017 at 12:43 pm
Our continuous integration process uses TeamCity / Octopus and our deployments run under the context of a domain based service account. I don't recall the password being persisted anywhere in...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2017 at 12:17 pm
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2017 at 9:25 am
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 3, 2017 at 6:35 am
Viewing 15 posts - 1,486 through 1,500 (of 6,041 total)