Questions tagged [sql-server-2012]
SQL Server 2012 (major build version 11.00.xxxx). Please also tag sql-server.
4,534 questions
2 votes
1 answer
83 views
Upgrading SQL Server 2008 SP3 to SQL Server 2022 Best Upgrade Path and Licensing Questions
I have a requirement to upgrade several SQL Server 2008 SP3 databases to a new environment on new servers running SQL Server 2022. As per Microsoft’s documentation, SQL Server 2008 cannot be upgraded ...
0 votes
1 answer
88 views
Split columns into hierarchy
I have a table that is structured in the following manner that we have imported from another source into SQL Server: Tier 0 Tier 1 Tier 2 Tier 3 AA;AB;BB T1A;T1B T1A2A;T1A2B;T1B2A T1A2A3A;T1A2B3A;...
- 119
5 votes
1 answer
426 views
What is a good way to handle an error while parsing a T-SQL command that doesn't exist on an older version of SQL Server?
I am trying to grant the [CONNECT ANY DATABASE] permission to a specific SQL account on multiple instances. However, one server is running SQL Server 2012 and that permission was not introduced until ...
- 119
0 votes
2 answers
270 views
Cannot shrink log file
I cannot shrink a log file, for a database that is in Simple recovery model (used to be in Full , and was changed to Simple). I have tried every solution I can find on the internet, even the mighty ...
- 1,025
1 vote
1 answer
123 views
Does Postgres have anything analogous to Microsoft SQL Server's Batch Mode?
In traditional usages of Microsoft SQL Server, exactly one row flows from one operator in a query plan to the next. In Batch Mode, huge performance gains are obtained by moving thousands of rows at a ...
- 1,322
2 votes
1 answer
110 views
SQL Server Database I/O Consistency Error Disaster Recovery
I have a corrupted SQL Database that is inacessible by any means. It is to the point that simple commands, like USE MyDatabase, won't execute. The error I get is: SQL Server detected a logical ...
- 23
1 vote
0 answers
145 views
sp_send_dbmail fails when query is included
I am running SQL Server 2022 Enterprise inside a company domain. I have a SQL Agent job that runs a stored procedure. The job runs under a domain account say 'domain\myuser' that is a member of '...
- 167
-1 votes
1 answer
185 views
Delete operation taking time from SQL Agent Job
I am running a job which deletes data from 7 tables, 2 of which contains 1-2 million records. But the job gets stuck at a point when deleting data from web_activity table which holds only 42 000 ...
- 1