Question : I’ve created a full-text index on a non-persisted computed column in a table (details here). However, every couple […]
Category: SQL Server
Can sp_executesql be configured / used by default?
Question : I am looking at an application that uses highly dynamic sql queries against SQL Server. Looking at the […]
SQL Server Query Store – why does it not always use the forced plan? [duplicate]
Question : This question already has an answer here: Strange behaviour of force plan in query store (1 answer) Closed […]
Feasibility of a MSSQL Read Only Replicas as ephermal containers?
Question : Kubernetes tends to get more complex to work with when persistent state becomes a concern. Therefore it can […]
How many cores are used for serial plans in SQL Server?
Question : I understand that a parallel plan will use (at most) as many cores as set up in MAXDOP […]
Working out Duplicated Data in a Customer Data Base
Question : I have a database in SQL2008 of customers, There is an ID number for the customer. What im […]
Determine free space on “nonfixed” drive
Question : I am writing a stored procedure that needs to send an email when a dvd rw drive is […]
Batch Requests/sec reported by DMV millions of times larger than Activity Monitor
Question : I have verified through SQL Server Profiler that my request per-second are around 30 request/s as is corroborated […]
Updating a table which contains an Image datatype column
Question : I have a table which contains a few columns, one of which is an image datatype, this is […]
Aggregation GROUP BY bottleneck
Question : I have a performance bottleneck with a SELECT GROUP BY operation. Schema I have a table like this: […]