Database Administrators

Popular Question

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

earned this badge 66 times.
Which fillfactor is used by ALTER INDEX REBUILD?
Awarded Jan 25 at 11:05
How to query status changes in time series?
Awarded Dec 16, 2020 at 15:41
How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?
Awarded Apr 30, 2020 at 15:26
Did anybody use sqlcmd mode in practice? [closed]
Awarded Mar 27, 2020 at 20:15
Casesensitive vs. Caseinsensitive Collatesequences?
Awarded Jun 18, 2018 at 13:13
Guarantee SQL Server Identity Columns that two consecutive values differ by constant increments?
Awarded Feb 13, 2018 at 21:35
Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?
Awarded Nov 29, 2017 at 12:14
Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0
Awarded Oct 12, 2017 at 6:09
Can IMPLICIT_TRANSACTIONS set on database level?
Awarded Jan 28, 2017 at 16:24
Can I implement a 'gapless' identity column in Oracle?
Awarded Oct 20, 2016 at 10:50
Are there any reasons not enable SQLCMD-mode as default in SSMS?
Awarded Jul 14, 2016 at 7:27
Why do primary keys have names of their own?
Awarded Mar 28, 2015 at 2:58
Isn't a tab (char(9) ) whitespace in the ANSI/ISO SQL-92 specification (Section 8.2, , General rules #3)?
Awarded Jan 26, 2015 at 21:01
Best method to give two Oracle databases on the same server access to common data
Awarded Oct 21, 2014 at 0:44
Is it possible with SQL Server 2008 to have a Partioned Tables with an Identity Column?
Awarded Oct 17, 2014 at 12:52
Mapping SQL Server integer to Oracle Datatype
Awarded Jul 27, 2014 at 7:24
How can can I get object definitions stripped of all comments?
Awarded Jun 25, 2014 at 21:09
Can I call SMO from pure T-SQL?
Awarded May 30, 2014 at 12:11
Has somebody got a function that will extend hashbytes to strings of arbitrary length?
Awarded May 13, 2014 at 8:36
How to drop SQL Server database currently in use and in Single user mode
Awarded May 8, 2014 at 4:51
What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?
Awarded Mar 28, 2014 at 9:42
Why is this rollback needed when using sp_addextendedproperty in a stored procedure?
Awarded Mar 6, 2014 at 11:37
Which workarounds exists to missing relative path feature of SQLCMD :r?
Awarded Feb 13, 2014 at 18:13
What is the meaning of Microsoft Compatibility Level?
Awarded Jan 7, 2014 at 15:15
What are the benefits of using a different tablespace for a new user schema?
Awarded Jan 6, 2014 at 16:34
How to query given grants on Oracle?
Awarded Dec 11, 2013 at 14:48
How can I query the SQL Server Compatibility Level into a variable?
Awarded Nov 29, 2013 at 11:04
What is the purpose of sqlbulkcopy's useinternaltransaction property?
Awarded Nov 16, 2013 at 18:32
What is the replacement for EXEC sp_dboption <dbname> in SQL Server 2012?
Awarded Nov 1, 2013 at 20:27
Does it make sense to use SQL Server's bracket notation in hand written code?
Awarded Oct 2, 2013 at 9:46
Recovering from: A transport-level error has occurred when sending the request to the server in SSMS
Awarded Aug 30, 2013 at 10:09
How to convert primary keys into clustered primary keys for a great number of tables keeping referential identity
Awarded Aug 14, 2013 at 14:48
Are there ways to only replace SQL Server stored procedures when the definition has changed?
Awarded Jul 9, 2013 at 7:22
I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
Awarded Jun 17, 2013 at 14:55
Is 'Avoid creating a clustered index based on an incrementing key' a myth from SQL Server 2000 days?
Awarded May 22, 2013 at 17:15
How to write a check constraint to disallow empty varchar fields?
Awarded May 6, 2013 at 11:53
Empty Strings: Why or when is '' equal to ' '?
Awarded May 2, 2013 at 1:13
How to use transactions with SQL Server DDL?
Awarded Mar 22, 2013 at 7:55
Building Dynamic SQL-Server Where Clause
Awarded Mar 20, 2013 at 13:56
How to migrate SQL Server Stored Procedures using temporary tables or table variables to Oracle?
Awarded Mar 7, 2013 at 14:30
How can I assign different random values to each row in a SELECT statement?
Awarded Feb 26, 2013 at 15:26
Why are Denali sequences supposed to perform better than identity columns?
Awarded Feb 24, 2013 at 1:17
How can I catch the output of DBMS_OUTPUT.PUT_LINE when executing a block using [Oracle.DataAccess.Client]?
Awarded Feb 5, 2013 at 13:55
How to catch and handle only specific Oracle exceptions?
Awarded Jan 30, 2013 at 18:52
Has SELECT an INSERT clause?
Awarded Jan 30, 2013 at 7:27
How to handle multiple Oracle homes?
Awarded Jan 9, 2013 at 10:52
How is localhost resolved by Oracle listener?
Awarded Jan 7, 2013 at 12:56
What does TOAD do, when I terminate script execution?
Awarded Dec 4, 2012 at 7:45
How to replace a CLOB column by a varchar2(4000) column?
Awarded Dec 3, 2012 at 13:55
Can I enable SQLCMD mode from inside a script?
Awarded Nov 20, 2012 at 14:03
How to return a CTE as REFCURSOR from an Oracle stored procedure?
Awarded Nov 9, 2012 at 22:21
Why does SQL*PLUS need a slash after CREATE TYPE?
Awarded Oct 24, 2012 at 12:57
Which problems arise, declaring the size of all varchar parameters as max in stored proc?
Awarded Oct 9, 2012 at 21:37
Login Problem as SYSDBA ORA-01031
Awarded Sep 18, 2012 at 13:26
How to export a single huge table from SQL Server?
Awarded Aug 14, 2012 at 9:00
How to combine date and time to datetime in SQL Server?
Awarded Jul 17, 2012 at 5:02
How do I copy a table with SELECT INTO but ignore the IDENTITY property?
Awarded May 15, 2012 at 18:33
Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?
Awarded May 14, 2012 at 10:03
How to configure an Oracle Listener without SID_LIST_LISTENER in listener.ora?
Awarded May 3, 2012 at 8:25
ORA-01502: index or partition of such index is in usable state problem
Awarded Apr 30, 2012 at 19:29
1
2

Others with this badge

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.