Viewing 15 posts - 46 through 60 (of 38,242 total)
It's not permissions, it's a policy. There is something set that is interfering with the sQL installation.
April 26, 2022 at 3:28 pm
The big issue for compliance in many orgs is knowing what was done. Not preventing mistakes, but knowing that a mistake was made.
There are companies who have developers merge code...
April 25, 2022 at 11:09 pm
There is an OPENDATASOURCE or OPENROWSET, though this is really for adhoc work. You can use those if you have a SQL SErver instance.
SSMS does not connect directly to Excel.
April 25, 2022 at 11:07 pm
dbcc is there to alert you of problems when they occur, primarily corruption issues.
If you don't run these, then they can be in your backups. Potentially if you needed to...
April 25, 2022 at 11:05 pm
This is a policy issue, not Microsoft. Your org has locked down the machine. Talk to a domain admin.
April 25, 2022 at 11:01 pm
The Bible series are a good overview of the platform. That being said, SQL Server 2016 changed how the platform works dramatically, so I don't know that I'd pay much...
April 25, 2022 at 11:00 pm
You can add a columnstore index to a table with a rowstore index. It's just another index.
April 25, 2022 at 5:18 pm
I've had to do this in the past for an app. Here's what I did:
April 25, 2022 at 5:16 pm
I think the key words there are performance. If we've improved performance with an OVER(), then yes, we ought to refactor older code. If we've changed from an IF statement...
April 25, 2022 at 5:10 pm
I get less concerned over the formatting of code. These days we have products like SQL Prompt and other tools that can reformat things as we need them. I do...
April 25, 2022 at 3:33 pm
Indeed. Part of what I wanted to convey is that you need to look at the problem and decide if it's a nail or screw.
I think most people get using...
April 22, 2022 at 4:33 pm
This is something where the question itself is kind of nonsensical, like what is better eating a steak or watching a good TV show. There might be some overlap...
April 20, 2022 at 3:22 pm
I prefer to use Powershell, and Invoke-DbaQuery from within my Powershell scripts for things that require T-SQL. The source of all scripts is then in my Powershell library, instead...
April 20, 2022 at 3:21 pm
Btreieve, wow, I remember that on Novell. Not a fan.
April 11, 2022 at 2:01 pm
Viewing 15 posts - 46 through 60 (of 38,242 total)