|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Fully Indexing Views | |
I have an indexed view created in my SQL Server 2019 database. Can I create a full-text index on this view? | |
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) |
A Key-value Cloud Database Which Amazon product provides a key-value NoSQL database? Answer: Amazon DynamoDB Explanation: DynamoDB is the NoSQL key-value store. Ref: Amazon DynamoDB - https://aws.amazon.com/dynamodb/ |
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 - Development and T-SQL |
INSERT INTO Getting error on second record values - I am trying to create a table to use for testing. I have codded the script correctly based on many posts I have seen. It is giving me a error "Msg 102, Level 15, State 1, Line 21 Incorrect syntax near ','." I dont know what I did wrong. /****** Object: Table [dbo].[Temp_UnMatching_Mail2] Script […] |
Will insert process be blocked? - I am investigating a Query Timeout failure in our overnight batch. This is a simplified version of what has happening: The process that failed was trying to insert a row into a table (table_a): Insert table_a (col1,col2) VALUES ('Bah','Humbug') However, at the same time there was another process running which updated a different (table_b) but […] |
Setting a variable from a multi-table Select - Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10) = (Select Top 1 Op_Ref From [MyServername].[TemperTest_BATON].[dbo].Op Where Op_Forename+' '+Op_Surname = @CopyFromUserFull) However, the Op_Ref could be in any combination of 5 databases with thankfully identical schema, so I need to select against them, the following is as far as I've […] |
Administration - SQL Server 2014 |
how to find network issues for sql prod server? - Hi Experts, Is there a dirty trick or easy way to check network issues or slow network for the database server without using any 3rd party monitoring tool? Can we use continous ping from some quite non-prod server to prod sql server ? can we do that or is there a better way to do […] |
SQL Server 2012 - T-SQL |
SQL Server Cursor,change qty of a column when the time is starting from midnight - We need to update the qty when the timestart is from midnight only,anything before should change to midnight time and accordingly the qty value should change. |
SQL Server 2019 - Administration |
Master Data Services (MDS) - list of users permissions - Hi all, I'm trying to get a list of all the user/entities permissions for my Master Data Services, for example UserA-------------Model A ----------Entity 123------------------Read permissions. UserA-------------Model A ----------Entity 456------------------Write permissions. I found a couple of scripts which mention mdm.udpSecurityPrivilegesSummaryGet but it doesn't reallye do the job. So I wondered if anyone had any query or […] |
SQL Server 2019 - Development |
JSON building from configuration table - The attached file shows the json schema - defined levels and the bottom section shows the JSON needed to be built I want to write a TSQL query which can read the JSON schema and built the JSON shown Please advise Thanks |
build groups by finding specific "first and last records" - Hello, After receiving great help here, I am coming back for a little follow-up. I need to refine the previous question by adding an additional step which goes down to this: find the first "startSignal" in an ordered table and match it with the first "stopSignal" to form a group there can be multiple round-trips […] |
SSRS Changing Output Location to a different location - We are in the process of migrating a customer to our environment. This customer has a lot of SSRS Subscriptions that are writing out to a file share on a particular server. Is there a way to do a mass change so that the location can be changed to our Server's file share without having […] |
SQL Server Newbies |
Will my Query affect any rows in the DB?? - Dear All, Hope you are doing well. I am really new to SQL and was wondering whether anyone could just quickly confirm somethinng for me. I want write an SQL Query that would create an output which I want to export as a csv. I have already created the query which uses SELECT, CASE, FROM […] |
Will my Query affect any rows in the DB?? - Dear All, Hope you are doing well. I am really new to SQL and was wondering whether anyone could just quickly confirm something for me. I want write an SQL Query that would create an output which I want to export as a csv. I have already created the query which uses SELECT, CASE, FROM […] |
SQL Azure - Administration |
Azure VM backups, database snapshot backups - I have inherited two Azure VMs each hosting a marketplace SQL 2012 instance. Both VMs receive daily application-consistent VM backups. So far so straightforward. What I don't understand is that on one VM all of the databases show (on the logs and in msdb) as having snapshot backups at the same time as the VM […] |
Amazon AWS and other cloud vendors |
Drive Allocation with FSx - We're in the process of planning the migration of our whole platform into AWS. The current thinking is that we will host our instances on EC2 and use FSx as the file system. However, I can't find anything about whether a separate FSx instance is recommended for each drive needed by SQL Server. It's good practice to […] |
General |
How to practice OOP in C++ effectively? - I am currently writing a desktop application with Qt and C++. While I have learned some things about OOP from working on this project, I do not feel I am really using the full potential of OOP. I am not creating a lot of my own classes. I generally don't have an idea of what […] |
Replication |
Updating Transnational Replication with Publisher Schema updates - Hi, We have just incorporated 2017 Transactional Replication into our product for Archiving purposes. Schema updates are enabled. On each product update we run a set of Db Schema migrations (via application-hosted Fluent Migrator SDK) on the Publisher database. However, Transnational Replication does not support all schema changes. For example, adding Identity columns to a […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |