|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Stopping a Container | |
I have a SQL Server 2017 container (named sqltest) that was created with the docker run command. I connect to the container and add a login. I then run this:
docker stop sqltestThat afternoon, I come back to my workstation and run docker start sqltestWhich of these describes the status of my login? | |
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) |
Checking on IFI I am connected to my remote SQL Server 2017 instance with SSMS and want to quickly check if Instant File Initialization is enabled. What is the easiest way to do this? Answer: Query sys.dm_server_services Explanation: There are different ways to find this, but sys.dm_server_services is the easiest. This information is not on the General tab and sys.dm_configuration doesn't exist. You can read the registry, but that is not easy. Ref: sys.dm_server_services - https://docs.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-server-services-transact-sql?view=sql-server-2017 |
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 |
2012 - 17 Performance Issue - Good afternoon everyone, This may sound familiar, but we are yet to find a solution. We are in the middle of a platform upgrade from 2012 - 2017 utilising some vastly superior hardware. However we have found that performance has degraded, rather than the expected improvement on the tests so far. For example, when […] |
SQL Server 2017 - Development |
Datetime data migration. - Hi All, We are loading data from one of our source table in that table createddate column datatype is char(22) and value is 2012-06-03 04:11:49:16. And in my target table the column datatype is datetime and we are using convert datetime function to convert char to datetime. But the date is converting to 2012-06-03 04:11:49:016. […] |
Always Encrypted with SQL Server Data Project - Hi, We have a small database (just 3 tables) where we wish to use Always Encrypted to encrypt the data in a few of the fields in each table. I've managed to successfully encrypt the data using the SSMS wizard and powershell scripts, and I can read/write from our application. I'm now looking for some […] |
SQL Server 2016 - Administration |
Change SQL Agent service account and password on 2 node active-active cluster - What are the steps to change SQL Server agent service account and password on 2 node active -active. Thanks in advance. |
SQL Server 2016 - Development and T-SQL |
Gathering Business Requirements and Determining Database Schemas - What is simplest way to go about gathering business requirements and determining database schemas? |
insert into permanent table using cte - Good morning all I would like to add the result of a multiple query in a table the goal is to have this formathere is my request ;with cte as ( blablablab ) INSERT INTO newtable select * cte here is my request with echantillontemp as ( select Ref_Contrat = v.Contract_ID + '-' + format('0'+ […] |
Administration - SQL Server 2014 |
assist needed for the SQL Server dump - Hi Guys, I got 14 dumps in last two days, I tried to use WinDbg to check what is going, but I don't get a clear information from the output, can anyone help pinpoint the cause? I know it is very likely failed at sqlmin!CChangeTrackingDatabase::CleanupNextTable+711, but not sure is it failed at specific database, or […] |
Development - SQL Server 2014 |
A bit of mathematics... - Hi all, I'm just doing some work on my own bank statements imported from CSV. Two salient columns, MoneyIn (int), MoneyOut (Int). This is the formula I'm trying to calculate: ((Revenue - Outgoings) * .81) - Dividends Paid = Result I've been able to Select (Select Sum ([Money In]) As 'Revenue' from SmytheData.dbo.Transactions3) - […] |
Need Help: On Query with Case Statement - Hi, As part of development task I have to write a SQL logic for the below 6 scenarios, I have achieved desired result in my query using Case Statement but I want to know is there any other options(ways) where I can write query without using Case Statements to achieve the same result using sub-query […] |
SQL Server 2012 - T-SQL |
Question on triggers - Hi, I have, as most triggers are, a single row trigger; that is it will only update one row, and that works fine. However, someone now runs a SQL Query that updates multiple rows at once, and I have not been able to see how to get this to do both. Here is the trigger […] |
transactions(Try, commit and rollback) - Ignore post |
Reporting Services |
Moving from RDL to RDLC files in SSRS - For any custom reporting in an accounting software program m,y company uses we have to use the RDLC flavor of SSRS reports. I can find numerous tools, tips, samples, you name it for SSRS reports that use the RDL file but the RDLC is almost non-existent. Does anyone know if there is a way […] |
Pull dynamic reportpath of RDL into SQL inside the RDL. - Hello, Long story of not best practice that I have inherited and am slowly trying to change. (No judgement please). I have a set of approx. 1000 report server reports that have SQL embedded in them (Insert sad face). Some of the reports are locking each other and sometimes taking down databases. My idea is […] |
SSDT |
Value of extended property in T4 script returns a quoted, escaped string? - Hi, I have a T4 script which reads extended properties. The value of these properties seems to be escaped. Example: I have a table person with an extended property called propertyName that has the value propertyValue. When I read this value I get: N'propertyValue'. The value that appears in the T4 script is the escaped value. […] |
Integration Services |
how to check if file contains only column headers without data - Hi All, i have a task to check file (excel & text) before loading to a table. checking condition: if file only contains header(columns) without any data then fail the file. I have filename & source file path variables already - any idea how to handle this in script task? much appreciate! |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |