|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Shrink and Release | |
I want to use DBCC SHRINKDATABASE to get some space back after a lot of data was deleted. Which option will release free space back to the operating system? | |
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) |
My New Resolution Answer: Explanation: |
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 - Development |
Is it possible to migrate a solution from SSMS to SSDT?? - VS 2017, SQL Server 2016 and 2017, is it possible and or making sense to migrate a solution from SSMS to SSDT? The main purpose is to incorporate large solutions with multiple files into TFS that SSMS is not supporting. |
Help with query - Hi all, This code gives 2 results SELECT distinct(AtcCode) as id, Atc_Text FROM [dbo].[Drugs_BasicData] d inner join [dbo].[ATC_CodeTexts] t on t.AtcCode = d.ATC AND t.County = 'DK' INNER JOIN dbo.Companies c on d.Distributor = c.CompanyID WHERE c.Country = 'DK' AND LEN(AtcCode) > 5 and Atc_Text like 'Cefalexin%' Order by Atc_Text; id Atc_Text QJ01DB01 Cefalexin […] |
Administration - SQL Server 2014 |
No objects listed for "SQL Server performance condition alert"? - Hi All, Facing a weird issue. We are trying to create some alerts in our SQL Server 2014 BI edition. Issue is that, after I chose "Type" as "SQL Server performance condition alert" nothing is listed in the "Object" list box. SQL Server event alerts are working. Issue is only with "SQL Server performance condition […] |
Development - SQL Server 2014 |
How to remove additional element from Nested XML - Hey everyone. I'm a bit new to XML and had an issue with some formatting. I'm nesting XML queries and it creates an additional element which I need removed. Here is a sample of what I'm doing. select PrintOrderNo as "@PrintOrderID" ,PayGroupID as "@PayGroup" ,( select LineNumber as "@DetailNo" ,CompensationDescription as "@Description" FROM Table1 […] |
SQL 2012 - General |
Noob SQLServer 2012 Question - Let me preface this with I am a sysadmin working on an SCOM 2016 install and have a question regarding an error message that keeps getting thrown via application event logs. An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'DOMAIN\ACCESSACCOUNT', […] |
Execution plan not show missing index so are there are remainig point to enhance - I work on sql server 2012 my execution plan as below my query is very slow it not show missing index so please how to enhance query please ? my execution plan as below https://www.brentozar.com/pastetheplan/?id=HJbwOAkhF |
are there are any thing can do after create index to enhance query speed ? - I work on sql server 2014 i need to enhance query my execution plan as below : https://www.brentozar.com/pastetheplan/?id=ryWtGAknF now i create index as execution plan analysis CREATE NONCLUSTERED INDEX MissingAttr_idx ON [dbo].[TPartAttributes] ([ZfeatureKey]) INCLUDE ([PartID],[Name]) my question are there are any thing remaining can do to improve enhance after create index as above |
SQL Server 2019 - Administration |
Install SSIS - Hi I am getting this error when i try to install SSIS: MainViewModel.OnBundleAction: Bundle action failed: The requested metafile operation is not supported (0x800707D3) I am downloading and installing this file: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects I already installed Visual studio 2022 and I am running SQL Server 2019. Do you know how I can fix this error message? […] |
SQL Server 2019 - Development |
Trying to print barchart to PDF file using Python within SQL Server ML module - There are likely to be several unrelated errors here, but I'm going to start with the first one what I can get my mind around. I'm trying to use the "Python within SQL Server" mechanism to generate a barchart to PDF. I get an error message that I don't have permissions to the directory I'm […] |
Get Data from Internet Directly into SQL Server - Hi I am using these rates for a calculation https://www.treasury.gov/resource-center/data-chart-center/interest-rates/pages/textview.aspx?data=yield Currently, I manually update a local table and then insert that table into SQL Server. It would be ideal if I can get SQL Server to directly access the rates from that site. Is this possible? If yes, how would I do that? Thank you |
CASE statement and partition by - Hello everyone, I have a question if someone may know how to adjust the code correctly. I need just to edit the last outer SELECT statement. I need to change the partition by DMDUNIT, I need outer CASE statement to look at 2 columns: 1) Start Date - if we have 3 distinct weeks worth […] |
Using OPENDATASOURCE as an ad hoc Linked Server - I'm not sure if this should be posted here or not, but I will try. We have a configuration where multiple customer databases are distributed across several servers. On occasion (not frequently), it is necessary to compare data between two databases on the same table utilized by the application. Because there are several Servers […] |
BCP adding carriage return/new line every 2034 characters - I have an SQL query that creates a JSON output. The query works properly and gives me the output I expect when I manually run it via SSMS. When I run it in a BCP command from an SP, the BCP utility is adding carriage returns and new lines every 2034 characters. I can open […] |
Interpolation/Extrapolation - Hi everyone I am trying to use linear and cubic spline interpolation/extrapolation to fill in missing rates. I have never done this before in SQL. What is the most efficient way to do this? Thank you |
General Cloud Computing Questions |
Cloud Storage Questions... - Hi. I own a mobile entertainment business....dj, photobooth, karaoke, etc... I have had several portable hdd failures, and am concerned about loss of data. I am hoping to find a way to host an online backup of about 5tb of files (music, video, photos, etc...) but don't know where to start looking. I have searched […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |