Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.

earned this badge 58 times.
Problem with charset on SQL*PLUS
Awarded Sep 17 at 10:57
How to PIVOT/UNPIVOT if I don't know how many columns will it have?
Awarded Aug 31 at 8:35
How to use IN to compare a single value with a comma separated field in another column [duplicate]
Awarded Aug 28 at 17:57
How to create a JOB for Azure SQL?
Awarded May 27 at 20:31
Strange SSIS-Package problem ( ASYNC_NETWORK_IO)
Awarded May 19 at 23:15
MySQL to SQL Server - Unixtime being major problem
Awarded Apr 23 at 8:10
Oracle losing connection ( ORA-03114 ) after some time not using the software
Awarded Jan 9 at 5:10
How to trace a query on Firebird?
Awarded Jan 3 at 15:10
SUM() 3 columns with alias into a fourth one
Awarded Dec 17 '19 at 19:00
How msdb.dbo.backupset works ( backup_size )
Awarded Nov 6 '19 at 22:00
Creating an index on a really busy table
Awarded Oct 22 '19 at 13:10
Best approach to mirror All databases of a sql server
Awarded Sep 30 '19 at 2:35
Trigger to change Database collation on creation
Awarded Sep 17 '19 at 10:55
How to add 1 milliseconds to a datetime string?
Awarded Jul 24 '19 at 12:50
What does 'Could not find a log backup file that could be applied' means on log shipping?
Awarded Jul 8 '19 at 14:15
Is it possible to alias a column based on the result of a select+where?
Awarded Jul 1 '19 at 13:30
Correct way to uninstall SQL Server 2008 ( or above )
Awarded Apr 19 '19 at 6:45
SQL Jobs logging only 2 days
Awarded Apr 15 '19 at 3:10
DBA Tasks ( SQL Server 2008 ) - Recommendation - Maintenance plan
Awarded Apr 8 '19 at 11:45
Please enlighten me about FILESTREAM and BLOB files
Awarded Apr 1 '19 at 14:15
How can I prevent oracle to create minidumps?
Awarded Apr 1 '19 at 6:10
What does “ISO standard equivalent” actually mean?
Awarded Mar 1 '19 at 3:45
Recover SA Password - PSTools - Not working
Awarded Feb 17 '19 at 6:15
Is it possible to use LAG() with WHERE?
Awarded Jan 26 '19 at 11:10
How to be sure that a SQL Script is running with ANSI encoding?
Awarded Sep 28 '18 at 0:15
Use random string variable in a insert
Awarded Aug 19 '18 at 5:35
Concatenate with NULL values ( Should not replace NULL )
Awarded Aug 8 '18 at 13:50
turn off (synchronized) database
Awarded Jul 31 '18 at 12:00
Is VSS Backup a better solution than the native backup?
Awarded Jul 20 '18 at 4:31
What does 'sp_configure allow updates' do?
Awarded Jul 14 '18 at 11:34
How to create a Linked Server from SQL Server 2008 to DB2?
Awarded Jun 26 '18 at 13:45
Delete millions of rows disabling Indexes
Awarded Jun 6 '18 at 16:00
Stored procedure runs forever, but inner query runs fine
Awarded Jun 6 '18 at 13:59
sys.sp_reset_connection. Why theres a lot of them ?
Awarded May 8 '18 at 17:30
Update linked server table based on local table
Awarded May 3 '18 at 12:54
Why does SQL Server return some rows while still executing the query, and sometimes not?
Awarded Apr 14 '18 at 4:02
How Can I Monitor SQL service with Zabbix?
Awarded Feb 3 '18 at 20:54
Report Server ( [162] Internal request to deactivate schedule ) error ( SQL Server 2008 R2 )
Awarded Dec 27 '17 at 8:48
Trace to find “error messages”( SQL Server 2008 R2 )
Awarded Dec 14 '17 at 13:20
How can we improve this PIVOT operation? ( SQL Server 2008 R2 )
Awarded Dec 8 '17 at 14:13
Create a monthly job to export from SQL Server 2014 to Excel
Awarded Oct 5 '17 at 9:54
Is there a way to run this query in all databases ? ( SQL Server 2008 R2 )
Awarded Sep 25 '17 at 20:40
Better approach for “LIKE OR LIKE, OR LIKE, OR LIKE, OR LIKE”
Awarded Aug 3 '17 at 23:32
Set “Encryption Enabled” to FALSE…what can go wrong?
Awarded Jul 27 '17 at 17:27
Restore Database using GUI - Wrong file to restore
Awarded Apr 17 '17 at 14:33
Lots of “FETCH API_CURSOR0000…” on sp_WhoIsActive ( SQL Server 2008 R2 )
Awarded Dec 5 '16 at 20:54
Accidentally change database name (SQL Server 2008)
Awarded Nov 22 '16 at 13:52
Is adding the ‘tbl’ prefix to table names really a problem?
Awarded Nov 4 '16 at 17:07
Who created a procedure? (SQL Server 2008 R2 )
Awarded Aug 19 '16 at 7:15
Log Shipping “out of sync” but none of the jobs are failing
Awarded Aug 8 '16 at 23:58
How to define the logical name in a backup ? ( Sql Server 2008 )
Awarded Jul 28 '16 at 15:17
Delete files from disk, with a job, respecting some rules ( SQL Server 2008 ) [closed]
Awarded Jun 3 '16 at 13:26
Error with FUNCTION ( SQL Server 2008 ) - ''Cannot find either column…'
Awarded Mar 29 '16 at 15:20
FOR XML could not serialize the data because it contains character (0x0000)
Awarded Feb 18 '16 at 15:28
Error: Cannot Generate SSPI context
Awarded Feb 11 '16 at 13:15
List all databases of a certain user ( SQL Server 2008 R2 )
Awarded Jan 15 '16 at 6:51
high PAGEIOLATCH_SH waits on server [closed]
Awarded Dec 21 '15 at 1:39
trigger - Sql2008 - Msg 7391 - “no transaction is active/unable to begin trans”
Awarded Oct 29 '15 at 20:04

Others with this badge