User Racer SQL

0

votes

1

answer

43

views

why a convert from varchar do date fails on a different row everytime it runs?

sql-server-2008-r2

Jan 13 at 21:50 Josh Darnell 18.4k

0

votes

1

answer

47

views

How can a field with multiple values be used with SQL Server?

sql-server-2012

Jan 10 at 15:27 a_horse_with_no_name 53.9k

1

0

votes

2

answers

931

views

How to PIVOT/UNPIVOT if I don't know how many columns will it have?

Jan 2 at 19:15 Racer SQL 6,274

0

votes

0

answers

59

views

ACE.OLEDB.12.0 is visible on Linked Servers Provider, still can't import EXCEL file

sql-server

Dec 12 at 16:43 Racer SQL 6,274

0

votes

1

answer

29

views

How to convert a VARCHAR DD/MM/YYYY H:MM:SS AM into datetime and then to Json date?

sql-server-2014

Nov 11 at 15:41 eagle275 624

0

votes

1

answer

283

views

I'm not understanding the concept of login/user on Azure [closed]

ssms azure-sql-database

Oct 25 at 18:07 Kin Shah 58.2k

0

votes

2

answers

722

views

How to use IN to compare a single value with a comma separated field in another column [duplicate]

sql-server sql-server-2012

Sep 17 at 23:40 Chris Rolliston 325

0

votes

0

answers

62

views

Faster export option for noSQLBooster ( Mongodb )

mongodb-3.6 mongodb-atlas

Aug 29 at 20:02 Racer SQL 6,274

0

votes

2

answers

41

views

How is my software conecting on my SQL Server if it failover via availability groups?

sql-server-2014

Aug 23 at 20:21 Shekar Kola 1,667

0

votes

0

answers

48

views

Schedule a job - Mongodb - Run a view every day

mongodb-4.0

Aug 23 at 14:34 xzilla 424

0

votes

1

answer

44

views

MongoDB is not using the index I created for this specific query

index mongodb

Aug 16 at 17:33 Racer SQL 6,274

0

votes

0

answers

6

views

how can I translate a “include” column in a index from sql server to mongodb?

index mongodb-3.0

Aug 8 at 14:22 Racer SQL 6,274

0

votes

0

answers

11

views

How to insert new document with an aditional atribute in a document with something like Datetime() from sql?

mongodb-4.0

Aug 5 at 18:36 Racer SQL 6,274

0

votes

1

answer

47

views

Confusion about HA , LOG backups and availability

sql-server-2014 availability-groups

Aug 2 at 9:52 Sean Gallardy - Retired User 20.5k

0

votes

1

answer

41

views

How to add a fixed string to a mongoDB result like we do we in SQL Server?

mongodb

Jul 27 at 3:05 Stennie 8,375

0

votes

1

answer

51

views

Executing an oracle variable string as I do in SQL Server

oracle-11g-r2 plsql dynamic-sql

Jul 1 at 21:21 eckes 1,338

0

votes

0

answers

30

views

Resizing and reclaiming free space on Tablespaces

oracle-11g

Jun 10 '19 at 13:38 Racer SQL 6,274

0

votes

1

answer

3k

views

How can I prevent oracle to create minidumps?

oracle-11g-r2

May 24 '19 at 14:48 Racer SQL 6,274

0

votes

0

answers

32

views

How to better deal with INSERT if new, UPDATE if exists (70million rows)

sql-server-2008-r2

Apr 8 '19 at 12:14 Racer SQL 6,274

0

votes

1

answer

81

views

Query to obtain indexes information - why does it produce duplicated values?

sql-server sql-server-2008-r2

Mar 26 '19 at 21:37 MDCCL 7,539

0

votes

2

answers

41

views

There's a SQL trace file being populated every day. How can I find the routine running the trace file populating it with data?

sql-server-2008-r2

Mar 13 '19 at 19:50 Doug Deden 992

0

votes

1

answer

43

views

Best approach to run a simple query against all users

oracle

Feb 20 '19 at 13:04 kevinsky 4,114

0

votes

1

answer

65

views

Question about Dumps in Oracle (REMAP_SCHEMA)

oracle dump

Dec 21 '18 at 0:33 Balazs Papp 32.6k

0

votes

2

answers

780

views

Information_Schema on oracle?

oracle information-schema

Dec 4 '18 at 12:44 a_horse_with_no_name 53.9k

0

votes

1

answer

31

views

Really Small details about storage ( data size ) on columns

sql-server-2008-r2

Oct 18 '18 at 16:04 Forrest 3,810

0

votes

1

answer

52

views

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

sql-server sql-server-2008-r2 alter-table disk-space

Oct 18 '18 at 4:10 Paul White 9♦ 54.5k

0

votes

1

answer

132

views

ACE.OLEDB.12 installed but everything has a 0 on sp_msset_oledb_prop

sql-server-2008

Oct 16 '18 at 12:44 Erik Darling 30k

0

votes

1

answer

52

views

Users running ANSI scripts are having problems with special characers [closed]

oracle encoding

Sep 24 '18 at 17:02 Max Vernon 61.4k

0

votes

0

answers

39

views

Is there a better way to DENY SYS schema and INFORMATION-SCHEMA to DBO user?

sql-server-2008-r2

Sep 3 '18 at 15:02 Racer SQL 6,274

0

votes

2

answers

30

views

How can I track if a trace is executing?

sql-server sql-server-2008-r2 trace

Aug 28 '18 at 13:38 Tom V - try topanswers.xyz 15.1k

Stack Exchange Network

current community

your communities

more stack exchange communities

Next badge

194 Questions

why a convert from varchar do date fails on a different row everytime it runs?

How can a field with multiple values be used with SQL Server?

How to PIVOT/UNPIVOT if I don't know how many columns will it have?

ACE.OLEDB.12.0 is visible on Linked Servers Provider, still can't import EXCEL file

How to convert a VARCHAR DD/MM/YYYY H:MM:SS AM into datetime and then to Json date?

I'm not understanding the concept of login/user on Azure [closed]

How to use IN to compare a single value with a comma separated field in another column [duplicate]

Faster export option for noSQLBooster ( Mongodb )

How is my software conecting on my SQL Server if it failover via availability groups?

Schedule a job - Mongodb - Run a view every day

MongoDB is not using the index I created for this specific query

how can I translate a “include” column in a index from sql server to mongodb?

How to insert new document with an aditional atribute in a document with something like Datetime() from sql?

Confusion about HA , LOG backups and availability

How to add a fixed string to a mongoDB result like we do we in SQL Server?

Executing an oracle variable string as I do in SQL Server

Resizing and reclaiming free space on Tablespaces

How can I prevent oracle to create minidumps?

How to better deal with INSERT if new, UPDATE if exists (70million rows)

Query to obtain indexes information - why does it produce duplicated values?

There's a SQL trace file being populated every day. How can I find the routine running the trace file populating it with data?

Best approach to run a simple query against all users

Question about Dumps in Oracle (REMAP_SCHEMA)

Information_Schema on oracle?

Really Small details about storage ( data size ) on columns

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

ACE.OLEDB.12 installed but everything has a 0 on sp_msset_oledb_prop

Users running ANSI scripts are having problems with special characers [closed]

Is there a better way to DENY SYS schema and INFORMATION-SCHEMA to DBO user?

How can I track if a trace is executing?