|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Changing the format for a date | |
I have today's date stored in a variable:
DECLARE @d DATETIME = '2021/02/22'How can I get this in the format dd.mm.yyyy and returned to the client as a string? | |
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) |
Setting Git flags for all repos What should I add to "git config" to ensure a change takes effect for all repos? Answer: Use the --global flag Explanation: The default writes to the local repo. The --global flag is used for affecting all repos. Ref: git config - https://git-scm.com/docs/git-config |
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 |
Extended events query plan - All, Firstly apologises as I'm sure I'm missing the obvious but I've searched and I can't work it out. I have setup extended events and included both the plan_handle and query_hash actions. I'm retrieving the results with the following: set dateformat dmy SELECT n.value('(action[@name="query_hash"]/value)[1]', 'nvarchar(128)') as query_hash, n.value('(action[@name="plan_handle"]/value)[1]', 'nvarchar(max)') as plan_handle from ( select cast(event_data […] |
SQL Server 2017 - Development |
Error number 2812 Store procedure not found - Hi Expert, Have migrated database 'northwind' from Server A to Server B Server A Configuratioun- ms sql server 2012 developer edition 64 bit windows nt 6.1 build 9200 Server b configuration -ms sql server 2012 standard edition 64 bit windownt 6.2 service pack 1 hypervisor I am able to run the store procedure on […] |
SQL Server 2016 - Administration |
Migrate from AWS SQL Server RDS to EC2 - Hello, I could not find any documentation on how to migrate SQL server RDS to an EC2 instance. I have a requirement to migrate a large DB to ec2. Can anyone help me with the steps to migrate the DB with low downtime, please? Thanks in advance |
Dynamic Data Masking and Adhoc queries. - This is the first time we are implementing this, Data Masking that became available in SQL Server 2016. I am not sure that this is a best Data Masking solution though. Because documentation says that a non-privileged user can run an ad-hoc query, using some functions like CAST, and data becomes visible. Is my understanding […] |
Availability Group Help - I had something occur with my availability groups that has me concerned. My primary failed on me, due to the inclement weather and ice storms, the ISP lost connectivity and will be down for some time. But my secondary didn't failover and handle the traffic. Instead, I found it in "Recovering Mode" and when I […] |
SQL Server 2016 - Development and T-SQL |
Question related to architecture - Hello Fellow DBA friends, Currently I am working on a project where a system has to be migrated to our system. I just want to know whether I should go with creating a new DB schema for its objects in current database or should I create a new database altogether ? What are the specific […] |
Preventing duplicate execution plans - Hi all, Our application has some parameterised dynamic SQL that looks like this; SET NOCOUNT ON; DECLARE @HOST VARCHAR(500); SELECT SOME, STUFF FROM MYTABLE WHERE MAINHOST = @HOST OR BACKUPHOST = @HOST When I look at the execution plan cache it is caching an execution plan every time this is executed because it is defining […] |
Administration - SQL Server 2014 |
Who modified my Database? - Hi, we have an issue where entire cubes are sometimes deleted from our SSAS database. I am assuming a human has done this, but I cant find any way of determining who did it or when it has happened. Does anyone know where (if at all) Database schema modifications would be logged? Thanks! |
SQL 2012 - General |
How to get PartId from table #trades where it have parts that have only map from - I work on SQL server 2012 I have issue I can't get Part Id that have only map code type from and code value from and not have map code type to and code value to depend on table #map ? every part id must be found on table trades two times first row for same part […] |
SQL Server 2019 - Administration |
Subscription owner and multiple subscriptions - We are using reporting service 2019 Enterprise. There is an issue with running the subscription the other people created. For example two user are both content manager role. And the first user created the subscription, and she becomes the owner of the subscription automatically. She runs the report with no problem. But when the second […] |
SQL Server Standard Edition - Hi All Hi have a problem and need help I am out of ideas on this one. I am managing my company's Production SQL Server, there are 30 Databases I need to maintain. Specs of the server: Windows Server my TEMPDB does not want to release the unallocated space and it's getting to a […] |
SQL Server 2019 - Development |
Vague job scheduler support for SQL Server on Linux - I’m having some trouble figuring out the kind of support for Linux that the SQL Server 2019 job scheduler has. It’s clear that the job scheduling procedure API, and SQL Server Agent have both been ported to Linux and appear to work. But there are a limited number of kinds of job steps supported. These “kinds” of […] |
SQL query to find last date a product was checked before it was installed - I have two tables, one covers jobs for a product and the other covers the last time a product was checked over and by who. What I am trying to do is get the most last date the product was checked before it was installed. There is no set time period that the check could […] |
CLR Integration and Programming. |
Problem programming with clr - I have created a project in visuall C ++ version 2008 of clr type called calculat and I have a text box and a button in the form. When I click on the button, its click event is activated in the form1.h file and I want to This event calls a function called compare that […] |
The Future of Community |
We need to move beyond SQL Server... - I think we should have a discussion about topic. First, the future is more data. SQL Server is just one place it is put. We need reflect the needs of our customers and prospective clients. How do we get there? We do SQL Server now and add others annually. Postgres, MySQL, Oracle and Vertica have […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |