|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Flatten a Multidimensional List in Python | |
I have this list in python:
mdlist = [[10,20,30],[40,50,60],[70,80,90]]I want to remove the grouping and get this list: [10, 20, 30, 40, 50, 60, 70, 80, 90]Which of these does this and stores the result in a variable? | |
Think you know the answer? Click here, and find out if you are right. |
Yesterday's Question of the Day (by Steve Jones - SSC Editor) |
Executing All Procedures From a Group I have a schema in my SQL Server 2019 database, called xyz. I have an Active Directory user added as a user to my database as MyDomain\SQLAppUser. How can I allow this user to execute all stored procedures, current and future, in this schema? Answer: GRANT EXECUTE ON schema::[xyz] TO [MyDomain\SQLAppUser] Explanation: The GRANT EXECUTE ON schema::[] is the way to do this. This allows any procedures that exist, or are created, in this schema to be executed by the target. Ref: GRANT - https://docs.microsoft.com/en-us/sql/t-sql/statements/grant-database-principal-permissions-transact-sql?view=sql-server-ver15 |
Database Pros Who Need Your Help |
Here's a few of the new posts today on the forums. To see more, visit the forums. |
SQL Server 2016 - Administration |
unable to see data in select - Result set sample: event_name TIMESTAMP IsCached IsRecovered IsDac Duration CpuTime PhysicalReads LogicalReads Writes ClientConnectionID ContextInfo SessionID ClientAppName SessionNTUserName UserName DatabaseName DatabaseID EventSequence CollectSystemTime ClientHostName ServerPrincipalName NTUserName ActivityIDXfer ActivityID database_name logout 2021-05-31T16:29:46.776Z false false false 0 0 0 76 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL […] |
Automate restore - Any one help to automate the restore of a database from one server to another server through sql job |
SQL Server 2016 - Development and T-SQL |
Snapshot Isolation on Transactional Replicated DB _slow ???? - Hi We went from a backup and restore Reports database to a transactional Replicated DB. I have a job overnight that creates a table, the jobs took about an hour, now on the replicated copy of the DB the job take 12+ hours The job does do a bunch of updates . I tried adding […] |
SQL 2012 - General |
This query is very slow how to enhance it to be more faster? - I work on sql server 2012 I face issue this query when run is very slow so how o enhance it to be more faster query and execution plan exist on link below : https://www.brentozar.com/pastetheplan/?id=S1wEKwf5O sql query as below ; ;WITH cte AS ( SELECT Po.GlobalPnId , Po.FamilyId, po.CompanyID, Po2.GroupId, CAST( CONCAT(LTRIM(RTRIM(CASE WHEN Po.PortionKey=N'Blank' THEN […] |
Database stuck in recovery mode after server restart - Hello, We were running a particular update on a huge table and SSMS got stuck, it gave the error "Locked timeout exceeded limit" on the database. After doing some search, we decided to do a server restart. The DB in question is coming in "Recovery" mode after restart. Does it recovers on its own or […] |
SQL Server 2012 - T-SQL |
add another check for update - This SP updates prices and now I need to add an additional check coming from the MTD_INV_LINE_ITEM and the mtl_addr_price tables. In the MTD_INV_LINE_ITEM there is a field called channel, it can have 3 different values z1a,z1b,z1c and in the mtl_addr_price there is a field called division that has 2 values rrb,rrc. If the channel […] |
SQL Server 2019 - Administration |
TempDB for multi instance - I plan to deploy a 2019 standard with two instances on a virtual machine (vmware with backend iscsi san for datastore). For a physical machine, I would definitely allocate separate volume for tempdb. But wanted to get some ideas on how to go about designing when it came to a VM. Should I create a […] |
Opening DBF Files thru Linked Server in Windows Server 2019/SQL Server 2019 - I am in the process of migrating a Database from Windows Server 2012/SQL Server 2014 environment to a Windows Server 2019/SQL Server 2019. I have a Linked Servers defined with 'Advantage OLE DB' provider to open .DBF files. As SAP does not have a latest Driver for Windows Server 2019, the Linked server hangs after […] |
SQL Server re- installation at windows core system - I was asked to install SQL Server at the machine with windows without GUI installed. I had an .ini file prepared and installation files were mounted. So I logged into the machine with RDP connection, copied ini file to 'C:\Temp' folder and triggered installation with the below command: Setup.exe /ConfigurationFile = 'C:\Temp\install.ini' The installation completed […] |
CMS on an AOAG? - Hello everyone, is it possible, to put the CMS on a AOAG? We do a lot of maintenance jobs from our CMS, and we are afraid, if the server will crash. Therefor we thought, if it is possible, to put the CMS on an AOAG. Are there any tricks, or just try it? We use […] |
SQL Server 2019 - Development |
SQL Subqueries - Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of admissions. there are two tables relevant to this quary. Admission and Department as you can see in the picture. where Department.ID and Admission.DepartmentID is the relation. (the reshnum is like serialnumber/name of the […] |
Reporting Services |
New line based on fixed characters in a field - hi i have a field available in ssrs that has all of the address lines joined together split only by ~ eg 164 street~city~state~postcode i want this to post as 164 street city state postcode i have tried using replace statements, with no luck, what is the most efficient way of doing what i […] |
Powershell |
Load folder full of csv files - I have a folder with csv files that has 2 columns a datetime, and a integer value. I want to load them all to a SQL table, but I need to create a 3 column in my table called filename. In this filename column I need to capture the filename of the file it's loading, […] |
Strategies and Ideas |
Factless fact to resolve business requirements or other design approach? - Our client would like to have the list of candidates/employees with their corresponding position, job capacities (consultant, analyst, etc.) and work history. Employee list will be turned into a dimension table linked to other fact relationships (e.g. fact_salary, fact_proposal_investment, etc.) same with job position as a candidate dimension. My worry is on the Work/Job history […] |
Integration Services |
Rename file extensions on FTP site - Hi We have a need to rename some *.tmp files to *.txt files on a suppliers FTP site and wanted to know if this is possible to do using a script task in SSIS? If so please can an example be provided Thanks Andy |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |