SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Share tech news, updates, or what's on your mind.

Sign up to Post

We had a partner replace a drive on the database server, when he resorted the database(s) on Friday all are now in SUSPECT mode and are inaccessible. We are not dba's and need help can anyone please help.  Sql 2012 r2.

Thank you
SORRY I posted this in the incorrect place I will not do this again
0
 
LVL 12

Expert Comment

by:Alex Green
1
 
LVL 11

Administrative Comment

by:Andrew Leniart
Hi Steven,

What you have done is made a "Post" here.

To get expert help, you need to "Ask a Question" so that more experts are able to see that you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link also explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330

Regards,
Andrew
EE Topic Advisor
1
Database Solutions Engineer FAQs
LVL 2
Database Solutions Engineer FAQs

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller single-server environments.

A real head scratcher

SQL Server 2005
Web Service .Net Framework 3.5
Symbol MC3190
VB.NET Compact Framework 3.5

Dates consumed by the compact framework are shifted by the difference in the timezone between the server and the client.

Luckily for me the fix was as just a matter of setting the client machines timezone to that of the server.

Just putting it out there in case someone runs into something similar.

https://social.microsoft.com/Forums/en-US/9858d657-ce26-442a-86a7-e2ba6b774ebf/sync-framework-over-wcf-sql-2005-datetime-is-shifted-by-timezone?forum=syncgeneral


0
I have designed SSRS Report and Once I click on preview it is asking SQL Login details first time. I entered login details (sa, 123) after it was showed  report. On the DataSource double click => credential saved. Again it is asking to enter SQL Login credentials but I am not able to see any boxes on the top, it is showing only View Report.  
0
Can anyone explain this?

When looking for transactions based on timestamp in e.g. 2017 you can for instance do it like this:

...where timestamp >= to_date('2017','YYYY')
or
...where timestamp >=to_date('01.01.2017','DD.MM.YYYY')

Why does these two expressions return different number of transactions? In my case the latter returns appox. 8 times as many. Is this an error in Oracle SQL or is it something I have missed?

Thx!

Brgds
IVer Erling Årva, Oslo
0
 
LVL 13

Expert Comment

by:Alexander Eßer [Alex140181]
I don't think this is a bug, I suppose it's just the default behavior if you omit some time parts. I just can't find any evidence within the official docs. Maybe some other Oracle expter may help in finding that reference?!
0
 

Administrative Comment

by:South Mod
It seems this is a technical question, and therefore you should post this as a Question in the appropriate topics. The Posts feature is intended for members to share news, information, etc with others, and not to find a solution to a technical problem.
0
SQL PASS DBA Fundamentals mtg going on now.  Gail Shaw talking about Indexes, and her cat is talking back.  :-)  http://fundamentals.pass.org/
4
 
LVL 66

Expert Comment

by:Jim Horn
Joined.  Thanks for posting.
0

SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.