Viewing 15 posts - 2,056 through 2,070 (of 6,041 total)
homebrew01 (11/10/2016)
Eirikur Eiriksson (11/10/2016)
Think this is the wrong question, should be "what are the justifications for running an unsupported version of SQL Server"
😎
Doesn't cost any money ?? $10,000 to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 12:54 pm
skeleton567 (11/11/2016)
Eric M Russell (11/11/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 12:06 pm
If you don't like the 2 year cycle of releases, you always just sit every other one out. However, I'd recommend v2016.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 11:33 am
Despite working in IT as both a software developer and database administrator, I'm not a big fan of consumer gadgets or other technology that involves a lot of user interactivity....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 8:22 am
homebrew01 (11/10/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 11, 2016 at 7:56 am
Asking your customers to restore a .BAK file or attach an .MDF file will not be possible if they are not on the same version of SQL Server. For that...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 9, 2016 at 9:51 am
In my previous post, I meant to say "setting DelayValidation = TRUE".
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 9, 2016 at 8:28 am
I'm sorry you have to learn T-SQL by having a 10,000 line stored procedure dumped on your plate, but this is how most of us got our start.
You can go...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 9, 2016 at 8:26 am
Yes, Itzik's books are good. You should get it.
There are also some good topical books by RedGate. This one is especially good, because it will tech optimization techniques from the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 8, 2016 at 2:49 pm
In most of my SSIS packages, I have one project parameter called @Environment which indicates: 'UNITTEST', 'DEV', 'QA', or 'PROD', and I have (4) parameters for each Connection Manager respectively....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 8, 2016 at 9:48 am
Assuming you want to convert a string to DateTime.
CAST('20161108' AS DATETIME)
If the string contains a value that cannot be converted to a true calendar date (ie: Feb 29, 2015), then...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 8, 2016 at 7:09 am
jshahan (11/7/2016)
Eric M Russell (11/7/2016)
jshahan (11/7/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 3:40 pm
I occasionally use DTM (Do The Math) or it's extended form DTFM (Do The Freaking Math) when presented with a suggestion that obviously doesn't compute financially or logistically.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 2:44 pm
jshahan (11/7/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 2:39 pm
TheSQLGuru (11/7/2016)
Eric M Russell (11/7/2016)
TheSQLGuru (11/4/2016)
Eric M Russell (11/4/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
November 7, 2016 at 2:09 pm
Viewing 15 posts - 2,056 through 2,070 (of 6,041 total)