New answers tagged

1 vote
Accepted

Resource Governor and Resource Pool CPU Utilization Configuration

Question 1 Do user defined resource pools consider the default pool in their calculations? Yes, they do. You can verify it by editing the minimum CPU for the default pool and trying to add another ...
user avatar
  • 4,429
3 votes
Accepted

Can't create MS SQL Server trigger

Namespaces are confusing and not well documented in SQL Server. In your case, there will be another schema-scoped object in the database with the same identifier as the one you are hoping to use for ...
user avatar
  • 71.3k
0 votes

I can't create a Database after I uninstalled SQL Server and then reinstalled SQL Server

A SQL Server database consists of data files .mdf and a log file .ldf The paths to these files are specified when creating a database: The error you get means that a data file with that name already ...
user avatar
1 vote
Accepted

I can't create a Database after I uninstalled SQL Server and then reinstalled SQL Server

It seems that the database files for the SSIS database have remained in place after the uninstall. I believe user database files are not deleted by the uninstall process (presumably by design) and as ...
user avatar
  • 1,379
0 votes

Fresh SQL Server 2019 can't query Excel files

If you want to know which version of ACE.OLEDB is installed, you just need to check the folder in the picture below: you can also use this query to check: EXEC sp_MSset_oledb_prop, this will list all ...
user avatar
  • 144
6 votes

Find and show special character codes from nvarchar column

If you can live with one-for-one character replacement, use the TRANSLATE function. For example: DECLARE @T table (c1 nvarchar(50) NULL); INSERT @T (c1) VALUES (N'Hello' + NCHAR(9) + N'there' + ...
user avatar
  • 71.3k
3 votes
Accepted

REPLACE() function accepts and returns non-character data types

To add onto what Erik stated in his comment, it doesn't matter what data type you want to explicitly define your parameter as, the definition of the argument inside of the REPLACE() function is ...
user avatar
  • 24.8k
4 votes
Accepted

SQL Server can't create sysname type colunmn

The table designer is very limited and has a number of unresolved defects. Most professionals choose to write T-SQL CREATE TABLE statements instead. You will have noticed sysname is not available in ...
user avatar
  • 71.3k
0 votes

MSSQL Listener issues

Ok, so I have found a fix I guess. As we all know Microsoft AD creates DNS records dynamically. I tried recreating these as static records with PTR checked but not "allow any authenticated user ...
user avatar
0 votes

New DB: Best settings for a BI staging area

Not really, and FWIW ~5 million rows added every year is not that huge of data. From a performance perspective it's really just going to depend on your specific use cases in BI and how you architect ...
user avatar
  • 24.8k

Top 50 recent answers are included