Viewing 15 posts - 3,391 through 3,405 (of 39,818 total)
You should not assume, guess, or expect other permissions.
October 4, 2019 at 11:05 pm
A calendar table is key and Bobs solution works well to build one
October 3, 2019 at 5:16 pm
SP2: https://www.microsoft.com/en-us/download/details.aspx?id=30437
Install SP2, then take a backup. Of course, test this to be sure SP2 doesn't break your app.
Then use the backup to restore on a new SQL 2014...
October 3, 2019 at 2:16 pm
I've had an argument with my ex partner in the past, she claimed that women were discriminated against in the software world.
the truth is that I don't care if...
October 3, 2019 at 2:08 pm
“As our circle of knowledge expands, so does the circumference of darkness surrounding it.” - Albert Einstein
indeed
October 3, 2019 at 2:05 pm
I assume you mean where. It's here (added in article as well): https://www.brentozar.com/archive/2017/03/databaserestore-open-source-database-restore-stored-procedure/
October 3, 2019 at 1:50 pm
No hints to say anything but. As ZZMartin noted, you have a couple options.
October 3, 2019 at 1:04 am
Also, what was added and removed? These are columns, not fields, just to be sure we understand each other.
Perhaps you can better explain with some code what happened?
October 3, 2019 at 1:03 am
another vote for DBAtools.
October 2, 2019 at 5:21 pm
Our warehouse is in the cloud, but really in an IaaS VM that runs a warehouse database.
ML? It's hard, and as Jeff mentioned, often T-SQL finds similar results that are...
October 2, 2019 at 5:20 pm
If you're getting that error, the file isn't in the format you have shown. You must have something like:
create table mytable(
id int
)
create view myview as
select * from...
October 2, 2019 at 5:09 pm
I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it definitely...
October 2, 2019 at 2:56 pm
Cheers, same here. I had to dig around a bit as I needed this for an experiment.
October 2, 2019 at 2:23 pm
It is very easy to end up thousands of documents in something like Confluence but it stops being people's first point of call because ...
Then there are the plethora...
October 2, 2019 at 2:22 pm
That sentence doesn't make sense in English.
Current version shows Windows 10, and a few Windows server platforms: https://www.mysql.com/support/supportedplatforms/database.html
Previous versions will run on Win 7/8
October 2, 2019 at 3:02 am
Viewing 15 posts - 3,391 through 3,405 (of 39,818 total)