|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Accelerated Data Recovery Editions | |
In SQL Server 2019, which editions can use Accelerated Database Recovery? | |
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) |
An R Loop What does this loop do in R? x <- 1:20 for (val in x) { if ((val %% 2) == 0) {next} print(val) } Answer: prints all odd numbers from 1 to 20 Explanation: This loop skips to the next iteration if a number is even, otherwise it prints the number from 1 to 20. This means all odd numbers are printed. Ref: |
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 |
Connection options to encrypted servers. - I've applied certificates and enforced encryption on two SQL 2016 SP2 servers. Using the same login credentials I can create an encrypted connection to one of the servers by selecting 'encrypt connection' in the connections options. With the second server unless I also select 'trust server certificate' I get a connection error: A connection was […] |
SQL Server 2016 - Development and T-SQL |
BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ whatsAAP : + 1(845) 243-3187? - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […] |
Parsing an XML field within a table - I am trying to parse a field that is XML in a table and insert into a table. Where would be a good example to do this> I have attached the values from that field in a notepad++ file. |
Sequencing query - Hello, I have a query regarding the best way to deal with a sequencing problem. This may be a little hard to explain. I have the following data (table and data script attached) where I need to regroup the depths columns by 1 foot increments and join the corresponding data which falls within […] |
Administration - SQL Server 2014 |
removing database from AG and putting it back in - Lets say a database was removed from AG for maintenance purpose. The primary node would have the w/r copy of it and secondary would have it in restoring state. What would be the best way to put it back in the AG again after maintenance? From primary --> add to AG and then join? |
Development - SQL Server 2014 |
BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […] |
get Actual backup file name from the sql backup path - Hey everyone, sorry, i am trying to get the actual file name accurately from the path, what i currently have is: E:\Backup\Server1\Database1\Database1_131983519013.bak and want to get just: Database1_131983519013.bak trying to use trim or left etc. but finding it difficult as some other database names might be longer or shorter, so its random, any idea how […] |
SQL Server 2019 - Administration |
SQL server for an oracle developer/dba - I have a few years experience developing with oracle and have now moved to a place where they use SQL server (2005). Where would be a good place to learn things like SQL Server query optimization, basic dba stuff and sql server gotchas for someone with my background. |
HA solution using mixed SQL Server on-prem and Azure SQL Server - trying to come up with an architecture for HA. I was thinking of using our on-prem SQL Server as primary, with Azure as secondaries. IT has mandated that putting everything in Azure is too costly, and we wanted to come up with a geo-replicated solution as our customers are all over the place. Does anyone […] |
SQL Server 2019 - Development |
Server is fast, then slow, then fast with no pattern - I am having a problem with my sql server running queries and using it in Visual Basic. The primary table I pull data from has 24 columns with 76,000 rows. Sometimes it takes less than 6 seconds to run the query. Other times, it takes over two minutes and once in a while, it stops […] |
Reporting Services |
Add more space below report totals - Hello, First off I am sorry if I'm posting this in the wrong area. I hope I'm not I've search endlessly to try and find this answer. Even on here. Probably using the wrong words. How can I add more space below the bottom of my reports. When I run the report, I need […] |
Integration Services |
save mutiple ssrs reports from a ForEach loop into a single file - Hello, I have a client who has a letter run that is produced monthly using a combination of SSIS and SSRS. In short, a foreach loop passes the parameter intothe ssrs report and usinga C# script task generates a PDF into a windows folder. They are asking if I can alter the process so that […] |
Design Ideas and Questions |
SQL newbie, question about primary key. - Hello, SQL newbie here. I've got a question about the proper use of primary keys, hoping someone can help out. Let's say I establish an HR database and decide that, since Social Security numbers are unique and non-repeating, I'm gong to use SS numbers as my primary key. Something like this: Name, Title, Social_Security_Number Joe […] |
The Future of Community |
Is there room for independent SQL or Data Integration based User Groups? - So I live in a smaller community with no real User Group presence of any kind, and though when SQL Saturday events were still in person the nearest one near me is 2 hours drive. Now during pandemic I doubt we'll see any return anytime soon, so I was wondering if there's room to try […] |
Article Discussions by Author |
BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ - BUY 100% UNDETECTABLE COUNTERFEIT MONEY £,$,€ We are here to help our customers get the best quality undetectable fake money for sale without having to leave the house. Firstly, our prices are comparatively cheaper than you thought. More so, our focus is on the quality of our fake money and the timely delivery of our […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |