Viewing 15 posts - 8,041 through 8,055 (of 39,877 total)
Certainly it's hard to make a stable schema, but I also think that databases are supposed to evolve over time. We don't really keep stable schemas. We add things.
So.
AdventureWorks. If...
June 6, 2016 at 12:28 pm
Yeah, earlier than 2014. My typo. I was thinking 4.2 and typed 2014. I've been doing a lot of 2014 stuff for demos and my instances is .\SQL2014.
June 6, 2016 at 12:21 pm
One more you might want to give to managers, especially IT managers is The Phoenix Project - https://www.amazon.com/Phoenix-Project-DevOps-Helping-Business-ebook/dp/B00AZRBLHO?ie=UTF8&btkr=1&ref_=dp-kindle-redirect
June 6, 2016 at 12:20 pm
You should just restart the windows host, not delete anything.
June 5, 2016 at 10:05 am
It's been pointed out this is a bad idea. Some companies do this, even large ones, to make AD admin easier.
However, this is an issue for me. If I need...
June 5, 2016 at 10:01 am
You don't want your antivirus to read the filestream container. You should only scan the file when it is copied to another folder. There is no concern I'm aware of...
June 5, 2016 at 9:56 am
Brandie Tarvin (6/3/2016)
Steve Jones - SSC Editor (6/1/2016)
SSMS is decoupled from SQL. You need to install that separately.
Wait. Client tools are no longer an option to install with the rest...
June 3, 2016 at 3:03 pm
That's fine.
I'll still disagree as well. Given history and the way many samples are given, there is often this code:
...
; with mycTE()
...
I hope to bring to light the reason for...
June 3, 2016 at 3:01 pm
roger.plowman (6/3/2016)
But there is a line, and MS has crossed it some years ago. Their code quality is dropping. This fast-cadence BS is one of the biggest contributors.
[\quote]
I don't know...
June 3, 2016 at 3:00 pm
roger.plowman (6/3/2016)
Steve Jones - SSC Editor (6/2/2016)
roger.plowman (6/2/2016)
The whole "let's release this stuff NOW and worry about patches later" is stupid.
First, that's not what's happening. The patches are tested, run...
June 3, 2016 at 2:55 pm
We can be pedantic if we want. However, a batch consists of 1 or more statements. The option notes that the previous statement is not terminated, so a ; is...
June 3, 2016 at 2:51 pm
Ed Klein-385786 (6/3/2016)
June 3, 2016 at 2:44 pm
You are correct. I did this at like 10pm last night. I guess we get two winners.
June 2, 2016 at 12:56 pm
Well, I certainly understand cost and licensing changes. I tend to agree there.
However Linux has patches almost every month coming out, same as Windows. MySQL has quarterly patches, so...
June 2, 2016 at 9:33 am
Terje Hermanseter (6/2/2016)
cad.delworth (6/1/2016)
Just the smell of coffee makes me want to vomit (literally)
That's the first time I've ever heard of anyone that gets sick from the smell of coffee...
June 2, 2016 at 8:43 am
Viewing 15 posts - 8,041 through 8,055 (of 39,877 total)