I’m after some advice.
I’m helping a colleague with a SQL Server 2016 database that …
1 day, 3 hours ago
Iam receiving the below error while exporting data from a database(xyz table) to XL file…
1 day, 19 hours ago
I'm looking into setting up a AOAG with a DR server which will have the option as NO for readable s…
3 days, 1 hour ago
By: Super Cat
MSSQL version: 2016 (13.0.5026.0)
Situation: Removed a database from an availability group so it co…
3 days, 14 hours ago
I'm trying to teach myself ExtendedEvents (trying to move from profiler).
I've attached a configura…
3 days, 15 hours ago
By: Grant Fritchey
I am getting this error on one of our servers and only when logging in remotely with a W…
3 days, 16 hours ago
I went to give a user (via AD account) datareader access to a number of databases. Everything seeme…
In on table which has CCI columnstore indexes on it, and I run
3 days, 19 hours ago
Just curious if there is a performance hit by having 4 tempdb files with a 2 core machine?
3 days, 22 hours ago
I'm attempting to run a query that captures all documents ordered of a certain type. The query can …
4 days, 13 hours ago
I have 2000 sp_locks processes and they are waiting on TransName = sqlsource_transform, METADA Res …
I have enabled CDC for a particular database in SqlServer and enabled it for multiple t…
4 days, 16 hours ago
We are facing an issue with one of the replication subscriber.
There were already two subs…
Joy Smith San
4 days, 20 hours ago
By: Joy Smith San
We are a product based company and using SQL Server as backend. Whenever there is a new version of …
5 days, 19 hours ago
By: Steve Jones - SSC Editor
I' have query running an avg 14 seconds every time it gets executed and I'm trying to find what…
6 days, 9 hours ago
By: Jeff Moden
Viewing 15 topics - 1 through 15 (of 2,090 total)
You must be logged in to create new topics.