|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Offline Filegroups | |
I have multiple files in a filegroup in my database. There are two filegroup: Primary and Archive. I decide to run this code: ALTER DATABASE FGTest MODIFY FILEGROUP (NAME = N'Archive', OFFLINE) GOWhat happens? | |
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) |
BDC Storage A SQL Server BDC (Big Data Cluster) includes a scalable storage pool. How is this set up? Answer: This is an HDFS structure Explanation: The data storage pool is set up as HDFS. There are SQL Serer nodes that have mdf/ldf/ndf files, but those are separate from the storage pool. Ref: What are Big Data Clusters? - https://docs.microsoft.com/en-us/sql/big-data-cluster/big-data-cluster-overview?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 2017 - Administration |
Cost Threshhold for Parallelism and MDOP - will these always have an effect? - Sorry for the newb question, but as I explore the Cost Threshhold for Parallelism and Max Degree of Parallelism configurations in SQL Server and talk with colleagues, I'm getting more confused. My understanding is that the SQL Server engine will recognize larger queries expected to take a lot of time/resources, and will automatically make use […] |
SQL Server 2017 - Development |
CONNECT BY result - Hi friends, How can we get multiple dates and days for the given number? In this example, 10 is given with '01-Jul-2020'. So 10 dates and days from 01-Jul-2020 are displayed. Could you please help on this? |
Administration - SQL Server 2014 |
Ola Hallengren backup has a bug - Hello, I am trying to use the transaction log backup Ola Hallengren scripts, until i came across an issue, where if the string is too long, and has a line break or goes to the next line, then it will give error message: Cannot open backup device 'X:\Backups\SERVER001\Database0001\Log\SERVER001$SERVER001 _Database001_Log_20200731_203617.trn'. Operating system error 123(The filename, directory […] |
SQL Server 2012 - T-SQL |
update full path for record - Hi, I have a table as you can see in codes below. Can you please help me with generating the last column 'ExpectingResultofPath'? Considerations: The first record is the parent document with level = 1. The rest of records are children documents embedded in the parent doc, so I need the full path+filename from the […] |
SQL Server 2019 - Development |
get top 5 max count for each month - How do you return a list of the companies, sales, and month for the top 5 sales for each month without merging 12 queries with a union? The script to create the table and data is attached. |
string compare again .. :) - I have a meta data string with 5 different numbers, for example @mdtsr ='4,12,13,14,17' and i have few hundred thousand records in a table with same structure, i mean 5 numbered string with a comma separator. I need to compare the strings in the table to metadata string and find all the records with at […] |
sp_OAMethod to make rest api call - Greetings, I have a need to call a rest api against a resource. It a POST and would like to send the following as POST option http.post(url, '{ "https": { rejectUnauthorized: settings.ssl }, "headers": { "Authorization": "BASIC dfsdkfdsfyduyfiuhdfiuyu5y43=", "Content-Type": "application/json", "Accept": "application/json" } }' ) Tried to this but it fails EXEC @ret = sp_OAMethod […] |
insert update help in sql server - Hello All, I have a insert update procedure where I am getting data from 2 procedures and putting the data in to a table. So procedure 1 has data like this AgentName Tickets Closed Agent1 10 Agent2 2 Agent3 4 Agent4 6 Agent5 9 Agent6 12 Procedure 2 has data like this AgentName Active […] |
Cant figure out how to pull data from one table but get diffrent results - I have an Employee table that has a primary key. This key is used in another table for both a Welder column and a Operator Column. How can i get the query to show two different results. EX. we have a robots that weld. The welder would be RO1 but the operator would be NG. […] |
SQL Server 2008 - General |
2nd Server min requirements for transaction log shipping - I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the production (primary) database server in a vSphere environment. I was planning on creating a secondary server that mirrors the Operating system environment and SQL server configuration, which is where the primary databases transactional logs will be shipped and applied. Since this […] |
T-SQL (SS2K8) |
Update and Joins - In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query? Is there a shorter way to write this update query? Cheers, J. DECLARE @IDHUIS VARCHAR(4) = NULL, @IDBEW INT = NULL --SET @IDHUIS = 'PH' --SET @IDBEW = 1401 ;WITH MYCTE AS ( SELECT B.IDHuis, […] |
Update and Joins - In the query below do I need to join tables Brs to MYCTE in the UPDATE portion of the query? Is there a shorter way to write this update query? Cheers, J. DECLARE @IDHUIS VARCHAR(4) = NULL, @IDBEW INT = NULL --SET @IDHUIS = 'PH' --SET @IDBEW = 1401 ;WITH MYCTE AS ( SELECT B.IDHuis, […] |
SSRS 2012 |
How do I pass parameters to a SSRS report? - This is one of those topics that always seem to confuse me. I've got notes saying I should do something like this: http://ourreportmanagerserver/Reports/Pages/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512 and I've also got notes that specify this: http://ourreportmanagerserver/ReportServer?/Pharmacy+Inventory+Reports&InvoiceByInventoryOutID=28512 Now, to complicate things further, I've made a selection report, so that a user, if they user the Report Manager server, can select […] |
Analysis Services |
Error processing SSAS cube using TMSL via SQL Server Agent Job - Hi, I am trying to automate SSAS cube processing by having an SQL Server Agent job run a TMSL script. I have 2 servers (SSAS where all the cubes live and ETL where all the jobs live). Both are 2017 version. Below is what I tried and the error I am getting: Created TMSL script […] |
Job Postings |
Beta user call- Google Cloud Platform SQL 2019 solutions - We are looking for SQL developers as beta users for our SaaS solution ( SQL server 2019 ) in Google Cloud Marketplace. It is ready to use deployment package for SQL server at Google Cloud Platform, where you can deploy within seconds. Literally. https://console.cloud.google.com/marketplace/details/gclouds-public/sql-server-2019-express What we are asking to them; -test the solution and provide […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |