|
|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
Connecting to Localhost with the new sqlcmd | |
I want to use the new sqlcmd, written in Go, to connect to my local SQL Server instance using localhost. I do not want this to fall back to the old sqlcmd. How can I do this and query AdventureWorks. | |
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) |
The MI Startup Time I can stop and start an Azure SQL Managed Instance. As of Mar 2023, with this feature, what is the estimated startup time for a Managed Instance that is stopped? Answer: 20 minutes Explanation: The estimated time to start a stopped instance is 20 minutes. Ref: Stop and start an instance (preview) - Azure SQL Managed Instance - https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-stop-start-how-to?view=azuresql&tabs=azure-portal |
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 |
Populate fields where CSV Sting has data matching given Column name - Given multiple ROWs comprised of varying combinations of Comma delineated values and an ID. Given a TABLE whose COLUMNS names are a comprehensive compilation of the (SPERATED/PARCSED) delineated values existing between all ROWs. Populate the given TABLE by looping through the COLUMN names and PARCING a given ROW for a delineated value that MATCHES a […] |
sql time zone conversions - hi folks i need to convert a date/time field between two time zones the date/time stamp is in GMT Standard Time +01:00 which is correct but i want to convert it to UTC +00:00 - as the app we are using wants to manage the time series data and zones so 2023-04-05 23:59:43.410 GMT should […] |
SQL Server 2016 - Administration |
How to view actual execution plan, for long running jobs? - I have a couple of very long running jobs which are scheduled by SQL Agent. These jobs are doing archiving task & runs to several hours. I would want to view the execution plan for the jobs to see what can be improve. May I know how can I view the actual execution plans for […] |
SQL Server 2016 - Development and T-SQL |
Index Spool Eager Pool issue - I have an archiving job running on our production database which will move old datas from an existing production DB to another archiving DB running on the same box. The job utilize on MERGE INTO operations to do the archiving. This job isn't a new job and has been running for quite some time. Users […] |
Development - SQL Server 2014 |
Dirty Reads with Read Committed? - Hey everyone! I have a SQL agent job that deletes data then inserts data into the same table hourly. Both the delete and insert command are wrapped in the same Begin/Commit/Rollback Transaction statement and the process takes about 30 seconds to complete. I have another job that on occasion reads data during this update and […] |
SQL 2012 - General |
SSL Certificate - Hi.. SSL certificate has been installed in our standalone and cluster servers . and from Registry Editor , I can see the Certificate number and force encryption is zero ( screenshot is attached) Yesterday after the restart our standalone server , I can see Message in error Log as below : The certificate [Cert Hash(sha1) […] |
SQL Server 2019 - Administration |
Configure replication with Always-On (Basic Availability group) - Hi Folks We have configured Basic Availabilty group and now we need to configure replication . Scenario is this sev 1 and sev 2 are in basic availability group. Database is sev1 would initially act as publisher .sev3 would acts as subscriber and our distributor database would be on remoter server sev4. So i would […] |
How to run SSMS as non Admin and restart Services - I have a user that needs full access to a specific instance on our SQL Server (2019). I do not want this user to have local or domain admin prividleges. I have gotten SSMS on his pc and have given him a domain account (localAdmin1) to use that does have local admin prividleges on his […] |
Move SQL Server users from one RDS for SQL Server instance to another - Hi, How can we move SQL Server logins from one RDS for SQL Server instance to another ? |
Restore further T-Log Backups - Hi, is it possible, to restore more t-log backups, after I restored the database? We got a problem, and we had to restore the database, then check the table in the database. Maybe we did the point in time restore to early, and I'd like to restore some more t-log backups, without the restore of […] |
Blocking alert - Hi All, I am trying to capture and set up alert for blocking when it goes more than 30 seconds. Is the following correct OR maybe i need to do with wait time. select @@servername [SERVER],sp.spid,sp.blocked, (CONVERT(DATETIME,CAST(sp.last_batch AS CHAR(8)),101)) as last_batch,sp.waittime,sp.waitresource,sp.lastwaittype,sp.cmd, sp.dbid, sp.loginame,sp.hostname,sp.cpu from master.dbo.sysprocesses sp where sp.spid>50 and sp.spid<>sp.blocked and sp.blocked<>0 and datediff(Second,last_batch,GETDATE())>30 0 […] |
SQL Server 2019 - Development |
Index help - Performance issue - This table contains contains 127 M rows and growing. We are starting to see some performance issues on any query that touch this table. There is a columnsotore index on it including clustered and several non-clustered indexes. Do you notice duplicate indexes and/or t wide indexes? Any suggestions on what can be removed or […] |
Employee count based on target date - I have table for employee activity with the following fields: [Emp ID] , [Hire Date] , [Term Date] , [Mod Date] , [Old Div] , [New Div] When an employee is hired, [Emp ID] is filled, [Hire Date] is filled with the current date and [Old Div] and [New Div] are filled with the division […] |
how to get previous year and current year data in coma separated values in sql - Hi Team, I have data like below and expected output is like this. --Expected o/p --Jan-2022,Jan-2023,January-2022,01-01-2023,Jan-2023,Jan-2023 Can you please help me on this. USE [Tempdb] GO /****** Object: Table [dbo].[tempIssueRange] Script Date: 09-05-2023 18:53:12 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[tempIssueRange]( [IssueID] [int] NULL, [IssueName] [varchar](110) NULL, [IssueDate] [date] NULL […] |
Azure Data Factory |
Monitoring ADF best practices - All, I know that within Azure Data Factory, there is a great monitoring section to see what was successful, what failed, and you can get super granular with this and dig into individual runs. My question here is, can we integrate these logs with Azure Application Insights? If so, has anyone done this and […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |