Question : Can you use a stored procedure as the source for Lookup Transaction because it seems to fail on […]
Tag: sql-server-2008-r2
Advisability of using STATISTICS_NORECOMPUTE
Question : I’ve recently become involved in maintaining a set of databases with some interesting index problems. One of the […]
Performing data update operations while backing up a large SQL Server database
Question : I have a large (in the tens of millions of records) database that I am going to perform […]
How to measure Key Lookups per Second on SQL Server
Question : I am working on reducing the amount of transactions doing key lookups on our SQL Servers. First I […]
Any reason for declaring a view with cross-database SELECTs for the same database?
Question : I currently have to take over an old project and found a single view that’s kind of a […]
SQL Server : Index Seek with very high Scan Count [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Connect to SQL Server using OLEDB or ODBC?
Question : We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead […]
Query to search for a substring in xml
Question : I use below query to search for a substring in whole xml(including node name and node value) SELECT […]
What could be preventing updates and inserts to a table without anything visibly blocking the process?
Question : The following has happened on more than one occasion. Updates or inserts to a certain table (I’m not […]
Executing sys.dm_fts_parser without sysadmin server role
Question : A web application needs to execute sys.dm_fts_parser to discover which words SQL Server Fulltext Search used to match […]