Topics
Started by
Posts
Last post
Hi all We've got a linked server from SQL 2016 to an accdb database file (2016, I think). &…
1 replies
Hello experts, A developer reported this error when trying to query a DB: invalid object ERROR o.h.…
1 replies
Hi In one of our servers the t-logs of one of the database which is in full recovery mode and with …
3 replies
Hi, One of the user databases was in Not synchronizing / In recovery mode. The root cause was the s…
1 replies
We have no prior experience of using XE. Yes, our DBA group uses server side traces, sp_whoisactive…
1 replies
Dear all, I have the following questions about SQL Server Always On: How does SQL Server copy data…
2 replies
Hi All We have a DB for reporting which has tables which are more than 5 TB in size. As the busines…
24 replies
One of the developers wants to introduce horizontal filters in a new transactional replication setu…
1 replies
There was a 5 minute periods of time the other day when the lasting blocking (chains) caused by 1 s…
4 replies
Hi 🙂 I'm trying configure best backups pratices in Windows server 2019 using sqlcmd in Windows Sche…
1 replies
Hello, Can someone help me with code for sql backup for big database in 4 steps so it will n…
7 replies
Hello , I will proceed to install SQL server 2016 after deleting SQL server 2008 properly I saw sev…
3 replies
Hi, This is an Index Seek which is 60% cost of the query. Now, I see there is a big difference betw…
3 replies
Hi, The below view is using cross join and as far as I know, Cross join is not good for performance…
2 replies
Does it make sense, for query performance gains, to BOTH apply Data Compress (eg Page Compression) …
7 replies
Viewing 15 topics - 511 through 525 (of 3,312 total)
You must be logged in to create new topics.