Stack Exchange Archives - Page 2 of 9 - Andy M Mallon

SQL Server service – Not Starting With Automatic Startup, “The system cannot find the file specified”, but starts fine manually

October 29, 2021 Andy 0

Question This is a weird one, and I’ve run out of ideas for how to go about troubleshooting this. Here’s the issue, best as I can sum it up. The SQL Server engine and Agent services are not started when the server first boots when … [Read More]

Are Basic Availability Groups a reliable HA solution without integrity checks on the secondary replica?

October 26, 2021 Andy 0

Question We have a few Basic Availability groups in production and I’ve been reading about the limitations of them. I’m concerned about the following limitations: No backups on secondary replica. No integrity checks on secondary replicas. Suppose that we haven’t failed over in months. In … [Read More]

Why are there no “Daylight Time” time zones in SQL Server?

October 21, 2021 Andy 0

Question I am converting the times of some datetimeoffset columns from UTC to Eastern. I am doing this via the command This seemed to be working correctly (times were shifted 4 hours earlier and now have a -04:00 offset, exactly what I wanted), but then … [Read More]

How do I put the result of stored procedure in a new column in a view?

October 17, 2021 Andy 0

Question I have created a stored procedure which takes as inputs a schema name and a table name and outputs an INT containing the largest value in the id column of the table. I have also created a view containing all the schema names, table … [Read More]

Can I use both Log Shipping and Transaction Replication at the same time?

October 15, 2021 Andy 0

Rich Vieira asks about the feature compatibility of using AlwaysOn Availability Groups and Replication on the same database.

Identify how many CPUs our database server is using

September 9, 2021 Andy 0

Question Our server where the Microsoft SQL Server 2016 Web Edition server is installed is running very slow. We are thinking of increasing the number of cores licensed on it. However, we need to check how many CPU cores the database is using currently. Our … [Read More]

Function to create SQL TABLE does not works well using Powershell

September 2, 2021 Andy 0

Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties … [Read More]

Azure Data Studio – Intellisense does not detect tables, yet queries work

August 23, 2021 Andy 0

Question I’m breaking some new ground and trying to get into Azure Data Studio. I’m having a problem with intellisense that seems to be a bug with Azure Data Studio but I’m not sure. I have issues with basic queries. Foreign keys, select statements and … [Read More]

Identify all tables with an identity column

July 2, 2021 Andy 0

Question Is there a query I can run that will show me all tables with an identity column? Trying to figure out if there are any identity based tables whose current identity is nearing upper bound of int32 or int64. asked 2021-07-02 by user2368632 Answer … [Read More]

SQL Server 2012 equivalent of AT TIME ZONE capability

June 30, 2021 Andy 0

Question Is there a way in SQL Server 2012 to get what the server time zone would be on a particular date/time? In SQL Server 2016, you have AT TIME ZONE, but that’s not available in 2012. I have a datetimeoffset and I need to … [Read More]