|
|
|
|
|
|
|
Question of the Day |
Today's question (by Steve Jones - SSC Editor): | |
The Double Table | |
I have this code:
CREATE TABLE dbo.DoubleTable ( myid INT NOT NULL CONSTRAINT DoubleTable PRIMARY KEY , Val VARCHAR(20)); GOWhen I run this, I get this error: Msg 2714, Level 16, State 5, Line 19 There is already an object named 'DoubleTable' in the database. Msg 1750, Level 16, State 1, Line 19 Could not create constraint or index. See previous errors. Why? | |
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) |
Azure Dataset File Formats As of May 2021, which of the following file formats does Azure Data Factory not support? Answer: YAML Explanation: YAML is not supported at this time. Ref: Azure Data Factory Connector overview supported File Formats - https://docs.microsoft.com/en-us/azure/data-factory/connector-overview#supported-file-formats |
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 |
SQL Server Agent Jobs are not logging history - A few days ago, my SQL Agent Jobs stopped logging to the history table. They don't show up in view-history and they are not in the sysjobhistory table. I do limit to 10000 rows with max 500 rows per job, but I've also tried not limiting it at all. The SQL Agent servers runs under […] |
SQL Server 2016 - Administration |
Table Size out of control.. - In the dev environment there is a table that gets loaded with verbose log data by a DOT NET app. The only thing that I care to retain in that table are entries designated as ERROR level entries. There are a total of nearly 2 million entries into this table every hour. What do you […] |
Updating MDS on SQL Server 2016 without updating DB engine? - Hi, I am currently investigating removing the need for Silverlight for MDS on a Shared SQL Server 2016 instance I have just inherited. I have been asked to do it as soon as possible. In my research this morning, I have found the following documentation: Upgrading Master Data Services, which specifies an upgrade path without […] |
New Index Maintenance Methods Recommended by Microsoft - With reference to the following MS article... https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15 That article was where the old "Best Method" recommendation of Reorg between 5 and 30% and Rebuild at > 30% fragmentation used to live. You can verify that by doing an "edit" on the page and looking for where they made the change on lines 73 thru […] |
AG is continually reporting failover due to mirroring connect error - Hello experts, I'm seeing this Always On Availability Group behavior around every 5 minutes. And it is not like the AG is moving back and forth - it is always saying it failed over the BARDB02. The AG group FOOAG01 failed over to BARDB02. In the SQL error log, I see this error, which I […] |
Removing "to Disk" Backup Files - Hi, I am taking our SQL servers and changing the way we back things up. Right now we use ola scripts to go to disk. We are now going to use a 3rd party tool to take over the backups. Questions Besides trans log shipping, is there anything that SQL Server would use the backup […] |
SQL Agent output to file - What would the preferred method of outputing a cmdexec step? cmdexec enter: d:\jobs\myjob\step1.cmd > d:\jobs\myjob\step1.log 2>&1 2. go to advanced page and enter output file there? |
SQL Server 2016 - Development and T-SQL |
Routine to Limit Query Results and Output to a File - Dear Group: Please note: I can only use solutions that involve SSIS and/or Stored Procedures due to limits placed on our team and environment. As much as I understand and agree there are better solutions, we are limited to only things that involve SSIS and commands that can be executed inside a stored procedure. We […] |
SQL 2012 - General |
MSSQL 2012 -> MSSQL 2019 -> MSSQL 2012 - Older version of Database - Hi, I migrated a Database from MSSQL 2012 to MSSQL 2019 and that's supported. But, now i got this ingenious idea of migrating back from MSSQL 2019 to MSSQL 2012 since i made some changes in the database. SQL 2012 Version: Microsoft SQL Server Standard (64-bit) Version 11.0.7507.2 SQL 2019 Version: Microsoft SQL Server Enterprice(64-bit) […] |
SQL Server 2012 - T-SQL |
datetime column, Day of Week with count, how to add month/yr grouping - SELECT count(*) ,DATENAME(dw, [myDateTime]) as DOW FROM [myDatabase].[dbo].[myTable] group by DATENAME(dw, [myDateTime]) this gets me what i need for like a total for day of week but what would i need to do in order to get like a grouping by month, DOW, Count and a grpuping of Year, DOW, count currently i get DOW, […] |
SQL Server 2019 - Administration |
error when using date column with remote oracle table - I realize this might be out of scope for the forum but figured it's worth a shot... I have a process where I copy data from a table in our local SQL Server instance to a remote Oracle table via Linked Server. I can do the INSERT without any issue at all. I can also […] |
SQL Server 2019 - Development |
How to extract date from a long string - Hi All, have a long string like below in my column and I need to extract only the date (2021-07-05) from it. Could any one please help Name - Koteswararao vp Department - Prod Location - Hyderabad Domain - ND Job Title - Technical-ABAP Date of Hire - 2021-07-05 Vendor ID - v2345 Candidate ID […] |
SQL Azure - Administration |
Migrate On-prem DB - Hi Experts, Is there anyway to migrate database with filestream to SQL Managed instanace? Will Azure database migration service will help to achieve this task? TIA |
General |
Index frangmenting - Good day, What would cause fragmentation on the Unique Clustered index on a table (its one and only index) that is only ever read from, and never written to? Thanks, P |
SSDT |
Having users access .dtsx (package file) saved on LAN - Hello All, I created a package file (.dtsx) via SSDT. I took the folder containing this file and placed it on a shared drive, with the other associated files there as well (see attached image). The package is being executed from an excel file via this command, dtexec /File \\path\to\file\filename.dtsx; The file executes for me […] |
| |
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com |