Microsoft SQL Server

161K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

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

Sign up to Post

Keep up with what's happening at Experts Exchange!
LVL 12
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

When a customer asks you for something try to your best to understand what exactly he wants to accomplish and not really on what he says he wants, be clear with him what this will be used for before you make a recommendation, take your time, and discuss. for example a client ask me for a NAS drive so he can have all file in his office in a central location and all his staff can access it. Then he calls up that he moved his quickbooks file to the NAS drive and quickbooks does not work, of course it does work, quickbook needs its network manager installed in the same place where the file is and the network manager is a windows based application not Linux. Then he wanted his ticketing program file on the NAS, again sql is not supported on a Linux, would I know more details I would recommend him one model higher than the one I gave him which support a vm where he would be able to have a window machine on.
1
LVL 44

Expert Comment

by:noci
hm. does it support iSCSI?, then you can store data on the NAS while the processing is on one "server" outside of the box...
Sometimes  think out of the box.
0
I'm using VS2010 with SQL Server back end and would now like to start using Data Source to connect rather then coding in appconfig. Can you refer me to an example please.
0
LVL 16

Expert Comment

by:Dustin Saunders
Frank,

Looks like you made this a post rather than a question.  You may want to open up a new Question to attract answers to your query.
0

Author Comment

by:Frank De Carpenter
Sorry about this Dustin. I will change it a question. Thanks
0
sql query
i have a table which has got market name, balance and datediff shows how many day between getdate() - invoice date
select market,convert(varchar,convert(money,sum(balance),1)) as [AR Receivables] from #arreceivables group by market order by market

i am trying to get like eg: market name total balance between 0 -30 days 30 -60 days, 60 -90 days and 90 + days.

Can someone help me with the query please
0
LVL 26

Expert Comment

by:Brian B
You have entered this as a post, but it looks like you are asking for help. To get the best response from the Experts, you should probably re-submit this as a question using the "ask a question" button at the top of the page, or this link: https://www.experts-exchange.com/askQuestion.jsp

If you do ask a question, please post the link to it back here so others can find your question and help you more quickly.

Please see here for further details: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
Your access to October’s Course of the Month expires today! Enroll now and begin adding Microsoft SQL to your professional skills.
0
v2-native-ad-no-button.pngOnly five days left to enroll in October’s Course of the Month! Once you enroll, you’ll have 30 days to complete the Microsoft SQL Server and Database Concepts course.
0
native-ad-no-button.pngThe end of October is approaching and you only have nine days left to enroll in our Microsoft SQL Server and Database Concepts course. Enroll today and take advantage of this complimentary Course of the Month training.
4
Have you enrolled in this month’s complimentary course? Enroll now for a free Microsoft SQL Server and Database Concepts course. Get 7+ hours of step-by-step SQL training, including possible topic interview questions.
0
I've a stored procedure SP1 built. It has 8 columns n 6 rows. I also created a table T1 with exact 8 columns as SP1 and this table is empty. How do I insert 6 rows from SP1 into T1? Does the insert statement need to be inside the stored proc SP1 or can be it a separate query?
0
LVL 127

Expert Comment

by:Andrew Hancock (VMware vExpert / EE MVE^2)
You may want to post this Question, in the Microsoft SQL Server, SQL, Query Syntax topic areas, to get an Answer.
0

Author Comment

by:LION KING
Thank you Andrew.
0
How to create a 4 quarter rolling calendar / period in sql server? For instance, if Table A as a date field - DATE1.
0
Ultimate Tool Kit for Technology Solution Provider
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

v2-native-ad-no-button.pngDo you work with and analyze data? Enroll in October’s Course of the Month to get step-by-step SQL training. Learn SQL to quickly and efficiently store and retrieve data!
0
native-ad-no-button.pngOctober’s Course of the Month is available! Enroll today to get 7+ hours of step-by-step Microsoft SQL Server training.
4
hi i  have 3 tables in sql server and i want to save all 3 table data into one new table WIN_20170930_221232.JPG
any help me?
0
LVL 61

Expert Comment

by:Kevin Cross
You should post this as a Question and it will draw in Experts within the areas you designate.  It looks like you will want to ask about how to JOIN data.  Good luck!

Ref: http://support.experts-exchange.com/customer/portal/articles/756544-how-to-succeed-at-ee-as-an-asker
0
LVL 61

Expert Comment

by:Kevin Cross
Welcome to Experts Exchange by the way!
0
2
1
We are importing (Bulk Insert) of around half million records to the staging table and then to the production table.

More often column data type or size validation fails the bulk insert process from Staging table to the Production table.

I will have to redesign the process by SSIS packages by inserting all the good records from Staging to the Production and load the bad / error out data to the staging table. Those bad or error out data with proper validation message.

Validation message is based on first error out column. If the all the columns in that row are erroring, we can consider with the first column error and reload the data after fixing that data.

Example Error Message: Column PurchaseDate has invalid data

How do I achieve this complete workflow SSIS package. What are the controls, I need to use to start with?

Please :)
0
LVL 19

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, 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

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

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
How to design a Hierarchy based Table Relation?


To give an example: Organizational Chart. I am actually working on a Product based database.  Lacking in the design.
0
LVL 19

Administrative Comment

by:Andrew Leniart
Hi chokka,

What you have done is made a "Post" here. To get help from the experts, 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

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

Hope that's helpful.

Regards,
Andrew
EE Topic Advisor
0
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
Watching Paul Randal's course SQL Server: Performance Troubleshooting Using Wait Statistics on Pluralsight to help troubleshoot competing production processes and SQL Agent jobs.
0
Cloud Class® Course: Ruby Fundamentals
LVL 12
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

0
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
Today is the last day to enroll in the free course of the month! Premium members, Team account members, and Qualified Experts can enroll in the CompTIA A+ course as part of their membership. Once you enroll you have 30 days to complete the course. Take advantage of this month's course today!

7
LVL 19

Expert Comment

by:Andrew Leniart
Not meaning to be pedantic, but you actually get 31 days to complete the course :)  I've just gone through the first section myself and can highly recommend this course. The instructor and content is excellent. Very informative.
4
LVL 17

Expert Comment

by:Spike99
Cool, I'll try it. Thanks for the head's up.
1
10
I'm glad to see Liquidweb is a new topic here. They have been my web host of choice since about 2008 or 9 and I have twenty some posts here on why I like LW https://www.experts-exchange.com/questions/28434976/recommend-a-hosting-provider.html#a40069498

They completely helped me from migration from a previous host and through several critical server upgrades VPS -> dedicated windows server 2003->2008->2012.  Whenever I have an issue, the person that takes the ticket is friendly and very knowledgeable. Other hosting services I have used, a help call or ticket starts at a low level and has to get escalated. At LW, 99% of the time, the person that you initially contact is the person that fixes the issue be it by submitted ticket or a panicky phone call.

One of the add on services I use for my dedicated server is continuous back up on my SQL Server drive. I have client billing systems on this server and one time did encounter a crash. Because of the continuous back up, no data was lost and everything was restored in quick manner.
11

Microsoft SQL Server

161K

Solutions

49K

Contributors

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.