Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: sql-server-2008-r2

Stored procedure in SSIS Lookup Transformation Editor

By adminPosted on February 7, 2023

Question : Can you use a stored procedure as the source for Lookup Transaction because it seems to fail on […]

Advisability of using STATISTICS_NORECOMPUTE

By adminPosted on February 6, 2023

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

By adminPosted on February 6, 2023

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

By adminPosted on February 6, 2023

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?

By adminPosted on February 6, 2023

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]

By adminPosted on February 6, 2023

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?

By adminPosted on February 6, 2023

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

By adminPosted on February 3, 2023

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?

By adminPosted on February 2, 2023

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

By adminPosted on February 2, 2023

Question : A web application needs to execute sys.dm_fts_parser to discover which words SQL Server Fulltext Search used to match […]

  • 1
  • 2
  • 3
  • …
  • 221

Recent Posts

  • postgresql grant user privilages to dynamically created tables
  • How can streaming replication be kept lagged by a certain ‘delay’ time?
  • Query for similar syllables on a field
  • Write filename, servername/IP and date+time in spool file
  • Designing a table with multiple null FKs
  • I am trying to get the string between hyphen (-) which is before (+) upto next colon (:)
  • Why would a SELECT INTO cause an arithmetic overflow?
  • Possibility to implement time to execute / TempDB usage restrictions on some role groups in SQL Server?
  • Login failed for user – Error 18456 – Severity 14, State 38
  • comparing two values in same column with another column using AND condition
  • Slow running aggregate of aggregate query
  • Is it possible to get seek based parallel plan for distinct/group by?
  • PostgreSQL replication: out-of-sequence timeline ID, when former master made slave
  • Autogrowth Analysis in PROD DB based on the trace file data
  • Single versus Multiple databases
  • Does a user who has permissions to select from a view also need select granted to the children entities of that view?
  • Parse a string to find data between delimiters, multiple occurrences
  • Oracle multiple databases on same server [closed]
  • Help to create indexes to improve query performance and reduce report generation time
  • Error while granting select privilege

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding