SQL Server Database Engine

• , Registry information is corrupt or missing. Make sure the provider installed and registered correctly. [SQLSTATE 08001]
• .MDF file is growing daily by 1-2 GB, How to fix it
• 'Could not allocate space for object 'dbo.SORT temporary run storage'
• "CACHESTORE_SQLCP" using 11GB in Whole SQL Server memory...how to resolve from memery bottle neck ?
• "Fetch Next from" very slow
• "Internal Query Processor Error: The query processor encountered an unexpected error during execution."
• "KILL command cannot be used inside user transaction"
• "No Transaction Is Active " Error running SQL Server 2008R2 Stored Procedures with Transactions that call back across Network
• "Repair statement not processed. Database needs to be in single user mode."
• "The initial snapshot for publication is not yet available" after dropping article SQL Server 2005
• "Unknown Token" in activity monitor under Command - process hangs indefinitely
• "with recompile" versus "option(recompile)"
• “ERROR [08S01] [Microsoft][SQL Native Client]Communication link failure”
• [298] SQLServer Error: 258, Shared Memory Provider
• [298] SQLServer Error: 258, Unable to complete login process due to delay in login response [SQLSTATE 08001
• [298] SQLServer Error: 9001, The log for database 'tempdb' is not available.
• [Microsoft][ODBC SQL Server Driver]Communication link failure
• [SQLSTATE 42000] (Error 50000)
• @@ROWCOUNT trigger
• @@servername returning NULL
• # Temp table loading taking long time
• 17806. SSPI handshake failed followed by 18452, the login is from an untrusted domain.
• 2008 R2 The duration spent while attempting to connect to this server was - [Pre-Login] initialization=1; handshake=14999;
• A call to 'Create Process' failed with error code '1455' (Error 15121)
• A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired
• A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - An internal error occurred.)
• A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)
• A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: 64, output error: 0).
• A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (p
• A process is locking itself, means self lock
• A server cursor cannot be opened on the given statement or statements. Use a default result set or client cursor
• A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 4448, committed (KB): 558008, memory utilization: 0%%.
• A timeout (30000 milliseconds) was reached while waiting for a transaction response from the MSSQL$XXXXX service.
• A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back. Native
• A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) (Microsoft SQL Server, Error: 121)
• Accessing SQL Server over network 100 times slower than local!
• Accidentally set SQL Server Max memory too low
• Active transaction : log_reuse_wait_desc
• ACTIVE_BACKUP_OR_RESTORE
• Activity Monitor won't populate with data
• Activity Monitor->Resource Waits->Wait Category "Other"
• Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied.
• AD Linked Server
• Add database to availability group: Password required
• Add Oracle Providers under Linked Servers(Server Objects) in MS Sql Server Mgmt Studio
• Adding a linked server with alias
• adding a where clause makes query extremely slow.
• Adding column in middle of the Table
• After rename a database - cannot connect as administrator
• Alert for CPU in SQL server
• Alter a primary key on a systme versioned table
• Alter column enabled for Full-Text Search
• ALTER DATABASE to set SMALLER FILEGROWTH
• ALTER SERVER STATE permission
• Alter table column from SmallDateTime to DateTime
• ALTER TABLE command on large table takes huge time (SQL 2005)
• ALTER TABLE SET (LOCK_ESCALATION = DISABLE) vs exceptions
• Alternate option for sp_dboption in SQLServer 2012
• Always On New Availability Group - Full backup is required
• An error occurred while processing the log for database 'master'.
• An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user, error code 0x5
• An inconsistency was detected during an internal operation
• An invalid parameter or option was specified for procedure 'sys.sp_change_users_login'
• ANSI _WARNINGS Error
• Anyway to tell if "too many" tempdbs is the "write" latency cause?
• AppDomain marked for unload due to memory pressure
• AppDomain was unloaded by escalation policy to ensure the consistency of your application.
• Append vs Overwrite in SQL Backup
• ASYNC_IO_COMPLETION while BACKUP DATABASE running
• Attach database failed for Server
• Attach database failed for server 'msserver'.(Microsoft.sqlserver.smo) on SqlServer 2012
• Attach database with FILESTREAM from new location?
• Attaching a database to SQL Server
• Attempt to fetch logical page (1:XXX) in database X failed : it belongs to allocation unit XXXXXX not to XXXXX
• Audit Logout Reads too much
• Authentication Issues after Password change on MSA's
• Automatically connect to multiple DB Engines when opening Management Studio
• Average ms/write on tempdb data files is extremely slow
• AWE memory high in RamMAP tool for Windows 64-Bit version?
• Azure SQL Managed Instance xp_cmdshell 'unsupported' or simply won't work?
• Back up Failed Access is denied
• Backing up to Azure Blob Storage : Cannot open backup device. Operating system error 50(The request is not supported.).
• Backup a database in emergency mode
• Backup database - overwrite option
• Backup Database Error
• Backup database without some tables.
• Backup Device Failed to Open. Operating System Error 2
• Backup failed for Server 317(The system cannot find message text for message number 0x%1 in the message file for %2.)
• Backup failed: System.Data.SqlClient.SqlError: Backup and file manipulation... must be serialized
• Backup Fails - System cannot find the file specified
• Backup of SQL database in Single user mode ?
• Backup stuck at 83%
• Backup suddenly very slow
• Backup to URL - The file name "http..." is invalid as a backup device name
• BackupDiskFile::CreateMedia: Backup device' failed to create. Operating system error 5(Access is denied.).
• BackupDiskFile::OpenMedia: Backup device '\\xxxxx-' failed to open. Operating system error 2(The system cannot find the file specified.).
• BACKUPIO and BACKUPBUFFER wait types question
• Batch script to run a procedure with parameters
• BCP Error - Oversized Column
• BCP Queryout too slow
• Best way to convert ntext,text,image to varchar(max),nvarchar(max)
• Blocking caused by -2 SPID
• BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds.
• BROKER_RECEIVE_WAITFOR
• Browse For Local Servers List is Empty (SQL Server Development 2008 R2)
• Buffer Hit Ratio over 100%
• Bulk Insert Failing Message 4863, Bulk load data conversion error (truncation)
• BULK INSERT from network folder
• Bulk insert into one table from another
• Cache Faults/sec are very high, is this an issue and how to fix it?
• calculate MAXDOP
• Calculating FileStream Data Size used in SQL Server
• Calling batch file from sql server job
• can a query that uses with (nolock) block anything?
• Can anyone explain how SQL Server performance scales with CPUs/Cores, memory, disk drives, etc?
• Can grant truncate table permission to a user?
• Can I ignore wait BROKER_TASK_STOP (in Management Data Warehouse)?
• Can I index a RowVersion column
• Can I shrink the log file to 0 Mb if that is the minimum?
• Can I take a backup of a database in standby mode?
• Can not access network share using sql agent jobs
• can not restore .bak file on sql server 2012
• can not truncate table because foreign key reference
• can one sql agent start two tasks in parallel?
• Can we create synonyms for database name
• Can we execute stored procedure with data_writer permission.
• Can we include both BAK and TRN file in "Maintenance Cleanup Task" ?
• Can't add a listener to availability group built on top of workgroup cluster
• Can't attach database to SQL Management Studio - The log scan number passed to log scan in database in not valid - TESTDBUPGRADE
• Can't change the Auto growth option on my Database
• Can't connect SQL Server via TCP/IP
• Can't connect the sql server instance with host name from out side of the server ?
• can't connect to my server
• Can't enable Service Broker
• Can't KILL SessionID
• Can't start SQL Server Agent service?
• can/does sql decide to use multiple indexes on the same table reference in a query?
• Cancel query - what really happens ?
• Cannot Alter Table
• Cannot change thread mode after it is set.
• Cannot connect to localhost\SQLEXPRESS
• Cannot Connect to Remote Named Instance of SQL Server
• cannot connect to sql server developer 64 bit
• Cannot convert a char value to money. The char value has incorrect syntax.
• Cannot create a row of size 8069 which is greater than the allowable maximum row size of 8060.
• Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server Error Number: 7302
• Cannot drop secondary log file
• cannot drop the view 'XXX' because it does not exist or you do not have permission
• Cannot find MSSQLSERVER service in the services list
• Cannot find the symmetric key 'master key', because it does not exist or you do not have permission
• Cannot initialize the data source object of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)"
• Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server "
• Cannot insert duplicate key row in object 'dbo.blabla..' with unique index 'Idx_blablabl'. The statement has been terminated. at
• Cannot kill a session that is running a query on a linked server in SQL Server 2008 R2
• cannot kill process in SQL Server Activity Monitor
• Cannot Kill Process stays in KILLED/ROLLBACK status
• Cannot obtain the required interface ("IID_IDBSchemaRowset")
• Cannot obtain the required interface ("IID_IDBSchemaRowset") from OLE DB provider "OraOLEDB.Oracle" for linked
• Cannot open backup device 'C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\Backup\path'. Operating system error 2(The system cannot find the file specified.).
• Cannot open backup device 'F:\foldername'. Operating system error 5(Access is denied.).
• Cannot open database version 782. upgrade the database to the latest version.
• Cannot restore a database from backup
• cannot restore database
• Cannot set FK, Error: The following data type properties of column do not match
• Cannot shrink log file 2 (SolarWinds_log) because of minimum log space required.
• Cannot shrink log file because all logical log files are in use
• Cannot shrink transaction log file ...
• Cannot Start Sql Server 2005 service.
• Cannot Start SQL Server Agent
• Cannot start SQL Server Service (SQLEXPRESS).
• Cannot start sql-server service. The configuration file '/var/opt/mssql/mssql.conf' failed to load
• Cannot Stop Job
• Cannot use file for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Serve
• Cannot use special principal 'dbo' 15405
• Cannot view the function fn_msxe_read_event_stream ...
• Capacity of CTE
• CAST vs CONVERT with datetime Performance
• Change Column data type from Varchar to Date time
• Change the "text filegroup" property of an existing table
• Changing ANSI_PADDING on a table
• CheckDB failed The operating system returned error 1117(The request could not be performed because of an I/O device error.)
• CHECKDB found 0 allocation errors and 1 consistency errors in table 'sys.syscolpars' (object ID 41)
• Clone VM That Has SQL Server Installed
• Cluster network name resource failed registration......
• Clustered index on a varbinary column
• Clustered Index Update or Insert Expensive Query Plan Operator
• Code: 0xC002F210
• Collation SQL_Latin1_General_CP1_CI_AS vs Latin1_General_BIN2
• com.microsoft.sqlserver.jdbc.SQLServerException: Transaction (Process ID 422) was deadlocked on lock resources with another process
• Combining two Tables into one TempTable, with a condition.
• COMMIT TRANSACTION sometimes slow
• Comparing Excel Sheet data with SQL Table
• Concurrent Insert in multi treaded environment to the same table
• concurrent inserts into the same table
• configure a timeout value for an inactive database connection
• Connect reset by SqlServer
• Connect to Oracle, error 7302
• Connecting to SQL Server without instance name
• Connection closed from application end
• Connection from Powershell to SQL using encryted connection string
• Connection has been closed by peer
• Connection is busy with results for another command
• Connection limit of 32,767
• Connectivity issue from IBM WebSphere Application server to SQL Server 2019
• Connecto to SQL server with default instance using a CNAME supported?
• Conversion of SQL_Latin1_General_CP1_CI_AS to Latin1_General_CI_AS
• Convert host name to IP address
• Convert run_date and run_time into a DateTime Format
• Converting the bytes to KB's , MB's and GB's in SQL Server
• Copy Database Wizard service agent permission issue
• Correlating sys.dm_tran_session_transactions transaction id to the fn_dblog
• Could not allocate space for object dbo. because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additiona
• Could not allocate space for object in database because the Filegroup is full
• Could not create tempdb. You may not have enough disk space available
• Could not find object '[databasename].objectname' or you do not have permission. [SQLSTATE 42000] (Error 15165)
• Could not obtain exclusive lock on database ‘model’.
• Could not register the Service Principal Name (SPN)
• CPU vs Memory
• Create a new database with UTF-8?
• Create failed for LinkedServerLogin
• Create NOT LIKE filter for Extended Events Session
• Create table permission for database user
• Creating a New Local User to Run SQL Agent [The process terminated unexpectedly. [0x8007042b]
• Creating an Alert for Blocked Process Threshold
• Creating Linked server to SSAS
• CTE execution order
• dash (-) character is being converted to – when stored on the table
• Data compression on sql azure db
• Data file just won't shrink after mass deletion of million of records.
• Data Provider or other service returned an E_FAIL status
• Data row does not have a matching index row in the index
• Database '<database>' already exists. Choose a different database name. But it doesn't!
• Database 'msdb' cannot be opened due to inaccessible files
• Database 'XXX' cannot be opened due to inaccessible files or insufficient memory or disk space
• Database and Log File Size is Growing Very Fast!!!
• Database back up
• Database Engine not appearing in SQL Server listing
• Database Engine Tuning Advisor does not support SQL Express.
• Database Engine Tuning advisor failed to connect to ipc port
• Database error code: 241 :Conversion failed when converting date and/or time from character string when insert 6 digit seconds value to datetime column
• Database exception: SMux Provider: Physical connection is not usable [xFFFFFFFF]
• database file size best practice
• Database growth per month
• Database hanging on DB startup.
• Database in "Restoring" state --- HELP
• Database in emergency mode
• Database In Recovery every time I restart SQL Server service
• Database in SysDatabase table does not exist
• Database is beeing recovered..wait until....What's that ???
• Database is in recovery pending state due to disk space issue.
• Database Mail (no such host is known)
• database mail not sending no error messages
• Database mail successfuly sent with error log
• Database marked for unload due to memory pressure.
• Database Rebuild index failed with the following error: "Lock request time out period exceeded
• Database Recovery
• Database recovery finished but its not done really stuck in "Db startup" and "parallel redo task"
• Database Refresh and User Permissions grant
• Database Reserved Space vs. Table Reserved Space
• Database Restore issue: There is insufficient free space on disk volume 'E:\' to create the database.
• Database restore on a new database with same name.
• Database shrink takes long time
• Database Size Increase After Index Rebuild
• Database size is not decreasing after shrinking
• Database size versus table data size
• Database Snapshot goes Suspect
• Database trigger and backup restore.
• Databases with ACTIVE_TRANSACTION with no active transactions
• DB MAIL is showing long running query
• DB Mail Msg 22050, Level 16, State 1, Line 0 Error formatting query, probably invalid parameters
• DB Recovery Model Change History
• DBCC CHECKDB error - Write to sparse file failed due to lack of disk space
• DBCC checkdb error Extent in database is marked allocated in the GAM, but no SGAM or IAM has allocated it.
• dbcc checkdb goes SUSPENDED with wait type of PAGEIOLATCH_EX
• dbcc checkdb unrepairable error
• DBCC CheckDB: Extent in database is allocated by more than one allocation object
• DBCC command for data file size
• DBCC SHRINKDATABASE went into suspend state causing wait type PAGEIOLATCH_EX
• DBCC SHRINKFILE ('LogicalFileName',5) showing error
• DBCC shrinkfile for Data file while DB is online
• DBCC SHRINKFILE gives "A severe error occurred on the current command."
• DBCC ShrinkFile Not releasing Space
• DBCC SHRINKFILE: Page 4:11283400 could not be moved because it is a work table page.
• DbccFilesCompact command went into Suspended Mode
• DBPROCESS is dead or not enabled
• ddl admin privilege
• ddladmin can create tables but not schemas?
• Deadlock on Communication Buffer
• Deadlock on Generic Waitable Object - Coalesce v IsNull?
• Deadlock on page lock during two simple delete commands
• Deadlock on primary key during Update
• Deadlock on Select..Into in Transaction
• Deadlock when using SqlBulkCopy to concurrently insert rows into a single non-empty table
• Deadlock while running multiple UPDATE statements
• Deadlocks - Can they be caused by indices?
• Deadlocks and metadata locks
• Deadlocks on a Clustered index update
• Debug option is not there in SQL Management studio
• Default trace retention
• Defining CNAME on DNS for named SQL Instances.
• Delete Multiple Databases
• delete secondary data file (ndf)
• DENY DELETE permission to existing user
• deny drop permission to user ??
• Derived table 'tablename' is not updatable because a column of the derived table is derived or constant.
• Determine when rollback is complete
• Difference between .bak and .trn files
• Difference between backup size and data size
• Difference between create table and alter table – upgrade process.
• difference between developer edition and enterprise or standard edition
• Difference between permission to connect database engine (grant,deny ) & Login(enabled ,disabled)
• Difference between truncating and shrinking a log
• Difference VarChar(50) and VarChar(500)
• Disable Allow Inprocess option of Linked server provider
• Disable transaction log for a stored procedure
• Disabling all logins
• Disk error "The filename, directory name, or volume label syntax is incorrect" restoring WideWorldImporters.bak file to sql2016 instance
• Disk IO and CPU in sp_who2
• Distributed Transactions fail on Linked server
• Distributed transactions not working
• Distribution agent failed to create temporary files in
• dm_os_schedulers Returns 4 VISIBLE ONLINE only !
• DNS Alias to named instance
• Do I need more RAM?
• Do I need to shutdown SQL server (stop the service) before I reboot a windows server?
• Does dropping a table automatically drop its contraints and indexes?
• Does INSERT statement include the rollback mechanism?
• Does restarting a SQL database kill all processes?
• does service broker come with sql express?
• Does SQL server CDC capture deletion of data
• does sql server terminate the session after some period of time
• Does taking the backups cause high memory usage by SQLSERver.EXE
• Download for SQL 2014 Standard
• Drop Clustered Index when there's no other index's taking a long time.
• Dropping a Primary Key constraint - 35 minutes and counting...
• Duplicate range boundary values are not allowed in partition function boundary values list.
• Duration column in Profiler
• Easy way to import into SQL Server, by using a DMP from Oracle
• Effect of adding a new column to a table, on existing indexes
• Enable Ad Hoc Distributed Queries component of SQL Server 2008
• Enable disable trigger blocking
• Enable TCP IP and Named Pipes using T-SQL/PowerShell/CMD
• Error : A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
• Error "[22001][[Microsoft][ODBC SQL Server Driver]String data, right truncation]" for C++ 64bit application
• Error “Msg 10054, level 20, State 0, Line 0” with MSSQL under Docker
• error [hyt00] [microsoft][odbc sql server driver] query timeout expired
• Error #-2147217871 Timeout Expired
• Error 0xe8 (232). Pipe is being closed
• Error 10054: A connection was successfully established with the server, but then an error occurred during the login process.
• Error 1052 : the requested control is not valid for the services
• error 1069: The service did not start due to logon problems
• Error 1222: "Lock request time out period exceeded": How to find the reasons behind?
• Error 15025 the user already exist
• Error 2148081668
• Error 3449 SQL Server shutdown
• Error 7416 - Access to the remote server is denied because no login-mapping exists
• Error 7836 generated with High severity 20
• Error 7886, Severity 20, Level 2 A read operation on a large object failed while sending data to the client.
• Error 9002 - The transaction log is full due to ‘CHECKPOINT’
• Error 9104
• Error Access to the path is denied. (mscorlib) When trying to open new query window
• Error attaching local mdf file to SSMS
• Error converting data type numeric to bigint
• Error converting data type nvarchar to datetime
• Error Creating Indexed View with APPLY
• Error in creating backup directory using Ola Hallengren
• Error in database attach Error code:5105
• Error in linked server :error 0x8000FFFF
• Error in SP_READERRORLOG
• error message when trying to create any query
• Error message: 'CHR' is not a recognized built-in function name
• ERROR MESSAGES 18054 & 50001 IN SQL SERVER 2005?
• Error occurred while reading the input stream from the network
• Error on Rebuilding Index
• Error resource limit was reached
• Error result: -2067529723 Result facility code: 1220 Result error code: 5
• Error Specified cast is not valid. (SqlManagerUI)
• Error updating temporal table
• error when using powershell in sql agent "'Cannot find path '\\server\d$\DbBackup' because it does not exist."
• Error while cycling the Errorlog
• Error with Microsoft Excel Connecting to SQL Server DataSource
• Error: .NET Framework execution was aborted by escalation policy because of out of memory
• Error: 15466, Severity: 16, State: 1
• Error: 17204 (FCB::Open failed) - How to set persmission correctly on a data/log file for SQL Server
• Error: 17311, Severity: 16, State: 1
• Error: 17836, Severity: 20, State: 1
• Error: 17836, Severity: 20, State: 17; Length specified in network packet payload did not match number of bytes read
• Error: 18456, Severity: 14, State: 5.
• Error: 3041, Severity: 16, State: 1. sql server 2005
• Error: 701, Severity: 17, State: 123 There is insufficient system memory to run this query
• Error: 845, Severity: 17, State: 1: One or more recovery units belonging to database 'TP1' failed to generate a checkpoint
• Error: 8623
• Error: Attempt to fetch logical page (1:9061633) in database 10 failed. It belongs to allocation unit 72057594184204288 not to 72057594202292224.
• Error: Cannot drop schema because it is being referenced by object
• Error: Process <spid> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION
• Error:The network path was not found after shifting the development to a new machine
• Error[36, 17, 145] occurred while attempting to drop allocation unit
• ERRORLOG - occurrence(s) of cachestore flush for the 'Object Plans' , 'SQL Plans' , 'Bound Trees'
• Errorlog filling with changed language setting and changed database context messages
• Escaping single quotes and comma in an insert statment.
• Estimated Time to for Backup
• Event Error- 10028
• Event ID 33205 - MSSQLSERVER Logon - What is this??
• Event ID: 17053 - Operating system error 112(error not found) encountered
• Every query in suspended state
• Every time reboot OS, all databases being recovered after staring up, details in Log File Viewer
• exchangeEvent WaitType="e_waitPortOpen" with "unknown" in executionStack frame
• Exclamation Point on Object in query plan
• Exec SP_Reset_connection
• exec XP_CMDSHELL cannot find store procedure problem
• EXECUTE is failing when the user has db_owner in SQL 2012
• Executing Dynamic SQL larger than 8000 characters
• Execution error: 'the function name is not a recognized built-in function name'
• Execution Failed. See the Maintenance plan and SQL Server Job History logs for Details in SQL Server 2008
• Exetended Events Session timestamp value
• Export views to another SQL Server
• External dump process return code 0x20000001 - Resource Monitor appears to be non-yielding on Node 0.
• External dump process return code 0x20000001. External dump process returned no errors.
• Facing Deadlock during Parallel Updates even when "with(rowlock)" is specified
• Fail to add user 'sa' as a owner of a database for administration
• FAIL_PAGE_ALLOCATION
• Failed allocate pages: FAIL_PAGE_ALLOCATION 1
• Failed to allocate BUFs: FAIL_BUFFER_ALLOCATION
• Failed to flush the commit table to disk in dbid 5 due to error 2601
• Failed to open the explicitly specified database
• Failed to send an environment change notification to a log shipping partner node while revalidating the login
• Failed to start a new trace
• failes when you restore a database
• Faster index creation
• Fatal error 9001
• FCB::Open failed: Could not open file
• FCB::Open: Operating system error 32(The process cannot access the file because it is being used by another process.) occurred w
• FCB::ZeroFile(), GetOverLappedResult() in Error Log
• File or Assembly "Microsoft.SqlServer.BatchParser error
• Filegroup can't be removed
• Filestream SMB error: STATUS_OBJECT_PATH_NOT_FOUND
• Filling the gap Identity columns
• find Currently session that is costing high cpu
• Find High CPU Query
• Find out queries taking up more memory
• Find PID of cmd which is called from SQL
• Find Report Name based on Report ID
• Finding SQL Job that updates a Database/Table
• Fix-length and variable-length data types
• FOR JSON - Column JSON_F52E2B61-18A1-11d1-B105-00805F49916B
• Force kill a process
• Foreign key conflict
• Foreign key constraint error with delete
• Free up SQL Server Memory
• Frequently getting Provider ran out of memory error
• Full database backup can full transection log Files?
• Full Text Search Populate Status - Processing notifications
• FullText creation fails with Error: 30059, Severity: 16, State: 1.
• Get list of linked servers used within a stored procedure
• Getting consistency errors while running CHECKDB
• Getting Error 33222 when enabling audit.
• Getting Error while creating new Job using SQL Server Agent
• Getting errors while trying to get SQL Server Agent to work
• Getting I/O is frozen on database messages in Error Log
• Getting many FlushCache messages in SQL Error log
• giving hyperlink in text/nvarchar column of SQL table
• Got unexpected value in TDS response at offset
• GRANT select on function FN_DUMP_DBLOG in SQL Server without GRANTing sysadmin
• Grant Select permission on a table
• grant sql service account read/write access to that folder(even i gave permision for that folder but still i am getting that error
• HADR_ENDPOINT owner and CONNECT rights
• Help Solving a Deadlock caused by an index created automatically by SQL Azure
• Help! - sql server service stuck in "stopping" state
• High CPU Waits but medium CPU Usage
• High fragmentation on tables with low page counts
• High memory page faults/sec on sql server
• High OBJECTSTORE_LOCK_MANAGER , what that mean
• high page writes/sec in Buffer Manager
• How can I find out if a SQL Login is locked?
• how can I find out if I have any uncommitted transactions?
• how can i shrink the db(530GB) in chunks?
• How can I transfer an encrypted stored procedure?
• How can we move FT data folder and FDLaunchErrorLog
• How can you tell if SQL Server is configed for Mixed Mode OR Win Authentication
• How do I get only the numbers after the decimal?
• How do I see the full SQLl/Query text of a spid?
• How do I temporarily disable my maintenance plan?
• How Does Backup / Restore Affect Index Fragmentation
• How Does Index Fragmentation Affect Insert Update Performance
• How does sql server handle two jobs that start at the same time?
• how I can check whether enough ram on windows server for sql server?
• How long for shrink data files from 80 GB to 3 GB
• How long will a database detach take?
• How many queries can I safely simultaneously make to our SQL Server?
• How much disk queue spiking is normal?
• How much memory SQL server is actually using
• How much space is required to rebuild all my indexes in my database?
• How often should you update statistics?
• HOW RESTORE WITHOUT OVERWRITE EXISTING DATABASE ???????
• how to add database to catalog in linked server ?
• How to add schedule for steps with different time in sql server Jobs
• How to analyze data for Log Bytes Flushed/sec counter
• How to apply Row lock in SQL Server table
• How to archive SCD type 2 functionality using Merge in SQL server
• how to auto shrink the transcation log files >1GB
• how to automate the process of generating scripts for database objects
• How to avoid SUSPENDED Status for my SPID running a Select statement?
• How To Avoid Table Scan
• how to avoid the loss of users during backup and restore activity
• How to BULK INSERT Data to Table with Timestamp Column?
• how to change collation of all columns from all tables from a perticular database
• How to change database collation
• how to change database recovery mode from standby to with recovery
• how to change domain name in SSMS
• How to change field type to hyperlink in SQL
• How to change primary log file?
• HOW to change the collation settings on model database sqlserver 2005 server?
• HOW TO change the DATASOURCE parameter of a linked server?
• How to check CPU % Usage by SQL
• how to check linked server dependencies?
• How to clean the clerk "MEMORYCLERK_SQLCLR"
• How to Clean the SSISDB Size
• How to compare SQL server stored procedures from two separate databases?
• How to configure 2 instances on same hardware with same port
• How to configure the number of CPU used by SQL Server
• How to connect different SQL servers without using linked server connection to read data?
• How to convert an ldf or mdf file to a bak?
• How to Convert an XML content generated by the DEADLOCK_GRAPH of EventNotification into GRAPHICAL Format
• how to convert float value in hh:mm:ss format
• How to copy backup files to shared drive daily with sql server 2012
• How to copy SQL Server database file while instance is running?
• how to correctly restore page ERROR (data-corruption)
• How to create a .mdf file from sql server 2008/2005 database?
• how to create a database backup job that will keep just two days' backup file?
• How to create linked server to multiple database on same server?
• How to create SQL linked server using Active Directory (domain) account?
• HOW TO delete corrupt table in SQL 2012?
• How To Delete ERROR LOGS IN SQL SEREVR
• How to delete the Folder from sql server 2008
• How to detect sql server memory paging out?
• How to determine whether the connection is NTLM or Kerberos
• How to disable a job from a t-sql command?
• how to disable column store index
• how to disable default port 1433 when specified port number is assigned.
• How to disabled interactive logon for MS SQL service account?
• How to display milliseconds as part of datetime field?
• How to download SQL server 2016 enterprise edition ?
• How to Drop a user from a database who owns a dbo schema and is the dbo
• How to execute jobs in parallel from SQL Server Agent
• How to export an entire schema (all objects inside it) in SQL Server 2016
• How to find multiple instances of SQL Server?
• How to find old deadlock information on sql server 2008?
• How to find out what configuration changed on sql server last hour?
• How to find out who disabled/enabled a SQL agent job.
• how to find partition function text applied to a table
• How to find SQL Queries that consumed more memory
• How to find the license type ( per seat or per processor ) for exsting sql server instance ?
• How to find the session id of the jobs running
• How to find who restarted SQL services
• How to free space after truncating a table?
• How to generate NDF files?
• How to get alerted or notified when db goes offline
• how to get an email notification when sql server stop
• How to get database out of single user
• How to get datafile for table by sql
• How to get DB Backup of specified Data Range in MS SQL Server 2005
• How to get rid of 'Worktable' in Statistics IO
• How to get SQL server short name used in Registry?
• How to get the port number for a named SQL Server instances?
• How to give read only permission to all user databases
• How to give Read-Only access to SQL Agent Jobs
• How to handle IDENTITY Columns when doing Switch IN Switch OUT Partitions in SQL Server 2012?
• How to Identify the SPID of a Job currently running in the server.
• How to increase row size in SQL 2008
• How to increase SQL Cache Memory ? It is 1776 KB only. We have SQL 2000 SP4, Windows Server 2003 SP2 with 16 processors and 24 GB memory.
• How to know CPU usage by all the process(SPID)?
• How to know if a user has UNSAFE ASSEMBLY permission
• How to know memory(RAM) usage by all the process(SPID)?
• how to know which object the key lock is put on?
• How to make clustered index scan to index seek?
• how to make Enforce Password Policy unchecked by default
• How to Monitor MSSQL Server With Prometheus ?
• How To Move FILESTREAM Location
• How to open a xdl file
• How to open SQLdmpxxx.mdmp?
• How to open standby database for read/write?
• How to perform data compression on all tables and its impact ?
• How to prevent users from dropping databases
• how to quit a job if some condition is not satisfied in a job step?
• How to read .mdmp files generated by sql server ?
• How to Read contents of SQL server Dump file
• How to Reclaim Unused space from Table
• How to recover msdb database from suspect mode.
• How to recover tempdb space
• How to recycle tempdb without Rebooting Sql Server
• How to reduce MDF file size
• how to reduce tempdb size without restart SQL server?
• How to reduce the database size after deleting huge amount of rows?
• How to refresh Database/Table data in Management Studio?
• how to remove default schema
• how to remove junk character in sql?
• how to remove the selected owned schema in a database user in security
• How to Remove wrong empty partition from partition scheme
• how to rename a database and transaction log file.
• How to reorg table in sql server like in oracal or db2
• How to replace content in text data type?
• How to reset an Identity column using SQL server Management Studio
• How to Reset the Primary Key Counter
• How to resolve failed connection test issue in adding linked server?
• How to resolve high RESOURCE_SEMAPHORE waits
• How To Resolve Remote Scan Cost
• How to resolve SQLVDI and SQLWRITER errors
• How to Resolve this ? provider: TCP Provider, error: 0 - The specified network name is no longer available Error in the Application
• How to restore rows deleted by mistake?
• how to restore sql server 2014 db backup in sql server 2012
• How to run a SQL Server Agent job step on certain days/frequency
• How to schedule job to run on the 6th business day
• how to see executed or killed process in sql server 2008R2
• How to see when SQL agent was last stopped?
• How to Select Delimiter in 'Results to File'
• how to select the column with respect to language in sql server
• How to set UTC timezone for specific database.
• How to setup Database Mail to relay through Windows Server 2012 SMTP relay server
• How to shrink LDF transaction log in Database Maintenance Plan ?
• how to shrink MDF file
• How to shrink the log file of the tempdb for SQL Server 2008?
• how to solve if sql server sleeping transaction is creating blocking
• How to start a SQL job on another server?
• How to start the default instance of SQL Server in single-user mode through Command Prompt
• How to stop 'DBCC CHECKDB(instance name)'?
• How to stop "In Recovery"?
• how to stop running SQL profiler with command?
• How to take SQL database backup in .zip format ?
• How to take the back up of mdf and ldf without stoping sql server
• How to tell if a job is hung up or being blocked? no blocks seen with sp_who2
• How to tell what ALLOW_SNAPSHOT_ISOLATION is set to
• How to trace database connection using SQL profiler?
• How to transfer data from 2008 to SQL Server 2012
• How to update identity column value in sqlserver
• How to update the identity_column value in sql server 2008
• How to use bcp to output to an existing file?
• How to use DBCC SHOWCONTIG
• How to use OPENQUERY to properly execute a Stored Procedure that updates a linked server table?
• HTMEMO wait
• HY090 - Invalid string or buffer length (0)
• I need to copy database except one table, how it can be done ?
• I tried to restore a database and failed due to different versions
• I want estimated_completion_time value in seconds.
• I want to open a .mdb file inside SQL server 2008
• I/O troubleshooting
• IBMDASQL OLEDB linked server "access denied" using Windows Authentication
• If Model db corrupted, what is the status of Sql Server Instance..
• Impact of changing compatibility level
• Impact of changing database owner?
• Impact on database if I stop a long running Rebuild Index job?
• import csv without bulk permission
• Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION).
• in deadlock report does mode=x mean index, table, or key?
• In my sql server stolen page are very high ?
• In oracle there is a tablespace what it is equivalent to in sql server:
• In which system view can I find the filegroup of a table?
• Incorrect Syntex: "ALTER VIEW" must be the only statement in the batch
• Incremental load of the data warehouse using Merge vs Delete+Insert vs Update+Insert
• Index and table must user an equivalent partition function Errror
• Index fragmentation percentage back to 90 after inserts/updates
• Index Index Optimize job is running hours
• Index Name = NULL?
• Index on a timestamp column
• Index optimization job failed with the error , database cannot be opened because its offline.
• Index Rebuild script for SQL 2000 databases
• index scan on a table join, why not index seek?
• Indexes and user_lookups
• Info about Latin1_General_BIN collation, s2008R2
• INIT and NOT INIT on a copy only backup
• Insert into temp table with sorting not works
• Insert Statement - Turning off logging
• Insert the current date/time into a table column as a default.
• Inserting data having Japanese Characters(Kanji) in SQL Server 2000
• Inserting Vietanamese Characters in SQL Server
• install 'microsoft.sqlserver.smo, version=13.0.0'
• Install second SQL instance onto existing cluster role
• Instance Microsoft##SSEE?
• Insufficient disk space in filegroup
• Intellisense: Invalid Object Name on Linked Database, runs fine?
• Internal Error: Text manager cannot continue with current statement. Run DBCC CHECKTABLE
• Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption. In SQL 2008 R2
• invalid filter on server level filter must be empty or server attribute must be equal with the true server name.
• Invalid Schema or Catalog with Linked Servers
• Invoke-SqlCmd Date formating
• is HOLDLOCK hint is good for merge statement in SQL server 2012.
• Is it possible to determine what caused a duplicate key
• Is it possible to insert and update in a table concurrently in sql server ???
• is not a recognized built-in function name.
• is there a secuirty risk to grant users view server state?
• Is there a size limit of MDF database file?
• Is there any job that can split large database backup file into several smaller files
• Is there something like DBCC SQLPERF(LOGSPACE) that will show be a list of the databases and how much free space in each?
• is trace 3604 automatically turned on or by someone or just showing it is turned on
• Issue during script generation for an entire database - SQL Server 2016-2017
• Issue for selecting data from Azure SQL database by linked server - SQL Server 2016-2017
• issue in creating linked server from SQL Server 2008 to SQL Server 2016
• It takes much longer to run as stored procedure than run the code inside the stored procedure
• Japanese Collation
• java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library not loaded
• Job outcome: log-message being truncated
• joining on bigint vs int
• Keep Alive and Keep Alive Interval properties in SQL Server 2012
• Kill all inactive sessions
• Kill Index Rebuild in Rollback State - 19 hour completion
• last_user_update is null
• Length specified in network packet payload did not match number of bytes read; the connection has been closed.
• Limit ALL of SQL to 90% CPU
• Link Server to PostgreSQL from SSMS throwing an Error
• Linked server - domain service account
• Linked Server - SQL Network Interfaces: No credentials are available in the security package
• Linked server : The partner transaction manager has disabled its support for remote/network transactions.
• Linked Server [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
• Linked Server Error - "Test connection to Linked Server failed".Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
• Linked Server error - Msg 7311, Level 16, State 2
• Linked server error - OLE DB provider "SQLNCLI" for linked server "<Linked Server Name>" returned message "Login timeout expired".
• Linked server error 7202 could not find server in sysservers
• Linked server error: Named Pipes Provider: Could not open a connection to SQL Server [5].
• Linked server failure
• Linked Server for AS400
• Linked Server Memory Allocation
• Linked Server schema caching results in query errors
• Linked server using latest OLEDB driver
• Linked Server using Microsoft.Jet.OLEDB.4.0 problem
• Linked Server with SQLNCLI and a default database.
• Linked servers cannot be used under impersonation without a mapping for the impersonated login
• Linked servers cannot be used under impersonation without a mapping for the impersonated login.
• Local SQL Server instances not showing up on Local Servers tab of Management Studio logon screen
• Locked SPID caused by CXPACKET
• Log Buffer Wait - How to reduce it
• Log File Rotation
• Log flush wait time high
• LOG_BACKUP remains on log_reuse_wait_desc???
• Logical Reads vs. Physical Reads
• login failed error Error: 18056, Severity: 20, State: 46.
• login failed for user 'domain\administrator' Reason: server in script upgrade mode
• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
• Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456, Severity: 14, State: 1) When I use SQL Server Authentication to connect server
• Login maps to database user dbo
• login packet used to open the connection is structurally invalid | Length specified in network packet payload did not match number of bytes read; the connection has been closed
• Logon failed for login <<user name>> due to trigger execution.
• LogShipping Error (out of sync)
• lots of ASYNC_NETWORK_IO wait in SSIS package
• Low disk space alert script
• Low Virtual Memory Condition - SQL Server is using most of the server's virtual memory
• maintenance plan error for update stats Code: 0xC0024104 Source: Update Statistics Task Description: The Execute method on the task returned error code 0x80004003 (Object reference not set to an instance of an object.).
• Maintenance plans and proxy accounts
• Management Studio Export to CSV does not delimit commas in text fields
• Managing SQL Server error dumps folder - SQL Server 2012
• Many Buffer I/O and network I/O wait
• Many entries per second: LOGIN FAILED - NULL SID - Network error code 0x2746
• Master database in single usermode
• Master database is gone?
• maximum transactions per second sql server support value
• Memory working set vs commit
• Merge on temporal table fails with Attempting to set a non-NULL-able column's value to NULL
• Mesure/Calculate IOPs in the production server?
• Microsoft SQL Server Error 9001
• Microsoft SQL Server Error: 22022
• Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine (SSMS 18.2 + MS Office 2019 [64bit] + Microsoft Access Database Engine 2016 Redistributable [64bit])
• Microsoft.ACE.OLEDB.16.0 provider is not registered on the local machine. (System.data)
• Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText
• Microsoft® Mashup Runtime?
• Millions of Event ID 17063 - Error 50000 Severity: 16 State: 1 after SQL Cleanup
• minimum account permissions for service broker
• Minimum permission for schedule editing for an agent job with Management Studio
• minimum permission to run sp_who2, queries against dm views and activity monitor
• Minus number in SPID BlkBy Column SP_Who2
• Missing green arrow on the sql server icon in object Explorer
• MODIFY FILE encountered operating system error 31
• MODIFY FILE failed. Specified size is less than current size.
• More efficient to Drop/Create Table or to Truncate/Insert?
• More than 2000 parameter in "In" statement of SQL server 2005 Query then its throwing an exception
• Moving from 'text' to 'varchar(max)'
• Moving Tempdb Database ndf files
• MS SQL Server 2019 evaluation license expired (Error code 17051)
• MS SQL Server Maintenance Plan Failed: Error Code 0x534. [SQLSTATE 42000] (Error 15404))
• MS_AgentSigningCertificate
• MSA cannot register SPN
• msdb is stuck in Single User Mode
• MSDB is too big
• msdbdata.mdf file is very large
• Msg 1088, Level 16, State 9, Line 1 Cannot find the object "sys.syscommittab" because it does not exist or you do not have permissions.
• Msg 15247, Level 16, State 1, Procedure sp_grantlogin, Line 13
• Msg 3287, Level 16, State 1, Line 1 The file ID 1 on device 'D:\_DEV_file13.bak' is incorrectly formed and can not be read. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
• Msg 3287, Level 16, State 1, Line 1 The file ID 1 on device 'E:\XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXfile8.bak' is incorrectly formed and can not be read. Msg 3013, Level 16, State 1, Line 1 RESTORE DATABASE is terminating abnormally.
• Msg 5042, Level 16, State 12, Line 6 The filegroup '*****' cannot be removed because it is not empty.
• Msg 7340, Level 16, State 4, Line 1 Cannot create a column accessor for OLE DB provider "IBMDASQL" for linked server "".
• Msg 8992, Check Catalog Msg 3853, State 1 in SQL Server 2012
• MSSQL Server Backup From Zip file (without manual extraction)
• MSSQLSERVER service not found in the service list.
• Multiple users read / update table at same time
• MySQL to SQL Server error
• Named Pipes Provider: Could not open a connection to SQL Server
• Need to connect to an Oracle DB using SQL Server Management Studio
• Need to rebuild Indexes after database restored on new server
• Network path not found
• Network Path was not found
• New transaction is not allowed because there are other threads running in the session.
• No OK button to press
• No rows were deleted
• No Servers listed under Database Engine in SQL Server 2008 on Windows Server 2008 R2.
• Non-Clustered Indexes and Table Truncation
• Non-yielding scheduler on SQL Server 2019
• Nonqualified transactions are being rolled back.
• not able to create a link server to access an Oracle DB from SQL server 2005 SP2
• Not enough storage is available to complete this operation ?
• NULL Value in Client_Net_Address & Local_Net_Address
• Number of Deadlocks/sec reached to 1200
• Number of Reads in Profiler
• Number of users accessing the Database
• nvarchar(max) or nvarchar(2048)
• OBJECTSTORE_LOCK_MANAGER -- utilized more memory
• Obtain query plan for (exec) completed session_id
• ODBC ERROR: State = 40001 Error = Transaction ( Process ID 235) was deadlocked on lock
• OFFLINE Index rebuilds vs ONLINE Index rebuilds
• OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered.
• OLE DB provider "SQLNCLI11" for linked server "LINK_NAME" returned message "Communication link failure". TCP Provider: The semaphore timeout period has expired
• One server, multiple instances, seperate IP - addresses and the same port?
• One sql server agent job suspend
• Only formatted files on which the cluster resource of the server has a dependency can be used
• Operating system error 1(Incorrect function.) encountered.
• Operating System Error 170(Requested Resource is in use)
• operating system error 995 ( the IO operation has been aborted because of either a thread exit or an application request)
• Operating system error code 3(The system cannot find the path specified.).
• Operator used tempdb to spill data during execution with spill level 2 to sort
• Oracle equivalent collation for SQL database
• page life cycle Expectancy is coming less than 300 in my SQL server do we required to increase SQL server memory(RAM)
• Page Splits per second very high
• PAGEIOLATCH_EX Wait type on insert
• pages per second very high value
• Partitioning and File Groups best practices?
• PerfLib 2.0 counter removal failed with exit code 2. Command line: C:\WINDOWS\system32\unlodctr.exe /m:hkengperfctr.xml from directory C:\Program Files\Microsoft SQL Server\120\Shared\.
• Performance decreas after ALLOW_SNAPSHOT_ISOLATION ON
• Performance Difference in sql while using cast or DatTimeFromParts for DateTime column
• Performance impact due to sleeping sessions
• Performance Issue: Worker threads ccassionally run out then SQL server rejects connections
• Performance problem with more than one COUNT(DISTINCT ...) in a query
• Permanently deleting data from SQL Server
• permission for backup / restore, xp_availablemedia
• Permission required to read audit logs
• Permissions on Error Logs from Agent
• Permissions on server scoped catalog views or system stored procedures or extended stored procedures can be granted only when the current database is master.
• Permissions problem: Cannot process the object ""databasename"."dbo"."tablename"". The OLE DB provider "SQLNCLI11" for linked server "servername" indicates that either the object has no columns or the current user does not have permissions on that object
• Physical connection is not usable
• Please create a master key in the database or open the master key in the session before
• Please help:Some logins are not able to loginto sql server
• Powershell foreach to loop through SQL instances...
• Primary Key creation takes 4x the time of creating the table with data
• Primary key error Uppercase/lowercase
• Problem to change sa password
• Problem with Hyphen in server name?
• problem with restore database
• Problem: INSERT/UPDATE/DELETE failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER’
• Process got stuck with CXPACKET waits
• Process with status SLEEPING.
• profiler doesn't catch Entity Framework inserts and updates?
• Profiler trace with Error = 2 (Aborted)
• Property Size is not available for Database '[tempdb]
• Property Size is not available for Database [tempdb]
• Protocol error in TDS stream error
• query processor could not produce a query plan error.
• Query to check index fragmentation is taking very long time
• query to find the last transaction happened on particular database in one server
• QUESTION
• Question about run_duration in sysjobhistory table
• Read only routing in Azure machines
• Read Only Transaction in Sql Server
• Reading rows from the sys.sysobjvalues system table for a database - SQL Server 2016
• Rebuilding SQL Server system datbases
• Receive 'Backup failed for Server <server name>. (Microsoft.SqlServer.SmoExtended when trying to back up a database
• Receiving an error in the logs - 18059, Severity: 20, State: 1.
• Receiving Error 0x8007028A when adding files/folders to FileTable folder via Explorer
• Receiving error 17828 state 3 after applying February 2016 Windows patches to SQL 2012 SP2 server
• Receiving Error: 17832, Severity: 20, State: 8. for 2 users all other users ok
• reclaim disk space after delete an index
• Reclaiming Reserved space for tables
• reclaiming space on truncated tables
• Recommended best practice SQL Ports for multi-instance environment
• Recommended Response Time for Sql Server Database
• recovery mode = simple but ldf grows
• Recreate tempdb files
• Recurring error - The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors.
• Reg: How to resolve the Sleep_Task Wait Type....
• Regarding SQL Service Account Temp files
• Regarding the SQL Server service starting problem
• Regional settings is not effecting in SQL Server
• Remote Connections to WSUS DB
• Removing a file group from a partition scheme
• Rename partition scheme and partition function
• Rename SA account
• REPLACE exact match in string
• Replicated Transaction Information in DBCC Opentran()
• Resetting dm_db_index_usage_stats without restarting or detaching a database
• Resolve runnable state of a process
• Restarting a SQL Server service in change pending state - SQL Server 2014
• Restoration failure :- backup set holds a backup of a database
• Restore Database to multiple data files and its failing?
• Restore Database with different Logical names
• Restore Database, new owner can't access the database
• RESTORE detected an error on page (0:0) in database as read from the backup set
• RESTORE detected error on page (0:0)
• restore error '5(access is denied)' Restoring from another servers backup
• Restore failed with Microsoft SQL Server Management Studio Express 2005
• Restore fails with Exclusive access could not be obtained because the database is in use
• Restore Greyed Out in Tasks Database Restore
• Restoring database from Enterprise to Standard Edition with SP3 [CDC problem]
• Restoring the Database mdb.bak file
• Retrieve the data from large XML files
• Retry Attempts in SQL server Job agent
• Review AUTO_UPDATE_STATISTICS setting
• Risk of enabling change tracking
• ROWGUIDCOL
• Run an external program from stored procedure
• Run sp_updatestats on a specific table
• Run the RECONFIGURE statement to install.
• Runing a SQL Agent job every 5 second
• Running DTS package through job in SQL Server 2008
• running the upgrade step from version 610 to version 611 fails
• SA password changed --Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: <named pipe>]
• SA Password changing automatically
• schedule restarting of sql server services
• schema does not exist or you do not have permission to use it SQL Server 2012
• Script to send email notification when sql server stops..
• Script to get SQL Server Agent Job schedule and the last run status
• Scripted SQL Agent Job - Max number of Steps
• Searching Russian characters or cyrillic characters in a sql server table
• Secure Deletion of Data
• Seeing orphaned transactions that we need to kill
• Select * into a link server table
• SELECT ALL USER SECURABLES but revoke system databases SELECT permissions
• Select count(*) cause time out error
• SELECT COUNT(*) taking several minutes even after rebuilding cluster index
• SELECT DATEADD(day, -1, getdate()) .. how to get just day without time .... and remove the formatting as well .. look below ...
• Send Multiple attachments with database mail in Sql server
• Send multiple query attachments using sp_send_dbmail
• Sending Mail Error: Could not connect to mail server. (An invalid argument was supplied)
• Server clock on GMT UTC time, want to schedule jobs on Eastern Time (ET)
• server principal...is not able to access the database...under the current security context
• Server shutdown event id 19019
• Service 'Microsoft.SqlServer.Management.IRegistrationService in SQL server management studio
• service acct ends up looking like nt authority\anonymous logon when it reaches the sql server
• Service Broker Manager issued a SQL shutdown
• service-specific error code -2146885628- MS SQL Server 2008 r2 Express
• Session went Killed / Rollback state in sql server
• Set Foreign Key Checks off in an insert script
• Setting SQL server Express maximum memory usage
• Shredding deadlock information from XML data
• shrinking a database thru the mgmt studio interface seems stuck
• shrinking is very very slow ... any reasons ?
• Shrinking SQL .MDF & LDF file size not working?
• Shrinking the MSDB logs
• Slow deletes on Clustered Index tables with other indexes SQL Server 2005 SP2
• Slow Query performance on Sql server when inner join is done with 2 Tables
• software_vendor_id in msdb..Backupset always return 4608
• some queries with runnable state
• Some tables do not appear when using linked server
• SOS_SCHEDULER_YIELD is occuring even when CPU is free.
• SP running in the SSMS fast, but in VB.Net slow
• sp_reset_connection - What and When it should be used
• sp_send_dbmail leaves hung process
• sp_send_dbmail throws error 22051 (file is invalid) when attaching files from a Share (unc notation)
• sp_send_dmail doesn't work in Agent job with query parameter
• sp_server_diagnostics running on background
• sp_updatestats fails to run with 'permission' error under dbo-priveleged user
• sp_who2 , spid's appearing multiple times
• sp_who2, multiple processes with single SPID
• Space Problem from MSSQL DATA Folder
• SPID stuck in KILLED/ROLLBACK state
• Split one mdf file into several files
• Splitting TempDB into multiple data files.
• SQL 08 R2 - Creating an instance of the COM component with CLSID FAILURE
• SQL 2000 - Error 22022: Job oXxxxxxxxxx does not exist in the job cache.
• SQL 2005 Select Into Temp table then insert causes null issue
• SQL 2012 errors 3417, 18053, 701
• SQL 2012 not using all available memory on Server
• SQL 2012 SP1 - How to determine a query that causes Error 8623 in SQL Log: The query processor ran out of internal resources and could not produce a query plan. This is a rare event...
• SQL 2016 Agent Job using Powershell script UNC path not working
• SQL Agent - Error Authenticating Proxy
• SQL agent failed to start
• SQL Agent Job - PowerShell step giving escape token error
• sql agent job cmdexec step with robocopy
• sql agent job command step multiple lines?
• SQL agent parameter passing
• Sql Auto increment in View
• SQL AWAITING COMMAND / SLEEPING bloking most of the running processes wthout genrating any deadlock
• SQL backup fails - error 23 cyclic redundancy check fails
• SQL Backup Timeout Expired
• SQL Browser and 1434 in SQL Server 2016
• SQL Capacity planning
• SQL collation, German characters do not show up correctly
• Sql Command To Restart SQL Express Service
• SQL database mail authentication
• SQL error 17113 while starting the the Server in Single User mode
• SQL Error 17187 Severity: 16, State: 1
• SQL error logged in Windows event log: Error 4014, Severity, 20, State, 13. MSG: A fatal error occurred...
• SQL in new machine shows error 'FCB::Open failed: Could not open file F:\Data\tempdb.mdf for file number 1. OS error: 3(The system cannot find the path specified.)'
• SQL Job not running but Job History showing in executing status
• SQL Jobs - Sending email to two person
• SQL keeps losing service credentials on server restart
• sql message 3014
• SQL over vpn very slow need help
• SQL Parameter and wildcards, how to make it work?
• SQL Profiler Trace Result
• SQL Profiler Trace Skipped Records
• SQL Query that causes Deadlock often
• sql query to get all drive total space and free space.
• SQL Restore gets to 100% but never completes
• SQL Script generation fails
• sql script to find out about jobs failed
• Sql Server - Storing comments for table names and columns
• SQL SERVER ( Services still showing in services.msc window )
• SQL Server (MSSQLSERVER) service terminated with the following service-specific error: Cannot find object or property.
• Sql Server (Service Broker manager) shut down by itself
• sql server 2008 not showing and inserting unicode characters!
• SQL Server 2008 R2 - Timeout After 30 Seconds - Can't Change
• SQL Server 2008 R2 Management Studio says 10.50.1600, but SP1 upgrade program says it has nothing to upgrade
• SQL Server 2008 Standard vs Enterprise difference
• sql Server 2008: duplicated rows in Activity monitor
• SQL Server 2012 - Linked Server - Error: 10054 - OLE DB provider "SQLCLIN11" - for linked server - unable to establish connection
• SQL SERVER 2012 Installed to SMB share Error 59 (An unexpected network error occurred)
• SQL SERVER 2012 OFFSET/FETCH with Record Count Output
• SQL Server 2014 not showing Instance Name
• SQL Server 2014 RTM download link
• SQL Server 2016 - Named pipes still accepts a connection even when disabled in configuration manager
• SQL Server 2016 Instance Not Starting, Not Able to Connect Via SQL Server Management Studio
• SQL Server 2016 memory pressure leads to the plan cache clearing
• SQL Server 2016 remote access denied
• SQL Server 2016: Database was shutdown due to error 3314 in routine 'XdesRMReadWrite::RollbackToLsn'
• SQL Server 2017 CU9 (14.0.3035.2) MODIFY FILE encountered operating system error 31(A device attached to the system is not functioning.) while attempting to expand the physical file
• SQL Server 2019 Latin1_General collations
• SQL Server Agent - Operators
• sql server agent conditional job
• SQL Server Agent Error
• SQL Server Agent fails to start
• SQL Server Agent Job And Database Mail - Error formatting query, probably invalid paramters
• SQL Server Agent job between 2 instances fails with Error 18456 - Login Failed for user
• sql server agent job fails,
• SQL Server Agent Job is not running as per schedule
• SQL Server Agent Job Notifications Not Working
• SQL Server Agent job to import file from either local machine or from an SFTP folder
• SQL Server Agent Jobs not running 'SQL Server Agent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)'
• SQL Server Agent Log error: Waiting for SQL Server to recover database 'msdb'
• SQl server Agent not starting
• SQL Server Agent Schedule Job to run every 3 months
• SQL server agent starts, then stops automatically
• SQL Server Agent Will Not Start
• SQL Server Alert System: 'Severity 017' occurred
• SQL Server Alias Configuration
• SQL Server allocates AWE memory while option "use AWE to allocate memory" is disabled
• SQL Server Auditing with SQL Express
• SQL Server Back up faild
• SQL Server Background process details
• SQL Server backup with INIT options
• SQL Server becomes Unresponsive
• SQL Server Buffer Manager: Pages reads/sec
• SQL server can't access network share
• SQL Server cannot accept new connections, because it is shutting down
• SQL Server cannot Find SSL Certificate
• SQL Server changes - to –
• SQL Server Connection Issue
• SQL Server Connections getting Closed
• SQL Server Connectivity Issue
• SQL Server detected a logical consistency-based I/O error
• SQL Server disconnects, now affecting customer application servers. Cluster.log attached
• SQL server equivalent for Oracle Spool
• Sql server error log - Souce of log entry
• SQL Server Event ID 17052: SQLServerAgent has terminated unexpectedly.
• SQL Server event Log ID 18056.
• SQL Server Execution Error: 'DIGITS' is not a recognized built-in function name
• SQL Server failed with error code 0xc0000000 to spawn a thread.......Error
• SQL Server GDR vs CU
• SQL Server I/O request taking longer than 15 sec.
• SQL Server incorrectly parsing dates as YYYY-DD-MM
• SQL Server INSERT STOPS [Timeout]
• SQL Server Instance Connectivity Issue without port number
• SQL Server is not accepting connections
• SQL Server is terminating because of fatal exception c0000005
• SQL Server is terminating because of fatal exception c0000005.
• SQL Server is terminating in response to a 'stop' request from Service Control Manager
• SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required
• Sql Server Job error
• SQL Server limit the processor usage on the basis of user
• SQL Server Locks up with FAIL_PAGE_ALLOCATION 1025
• SQL Server Log Shipping is failing at restore job
• SQL Server Maintenance Plan on a Network Drive
• SQL Server Management Studio Error when trying to connect to any remote database. The wait operation timed out. Can anyone help?
• SQL Server Management Studio Express - "Script Action to Job" Grayed Out
• SQL Server Management Studio System Cannot find the file specified...
• SQL Server Maximum Write Performance
• SQL Server Memory Issue
• SQL Server Memory Usage Peaks to 95% and its not releasing SQL 2012
• SQL Server Network Interface library could not deregister the Service Principal Name (SPN) Error: 0x6d3, state: 4. Administrator should deregister this SPN manually to avoid client authentication errors.
• SQL Server not releasing memory back!
• SQL Server Not starting - Tempdb path updated to wrong path
• SQL Server not Starting Up - Could not open error log file system error = 5(Access is denied.)
• Sql server ODBC connection error "Connection failed: SQLState: '08001' SQL Server Error:17"
• SQL Server pagefile.sys best practices.
• SQL Server Performance Counter
• SQL Server Pre-Login Handshake
• SQL Server Services - Stopping Randomly
• SQL Server Stack DUMP Generated
• SQL Server stopped responding
• SQL Server suddenly becomes not responding.
• SQL Server Table with 50 Trillion records
• SQL Server Task Manager Process
• Sql server timeout issues, Win32Exception (0x80004005): The wait operation timed out
• SQL server uses page file not RAM - performance issue
• SQL Server utilising more than 90% of server RAM
• SQL Server Wake-up
• SQL Server Windows NT 64 bit - very high memory usage - Have to restart server every 18 hours - please help.
• SQL Sever Agent Error - Event ID 318
• Sql Sever Restore error System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "test" as read from the backup set. (Microsoft.SqlServer.Smo)
• SQL STATE: 23000, NATIVE ERROR: 2627
• SQL Trace - RPC:Completed event
• SQL TRACE ID 1 was started by Login "SA"
• sql writer is causing my backup's to fail
• SQL_Latin1_General_CP1_CI_AS support for unicode and non latin
• sql_shared_mrconfigaction-install-confignonrc-cpu64
• SQL-OLE DB provider "Microsoft.ACE.OLEDB 12.0" for linked server error
• SQL2008 how to open .sqlaudit file
• SQLAgent - Generic Refresher stopped
• SQLCMD connect to sql server error SSL provider
• sqlcmd not working when a port is defined in the -S argument
• SQLCMD output - how to suppress (or change) the text that's inserted between batches
• SQLCMD Syntax Error
• SQLDUMPER_UNKNOWN_APP.EXE SqlDumper
• SQLEXPRESS + SQLSERVER ON SAME MACHINE
• Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0x80040e4d. SQLSTATE: 42000, Native Error: 18456
• SQLServer 2016 SP2 / SSMS 2017 - syspolicy_purge_history now failing when run via Server Agent
• SQLServer 2019 Polybase - External access operation failed because the location URI is invalid. Revise the URI and try again.
• SQLServer Backup using Veritas Netbackup after Index Rebuild
• SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent
• SQLServerAgent could not be started (reason: Unable to connect to server '<ServerNAme>'; SQLServerAgent cannot start)
• SQLServerException: The connection is closed.
• SQLsrv64.dll
• SQLVDI: Loc=SignalAbort. Desc=Client initiates abort
• SQLWRITER (hr = 0x80004005. SQLSTATE: HYT00, Native Error: 0)
• SSISDB re-setting up Encription key
• SSL Certificate not visible from SQL Configuration Manager
• SSMS restore database: no full database backup found
• SSMS v18.3 - Debugger
• sspi handshake failed with error code 0x80090311
• SSPI handshake failed with error code 0x80090311
• Stack Signature for the dump is 0x00000000
• Stop AUTOSHRINK background process
• Stored procedure change history information
• Storing Russian Characters in a column?
• Strange Error - Operating system error: 317(The system cannot find message text for message number 0x%1 in the message file for %2.)
• String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.
• STRING_AGG bug
• SUSDB (Recovery Pending) state/error
• syntax error for option(maxrecursion 0)
• sys.dm_db_index_physical_stats takes a very long time to run on a small table
• sys.dm_exec_query_stats cleared frequently?
• sysindexes states that sys.sysrscols contains 50 million rows. How to free up this space?
• SysJobHistory - Step_Name - (Job outcome)
• System.Data.SqlClient.SQLError: Exclusive access could not be obtained because the database is in use.
• System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)'
• Table Locking - during rebuilding of indexes with scheduled job / (typical DBCC ReIndex - online)
• Table Names - Singular or Plural?
• Table partitioning in SQL 2016 Standard Edition
• Table variable and collation
• Taking database offline takes long time...
• TCP connection closed
• TCP connection closed but a child process of SQL Server may be holding a duplicate of the connection's socket in SQL2008R2
• TCP Provider: The semaphore timeout period has expired error message with SQL server 2014 SSIS agent job
• Temp DB consistency error event id: 824
• Temp DB is growing very fast
• Temp tables and transaction log
• TEMPDB - DBCC SHRINKFILE Does not free disk space (SQL SERVER 2008)
• TempDB blocking... finding the culprit......
• TEMPdb cannot be shrunk as it is either being shrunk by another process or is empty.
• Tempdb data and log files on same drive
• TempDb getting full
• TempDB is growing abnormally,How to check and find out what makes it grow
• TEMPDB is growing to huge size suddenly
• tempdb log file is eating up disk space
• tempdb log file not releasing space
• tempdb Log Filling - Cannot find how or what
• TempDB Version Store Cleanup
• Tempdb- Disk size Requirement for Tempdb Database?
• templog.ldf grew unexpectedly,
• the action can't be completed because the file is open in sql server(SQLEXPRESS)
• The Batch request is very high in Job activity monitor.
• The client was unable to reuse a session with SPID 443, which had been reset for connection pooling. The failure ID is 46. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this
• The client was unable to reuse a session with SPID XX, which had been reset for connection pooling.
• The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. The failure ID is 23. This error may have been caused by an earlier operation failing.
• The clocks on the client and server machines are skewed.
• The connection was recovered and rowcount in the first query is not available. Please execute another query to get a valid rowcount
• ‌The conversion of the varchar value '4103049600' overflowed an int column
• the current transaction cannot be committed and cannot support operations that write to the log file
• The data base cannot be opened because it is version 661. This server supports version 655 and earlier.
• The deadlock between RangeS-S and RangeI-N
• The definition of object has changed since it was compiled ERROR
• The error is printed in terse mode because there was error during formatting
• The exact meaning of "Executions/Min" in SQL Server 2008 Activity Monitor
• The file or directory is corrupted or unreadable
• The job was stopped prior to completion by Shutdown Sequence 0.
• The log scan number passed to log scan in database 'master' is not valid.
• The MSSQLSERVER service terminated unexpectedly
• The MSSQLSERVER service terminated unexpectedly.
• The OLE DB provider "MSDASQL" for linked server "MYSQL" supplied invalid metadata for column "IncCreated". The precision exceeded the allowable maximum.
• The OLE DB provider "OraOLEDB.Oracle" for linked server "" reported an error. Access denied.
• The OLE DB provider "OraOLEDB.Oracle" for linked server "ORA" reported an error
• The On Success action of the last Step will be changed from 'Goto Next Step' to 'Quit with Success'. Is this the intended behavior?
• The operating system error was '32(The process cannot access the file because it is being used by another process.)
• The operating system returned error 21
• The operating system returned error 23(Data error (cyclic redundancy check).)
• The query processor could not start the necessary thread resources for parallel query execution
• The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large num
• The specified resource type cannot be found - event id 17137
• The specified SQL Server could not be found?
• The subscription have been marked inactive and must be reinitialized into a replication
• The TCP/IP connection to the host 127.0.0.1 , port 1433 has failed
• The transaction log for database 'abc' is full. Error: 9002, Severity: 17, State: 4.
• The transaction log for database 'Database' is full due to 'ACTIVE_TRANSACTION'
• The transaction log for database 'tempdb' is full.
• The transaction log for database 'Test_db' is full due to 'LOG_BACKUP'
• The transaction log for database <db Name> is full due to 'ACTIVE_TRANSACTION'
• There is already an object named 'id_pk' in the database.
• There is insufficient free space on disk volume 'c:\' to create the database.
• There is insufficient system memory in resource pool 'default' to run this query
• There is insufficient system memory in resource pool 'default' to run this query
• There is insufficient system memory to run this query
• This backup cannot be restored using WITH STANDBY because a database upgrade is needed
• Thread count too high SQL server - SCOM alerts
• Time-out occurred while waiting for buffer latch type 3 for page (1:36919), database ID 7. (Microsoft SQL Server, Error: 845
• TimeOut expired. The timeout period elapsed prior to completion of the operation or the server is not responding.(Microsoft SQL Server)
• Timeout Issue while trying to insert records via Stored Procedure
• Timeout when restoring database - Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)
• To many _WA_Sys statistics
• Too many sleeping session in SQL Server
• Top wait : QDS_Async_Queue
• Total Server Memory VS Target Server Memory made me crazy.
• Trace flag 8295
• Track table last used/accessed by user sql
• Transaction (Process ID 52) was deadlocked on lock
• Transaction context in use by another session.
• Transaction Log backup error
• Transaction Log file full with Checkpoint
• Transaction log file growing rapidly. How to identify the cause
• Transaction log filling up in "Simple" recovery model, catch 22
• Transaction Log Full - Msg 9002, Level 17, State 2 - SQL Server 2005 Standard
• Transaction log full due to "log_backup" when there's plenty of available space
• Transaction log is full, disk space is full in sql server 2008
• Transaction log is very big, how to release unused space?
• Transaction log space reclaim
• Transaction Rollback Operation is taking longer
• Transactions/sec performance counter
• Trigger Update and Ip Address
• Trouble with Linked Server to AWS Redshift using MSDASQL Provider
• troubleshoot The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
• truncate_only' is not a recognized BACKUP option
• Try catch in a windows batch file
• trying to find out what's triggering backups and where they are going to
• tuf file location
• Turn off Transaction Log?
• Two transactions updating same table and same row at same time,what happens?
• Unable to bring database back into MULTI_USER mode.
• Unable to change the DB name
• unable to connect sql server through management studio intialization=14769 handshake=13739 error 258
• unable to connect to database server from excel sheet.
• Unable to connect to DB server
• Unable to connect to remote SQL server in management studio
• Unable to connect to SQL database using a domain user
• Unable to connect to SQL named instance using alias name
• Unable to connect to SQL Server '(local)'. The step failed.
• Unable to drop database
• Unable to drop filegroup; The filegroup cannot be removed because it is not empty
• Unable to find index entry in index ID 0, of table 1589580701, in database 'tempdb'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support.
• Unable to find NT AUTHORITY\LOCAL SERVICE
• Unable to import Package
• Unable to register SPN (error 0x2098, state 15) after moving/attaching hyper-v VHD SQL system
• Unable to remove a FileStream File and Filegroup
• Unable to remove TempDB files SQL 2012
• Unable to select the Data from a table even after providing the Select access.
• Understanding Error 3136: This differential backup cannot be restored because the database has not been restored to the correct earlier state.
• Understanding Scale in perfmon charts
• Understanding sliding window technique for partitioned tables - SQL Server 2012
• Understanding Sql Server Crash
• undo delete statement...is it possible
• Unqualified Join(s) detected
• Unspecified error occurred on SQL Server during Index Maintenance
• Unused Reserved Space of Table too big
• Unused Vs. Unallocated Space
• Update Job owner for all SQL Agent jobs;
• update statistics is filling tempdb
• update statistics job taking longer to complete
• update statistics takes too long
• Update Statistics with Fullscan, does it cause blocking?
• Upgrade Sql Express to Sql Developer
• Urgent 2005: Linked Server data doesn’t match expected length for column
• Use of < SQL User Without Login >
• Use of Always encrypted column in (#) temporary table in SQL server 2016
• Use SQL Server to Query an Exchange Server Inbox
• User does not have permission to run DBCC TRACEON.
• User does not have permission to perform this action
• Using CTRL + F not working to find any text within the query result
• Using FOR SYSTEM_TIME clause with views over temporal tables in stored procedure creation
• Using job_id (in string format) to get job name
• Using Mapped Network Drive with SQL Server
• Using multiple lines of query in sqlcmd using -q switch
• Variable SQLLOGDIR not found error while running Ola index job.
• version store space not being released
• very high memory usage sqlservr.exe
• View Linked Server Connections
• view list of tables of a linked server
• Wait Statistics - PREEMPTIVE_XE_DISPATCHER
• Wait Time of "CPU - Parallelism CXPACKET" is very high, what is the quick solution?
• Warning: Non-existent step referenced by @on_success_step_id.
• Way to SET TRANSACTION ISOLATION LEVEL in stored procedure
• Weird Semaphore timeout error
• What are all of these syncobj views in my database and who/what created them?
• What can cause a SQL Server Account lock out?
• What changed Agent XPs to 0?
• What does it mean when DBCC LOGINFO returns many rows with status = 2 and DBCC OPENTRAN returns no active open transactions?
• What does ms/s mean?
• What does RTM stand for?
• What does string "OBJECT: 7:1797581442:0" in deadlock log mean?
• What does Suspended in Activity monitor mean
• What does total_worker_time mean in the sys.dm_exec_query_stats DMV?
• what is affected? Service Broker Message delivery is not enable in database.
• What is difference between 32 bit and 64 bit sql server memory management
• What is difference between localDb and sql server express
• what is dormat state in sql server?
• What is Elapsed time, CPU time in SET STATISTICS TIME ON.
• What is Exact Difference between USER_NAME(),CURRENT_USER,SYSTEM_USER,SUSER_NAME(),SUSER_SNAME() functions in SQL Server
• What is exec sys.sp_addextendedproperty @name=N'MS_DiagramPane2', @value=N' 1500 ?
• What is the benefits of Multiple mdf files and ldf files ?
• What is the best practice for configuring tempdb?
• What is The Best Practice for Log File Rotation Frequency and Size
• What is the difference between between SPID and session_id in SQL Server
• What is the difference between C2 Audit Tracing and Server Audit?
• What is the difference when we restore the database with standby and when with NoRecovery?
• What is the equivalents of IW , W in sql server?
• What is the FILESTREAM Windows share for?
• what is the purpose of head blocker column in Activity monitor...
• what is the sequence of starting up database in sql server?
• What is the use of mapped to certificate, asymmetric key, credentials
• What is this Memory Grants Outstanding are 8 ?
• What is TM REQUEST?
• what is waiting in waiting tasks in activity monitor
• what to do if index size larger than data size
• What type of isolation is this "READ COMMITTED (2)"
• What will happen if checkdb process is killed in the middle
• Whats a TUF File?
• Whats best: Torn Page Detection or Checksum?
• whats the difference between detaching and taking a db offline?
• When and where to use MAXDOP = 0?
• when apply service pack, will it restart database Engine?
• when deadlocking, how to send email alert
• When does SQL Server write committed transactions to disk?
• When is the release date for SQL Server 2020 (aka SQL2020)
• Where Backup Failed history get stored in system databases??
• Where can I find SQLCMD?
• where does SQL Server database reside ?
• where to download SQL Server 2008 R2 Developer Edition (prefer microsoft official site)
• Where to download SQL Server 2014 Developer edition?
• Where to download Sybase OLEDB Provider 64-bit
• Which ports need to be enabled to configure log shipping between two different locations.
• Who Disabled SQL Job
• Who should be database owner on production server ?
• Who started the trace? How to stop it?
• why SQL Server 2012 still needs the "Stolen Server Memory (KB)"
• Why a user can't execute a stored procedure created by itself in SQL 2005?
• Why Did SQL 2016 Crash ?
• Why do some system views have columns with different collations then the default collation?
• Why Error 5118? My disk is not compressed?
• Why I can't find the .bak file in SSMS restore window
• Why Mdf and Ldf should be on different drive?
• Why Pagelock/Keylock?
• Why SQL server Database go in Offline mode ?
• Why Table Reserved Space Much Greater than Data Space
• Why use multiple data files?
• WITH (NOLOCK) across a linked server
• WITH(NOLOCK) is still causing a block?
• Workaround to free up disk space as Garbage Collector of SQL Server not releasing space of deleted files created using FILESTREAM.
• Working Directory for xp_cmdshell
• Write on "???" failed: 1117(The request could not be performed because of an I/O device error.)
• xp_cmdshell Error code 1385
• xp_cmdshell failed to execute because LogonUserW returns error 1326
• xp_create_subdir() returned error 183, 'Cannot create a file when that file already exists.'
• XP_DELETE_FILE doesn't work
• You do not have permission to run 'SP_TRACE_SETSTATUS'