|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
BDC Instances | |
What are the types of SQL Server instances that are part of a BDC (Big Data Cluster)? | |
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) |
Holding Dirty Pages What must happen before a dirty page is written to disk? Answer: The associated log record must be written to disk Explanation: Write-ahead logging is used to ensure log records are written to disk before data records. This prevents a dirty page from being written before the log record is hardened. Ref: Writing Pages - https://docs.microsoft.com/en-us/sql/relational-databases/writing-pages?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 - Development |
Stored Procedure with Money Value - hi everyone, I've a "problem" with a Stored Procedure and .net application because two values (money) are managed as double and this generate a mismatch with currency (should be 187,50 but is 18750). In SQL, I created a User Table and SP: CREATE TYPE tbl_FIC_InvoiceGuest AS TABLE ( Invoice_Token nvarchar(50) NULL, Invoice_Total money NULL, ) […] |
SQL Server 2016 - Administration |
SQLServer2016 SP2 CU14 - Hi, Version: Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 (Build 14393: ) (Hypervisor) We would like to install latest patch CU14 .But Last time CU12 installation was failed in this server. Can we […] |
SQL Server 2016 - Run Jobs on Dynamic Logical Schedule - Hello, In SQL 2016, I currently have monthly, weekly and daily maintenance plans that run on a fixed schedule. As a new requirement, I need to run it more dynamically than on a fixed time. The plan is: 1. If 1st of month - then run Monthly job 2. Then check if this is a […] |
SQL Server 2016 - Development and T-SQL |
sql2016 - if column cell changes, insert value into another column cell - How can I calculate or insert TrimWgt (17.15 from MasterRolls value =3) and (17.15 from MasterRolls value = 4) into another column if the MasterRolls column increments or different from the the previous. If I had another column in the table or I can create another table. Please assist. My table is updating every 30-60 […] |
Development - SQL Server 2014 |
PIVOT table with more than one aggregate and for only weeks with data. - I need help to pivot my sql output for Class with aggregates of QTY and CUBES for WEEKS. Some rows will only have one of the classes. I would like to end up with something like this. SELECT Datepart(wk, ompcreateddate + 84) AS week, CONVERT(VARCHAR, ompcreateddate + 84, 101) AS date, cmopostcode AS Zip, […] |
SQL Server 2019 - Administration |
Azure Data Studio and Jupyter Notebooks - Trying to install the PowerShell Kernel for ADS and it wont complete the download, this I am guessing is down to our policy to no longer allow connections to anything using the older TLS/SSL protocols, so it's blocking the download. Anyone know of a way I can force ADS to use a different version […] |
SQL Server 2019 - Development |
SSMS SQL Editor "shortcut in the current line" - My fingers were fumbling at the keyboard in the SSMS SQL query editor window, and I ended up with a little [->] icon in the gray gutter bar on the left (where break point icons show). I knew approximately the keys I was working with and searched the Web. On this page: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15 I found […] |
Reporting Services |
SSRS page footer doesnt go all the way at the bottom of each or any page - Hello, I have a report almost like an invoice, and i put a page header, and it works, always appears at the top of the ssrs report page no problem. THE PROBLEM.... i have a page footer, and there is a gap between the bottom and the invoice totals etc., i attached a screen shot, […] |
TextBox Property>Action>GotoURL for Multiple Values? - Hi I am using two stuff commands in my query. One gets the date of an action, there can be more than one and it was requested to have them strung along do it looks like 1/1/19,2/1/19,3/1/19 etc.... The other stuff command builds a url so the report can link back to the page for […] |
SSRS 2016 |
How to access SSRS out of network - Hi All, I and new to SSRS and have Installed and configured a Reporting Service in my client (Its working in my network and users can access it). I want to test it at first to find out if the users can access to my reports via Internet?(because the final server which is going to […] |
SSDT |
SSIS dtexec Error - The 'OraOLEDB.Oracle.1' provider is not registered. - Hi I am have one SSIS package that connects to Oracle and pulls the data. I am trying to execute this package using DTExec utility. "C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\DTExec" /ISSERVER "\SSISDB\\\.dtsx" /SERVER "" But I am facing oracle connectivity error "The 'OraOLEDB.Oracle.1' provider is not registered on the local machine." continuously. I have designed […] |
Analysis Services |
SSAS dimensions and measures to JSON - Hi, I am in a situation where my front end needs names/unique names for all dimensions(levels and members) and also measures/calculations. What is the best way to go about doing this? |
Strategies and Ideas |
Need help resisting falling back to dimensional/snowflake schemas - In a structure for an International business with a SalesOrder and SalesOrderLine, a data model needs created that answers these questions: 1. Show me which SalesOrders are in the sale region of South-East Asia 2. Show me the status of each sale order item. 3. Show me the total sales against each sales region compared […] |
Integration Services |
Import Active Directory objectGUID using .Net Provider for MS Directory Services - For a few years now I have been using SSIS and a ".Net Provider for OleDB\OLE DB Provider for Microsoft Directory Services" Connection in to extract Active Directory account information into a text file, so that I can cross check AD user accounts with accounts in older "downstream systems" that can't talk with Active Directory. […] |
SSIS - How to convert DateTime from ISO format - Hello, In my source file having DateCreated column as ISO format string like '2020-08-05T05:50:49.844Z'. I want to convert from ISO date string to DateTime2 in SSIS. Please advice best way to achieve this. Thanks, Sabarish |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |