Student Needs Help With Editions

Oct 18, 2007

I am starting a class on SQL Server, and my school wants me to build
db's either on campus or remotely at my home connecting to their SQL
Server Enterprise.

Will I be okay to use Developer Edition at home to connect with an
Enterprise-licensed SQL Server on campus, to build databases,
sprocs, .net apps that connect to the database stored on my school's
server?

I would rather avoid the Express edition.

thanks

View 1 Replies


ADVERTISEMENT

Student Who Wants To Dba

Jan 10, 2005

i'm currently a student in computer information sciences, and i wanted to give my studying some more focus thus choosing dba. now i'd like to dba but be as broad as possible when i first start out my career. i know some programming languages and recently finished a C# book for doing .net development and a ASP.net book for scripting. but where should i go from here? should i just start studying ms sql server? what about a microsoft certification? i'm very curious to know where the next step in my studying should be, so anyone who was in my shoes, i'd love to hear any information you have to offer. TIA

View 14 Replies View Related

Beginner Student PL/SQL To T-SQL

Jul 23, 2005

Hi,I'm finishing up a beginning SQL class where we learned on an Oracledatabase and the transition to working on SQL Server is easy. The next moreadvanced course will be in PL/SQL, but I know I will be working on SQLServer in the workplace, so my question is if I should take this course.Will I benefit from the basic philosophies that will be covered, or will itjust make a transition for me more difficult? Will it be partly a waste oftime and money and I'd be better served getting a book and self teachingmyself? I know that in a greater sense learning something isn't necessarilya waste, but I mean from the perspective of my goal of being able to use SqlServer, will this course be useful?thanks.

View 10 Replies View Related

A Student Would Like To Know What A Database Administrator Does.. Thank You

Jan 18, 2008

I'm a kid and I'd like to know what kind of work a database administrator does. It would be great to learn from a real database administrator how you spend your typical day at the office. What are some of your main duties? Thanks so much in advance.

View 1 Replies View Related

SQL 7 Different Editions

Feb 12, 1999

Hi,
I need to know what is the exact difference between
different Editions of SQL 7. Cost of SQL 7 Enterprise Edition is 5 times
that of Developer's Edition of SQL 7. Also there is other edition called
Standard Edition. At least i would like to know where can i get this information
immidiately.

ThanX,

Gunvant Patil
( gunvantp@mail.usa.com )

View 1 Replies View Related

Different SQL Editions From The Same CD?!

Jan 22, 2007

Hi

I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.

When I install this on my Laptop the version is 2000(print @@version) is only Desktop version (2gb db limit!)....

Any ideas on why the full enterprise edition is not installing on the laptop?!!

Version on my Desktop:
MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86)
OCT 14 2005 00.33.37
1988-2005 microsoft corp
enterprise edition on windows NT 5.2 (build 3790-service pack)

Version on my laptop:
MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86)
May 14 2005 23:18:38
Copyright (c) 1988-2005 Microsoft Corporation
desktop engine on windows NT 5.1 (build 2600: service pack 2)

The Laptop spec is:
Intel 1.66Ghz
1 Gb Ram
50 Gb HDD
Windows XP SP2

Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?

Thanks in advance!

David

View 3 Replies View Related

Calculating Average For Each Student And Get The Highest

Feb 12, 2013

I want to calculate average of grades of each student and get the highest one with SQL command.

I have 2 tables:

Students:
*StudentId
*StudentName
___________
Grades:
*StudentId
*Grade
___________

I need to calculate average of each student and then get the highest.

My try:

Code:
SELECT Students.StudentId,Students.StudentName,AVG(Grades.Grade) AS avg_grade FROM Students s JOIN Grades g ON Grades.StudentId =Students.StudentId
GROUP BY Students.StudentId, Students.StudentName

ORDER BY avg_grade
LIMIT 1 FROM Students;

I encounter problem with this code, maybe it's Completely wrong...

View 5 Replies View Related

How To Find Age And Group By Student Number Like (IT%)

Aug 4, 2013

I have created a table:

CREATE TABLE [dbo].[Student](
[StudentNumber] [varchar](50) NOT NULL,
[Name] [char](50) NOT NULL,
[Contact] [int] NOT NULL,
[Address] [char](50) NOT NULL,
[DateOfBirth] [datetime] NOT NULL,
[YearEnrolled] [int] NOT NULL,
[Year] [int] NOT NULL;

And insert the following data:

INSERT INTO Student VALUES('IT123456X', 'Ahmad Adam','05-18-1997', '33 Mangis Rod', 19970518, 2013, 1);
INSERT INTO Student VALUES('IT334455U', 'Mary Tan', '01-23-1996', '51 Koon Seng Road', 23-01-1996, 2012, 1);
INSERT INTO Student VALUES('BS123456X', 'Samuel Lee', '03-30-1997', '2 Joo Chiat Lane', 30-03-1997, 2013, 1);
INSERT INTO Student VALUES('BS234234Z', 'Nathaniel Koh', '12-08-1997', '5 Stll Road', 08-12-1997, 2013, 1);
INSERT INTO Student VALUES('BS987987F', 'Siti Faridah', '07-04-1995', '3 Duku Road', 04-07-1995, 2011, 3)

How do i calculate the age and how can i group by the StudentNumber like 'IT%'

View 3 Replies View Related

Transact SQL :: How To Upgrade Student Grade Only

Jun 9, 2015

We have SQL database now a days we are planing to update our students ID Records but i don't know the exact query for this. Table format is below

StudentID                          Name
500132253/Prep               Aslam
112344883/Prep               Ali
451132537/Prep               Ahmed

Now i want to update only the grade from prep to KG-1 without update the registration number only prep to kg-1. in one column there is student register number and after slash the grade.

View 6 Replies View Related

Need To Identify Student With Multiple Id Numbers

Jan 17, 2008

My working table:


CREATE TABLE [dbo].[Name_ID4](

[id_num] [decimal](18, 0) IDENTITY(1,1) NOT NULL,

[student_last_name] [varchar](30) NULL,

[student_first_name] [varchar](30) NULL,

[student_middle_init] [varchar](1) NULL

[local_student_id] [bigint] NULL,


I need to identify only the students with more than one local_student_id and the associated local_student_id's.

I can identify the students with two id's but not the associated id's


SELECT COUNT(*) AS Dup_Num,

rtrim(student_last_name),

rtrim(student_first_name),

rtrim(student_middle_init),

from Name_ID4

group by

student_last_name,

student_first_name,

student_middle_init,

having (count(*) > 1)

order by student_last_name, student_first_name, student_middle_init

Thanks

View 4 Replies View Related

Only Max Date Record Should Be Shown For Every Student

May 25, 2015

I have a table which shows data in below format

Now I need that only the max date record should be shown for every student as shown below...

View 8 Replies View Related

Sql Server Editions

Sep 18, 2007

Hi,

1)
Which version of sql server do I need to be able to install it on my local win xp pro? At present there is no server.
I guess the answer is standard edition and not the enterprise, right?

2)
At present I have the enterprise edition CDs. If I install the Enterprise edition then does that mean on my xp pro I will have standard edition?

Thanks

View 6 Replies View Related

SQL 2005 Editions

Apr 9, 2007

Hi,


We've DEV, Test and Prod machines.

Is it required to have all the three machines with Enterprise Editions?
OR
Can we install SQL Developer Edition on both DEV and TEST and have Enterprise Edition on production?

Please advise.

TIA,
Siva.

View 1 Replies View Related

Find 90th Percentile Scores For Each Student

Sep 15, 2006

I am stumped on a set-based approach for this one.

A cursor approach is straightforward enough, but i want to avoid that.

Here's my table:

create table StudentScores
(
id int primary key identity(1,1),
student_id int not null,
score int not null
)

with some sample data:

insert into StudentScores (student_id, score)
select 1, 10 union all
select 1, 29 union all
select 1, 50 union all
select 1, 53 union all
select 1, 45 union all
select 1, 10 union all
select 1, 29 union all
select 1, 50 union all
select 1, 53 union all
select 1, 45 union all
select 1, 88 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 23 union all
select 2, 54 union all
select 2, 55 union all
select 2, 34 union all
select 2, 56 union all
select 2, 78 union all
select 2, 98


What I want is, for each student, what is their 90th percentile score?

For a given single student, one possibility would be:

declare @studentid int
set @studentid = 2
select top 1 @studentid as student_id, a.score as [90th percentile score]
from
(
select top 90 percent score from StudentScores
where student_id = @studentid order by score asc
) as a
order by a.score desc

But I want this for all students, and not use a cursor.

Any ideas?

Thanks!

View 6 Replies View Related

Average Number Of Contact Hours Per Student

Feb 20, 2012

I am trying to find out the the Average number of contact hours per student. in Reporting Services 2005. The contact hours is the in the Totaltime field

Is this formula correct

=Sum(Fields!TotalTime.Value)/Avg(Fields!TotalTime.Value) is in the =Fields!StateServices.Value Group

My groups are

=Fields!Student_ID.Value
=Fields!StateCategory.Value
=Fields!StateServices.Value

Code:

SELECT Student_ind.[Student ID], ParticipantActivity.ActivityDate, School_tbl.[Studentschool Id], School_tbl.schoolID, ParticipantActivity.TotalTime,
ParticipantActivity.Services, ParticipantActivity.Activity, Student_ind.SSID, ParticipantActivity.StateCategory, ParticipantActivity.StateServices
FROM ParticipantActivity INNER JOIN
School_tbl INNER JOIN
Student_ind ON School_tbl.[Student ID] = Student_ind.[Student ID] ON ParticipantActivity.[Student ID] = Student_ind.[Student ID]

[code]....

View 6 Replies View Related

Dose MS Sell SQlSerever With Student Rate?

Apr 4, 2006

Dose MS sell SQlSerever with student rate? If so, which website do Ibuy from?

View 10 Replies View Related

SQL Server 2005 Editions

Nov 8, 2007

1. The Workgroup Edition comes with Windows SBS Server/Premium. However the docs for SQL/Server 2005 say not to install it on a Domain Controller. What does this mean--buy a separate box for the SQL Server software? If so with which OS?

2. If we get Windows SBS Standard, could we just install/download SQL Express on that Server? Even if it's a Domain Controller?

2. If a client is running an app on SQL Server 7, and wants to upgrade to 2005 (3-5 simultaneous uses of a DB about 1GB), which edition should we get?

thank you in advance ...

View 6 Replies View Related

Standard Vs. Enterprise Editions

May 28, 2008

hello all,
has anyone attempted (or succesfully implemented) a solution using Standard Edition, **as a replacement** for Enterprise Edition, in a multi-partition environment?

I believe one can use external partitions in SSAS to draw data from SQL Server, I'm not sure if that's a feature that works with the Standard Ed. of SSAS.

Namely, I'd like to see if I can use a setup of 4 installs of SQL Server, Standard Edition, and use that as a feed data into SSAS Standard Edition, and save some money on licensing (probably at a cost of increased maintenance). I know that the Enterprise version also has some enhanced analytics functions and other cool stuff so that'll be lost as well, with this potential setup.

My inclination is that to use external/Remote Partitions one would still need to use the Enterprise Edition, making this the only choice, for large cube builds -- but I may be wrong.

thanks much for any feedback,
Cos

View 3 Replies View Related

Attendance Records - Bulk Insert In Student Database

Apr 5, 2012

I have a csv that contains attendance records that I get daily from a 3rd party grade book solution. I need to import directly into the attend table in our student database.

Code:
Attend File-"1112","0021","404550","20120402","ABU","2300000","06","05"

The file is setup as follows, School Year, school number, student_id, absence date, absence code, course number, section number.

I need to check the student schedule to see if they are scheduled for that class when the import runs. So if they had a schedule change in the middle of the day it won't post attend to a dropped class.

I have done something similar to this before with the way I export teachers out to our grade book. I have it check the master schedule to see if the teacher is teaching at least one class, that way it won't export tutors and office staff to the grade book. I used the script below to do that but not sure who to apply it to a bulk insert.

Code:
Script Used to export teachers note last four lines, checks master
USE [GSchool]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON

[Code] ....

Secondly I need to check the date of the record and overwrite a record if one already exists for that exact course and section for that student, I need this because if they make changes to a previous day from absence un excused to excused I need to get rid of the unexcused by overwriting it.

One more thing that would be nice but is optional, is there a way to send log of errors on the import via email?

View 3 Replies View Related

Data Access :: How To Compute Student Grade In Server

Nov 21, 2015

i am having problem putting this query to calculate students grade using the condition and legend bellow.

WHEN EXAMS BETWEEN 75 AND 100 THEN 'A'
WHEN EXAMS BETWEEN 70 AND 74 THEN 'AB'
WHEN EXAMS BETWEEN 65 AND 69 THEN 'B'
WHEN EXAMS BETWEEN 60 AND 64 THEN 'BC'

[code]...

View 7 Replies View Related

Find Highest Marks In Student Table Query

Oct 9, 2007



Hi Everybody
I've one table named Student. Here is data







Name
Subject
Mraks





Prasad
English
80

Tushar
English
79

Sunil
English
78

Prasad
Geometry
80

Tushar
Geometry
81

Sunil
Geometry
79

Prasad
History
82

Tushar
History
81

Sunil
History
80


Now I want to write a query that displays student with subjects and marks who secured highest marks in each subject.
I want to output like this





Name
Subject
Mraks





Prasad
English
80

Tushar
Geometry
81

Prasad
History
82

So will anybody help me to write a sql query that acheive the same output

View 5 Replies View Related

Transact SQL :: Retrieve Last Class Attended By The Student Using JOIN

May 14, 2015

In my query, I am showing Student Record and also want to retrieve the last class attended by the student using JOIN to the table (ClassHistory).

Master
ID     Student_Name
1     Arindam
2     Brenda
3     Callie

(ClassHistory)
ID     Class     Year
1     4           2003
1     5           2004
1     6           2005
2     4          2003
2     5          2004
3     4          2003

DESIRED RESULTSET
ID    Student_Name    Class Record
1    Arindam                   6
2    Brenda                     5
3    Callie                       4

The result is like - Arindam last class was Class 6, while Brenda was in Class 5 and Callie was in class 4.

Please note that the query will b part of a larger query and the Class record to be retrieved from ClassHistory if possible need to be retrieved through JOIN.

View 7 Replies View Related

Question About Standard / Enterprise Editions

Jan 14, 2008

Can either of these be installed on a laptop?

Thanks,

Jaybee.

View 3 Replies View Related

Different SQL Server 2005 Editions From The Same Installation CD?!

Jan 23, 2007

Hi

I have the SQL Server 2005 Enterprise Edition CD and have succesfully installed this on my desktop.

When I install this on my Laptop the version is 2000(print @@version) is only Desktop version (2gb db limit!)....

Any ideas on why the full enterprise edition is not installing on the laptop?!!

Version on my Desktop:
MICROSOFT SQL SERVER 2005-9.00.1399.06 (INTEL X86)
OCT 14 2005 00.33.37
1988-2005 microsoft corp
enterprise edition on windows NT 5.2 (build 3790-service pack)

Version on my laptop:
MICROSOFT SQL SERVER 2000-8.00.2039(INTEL X86)
May 14 2005 23:18:38
Copyright (c) 1988-2005 Microsoft Corporation
desktop engine on windows NT 5.1 (build 2600: service pack 2)

The Laptop spec is:
Intel 1.66Ghz, 1 Gb Ram, 50 Gb HDD, Windows XP SP2


The Desktop spec is:
Intel 2.8 Ghz Dual Core, 2 Gb Ram, 320 Gb HDD, Windows XP SP2


Both SQL Server 2005 versions are installed from the same CD so why would there be a difference?

I understand that you cannot have Enterprise edition on XP but it has installed on the desktop, not the laptop???

Thanks in advance!

View 4 Replies View Related

SQL Server 2005 Editions... Same Codebase Or Not?

May 29, 2007

I've developed and tested an application that utilizes the standard (.SQLEXPRESS, not user instance) instance of SQL Server 2005 Express. I'd like to be able to say that my solution will operate on any of the 32-bit SQL Server editions (Express, Workgroup, Standard, Developer, Enterprise).



I've found anecdotal comments from people saying that SQL Express is a subset of the other versions. However, in order to truly validate my "any edition" claim, I need to either:

a) Install and test my solution with all editions of SQL Server, or

b) Provide a justification for saying: "If it works on SQL Express, it'll work with the other editions".



Does anyone know if there is some official documentation somewhere that affirms the functional equivalence of the editions?



Is there documentation that states that each SQL Server edition is compiled from the same codebase?



Thanks for any help



- Mike

View 6 Replies View Related

Mirroring Between Standard And Enterprise Editions...

Sep 15, 2006

Hi All,

We are going to use database mirroring and database snapshots for reporting. The principal server runs SQL Server 2005 Standard Edition and mirror (reporting) runs SQL Server 2005 Enterprise Edition (64-bit). I failed to setup database mirroring trough GUI using SQL Server Management Studio and got this error:
This mirroring configuration is not supported. Because the principal server instance, <server_name>, is Standard Edition, the mirror server instance must also be Standard Edition.
But when I use T-SQL commands I was able to setup database mirroring and it works OK so far.
SQL BOL says that one of requirements for database mirroring is to use the same SQL Server editions but I am wondering if it works trough T-SQL why MS mention it in the requirements list, also is totally unsupported by MS?

Thanks

Oleg

View 6 Replies View Related

Database Mirroring Between 2005 Editions

Feb 1, 2007

Can I use Database mirroring between 2005 Std and 2005 Ent editions?

View 2 Replies View Related

Differences Between Enterprise And Standard Editions.

Apr 26, 2007

I have been given the "Performance and Scalability Guide" for Forefront Client Security by one of our representatives from Microsoft. The document is listed as published in July 2007, so I apparently can not supply a link. The document makes a couple of hard to swallow claims, though. One of these is this:










The sizing differences between SQL Server Standard Edition and SQL Server Enterprise edition are due to the differences in the index sizes between the two editions.
I have to say I do not buy this. Can anyone disillusion me, or give me a link to anything that even implies this? I have not found anything to prove or disprove this, as yet.

Another oddity in this document is that FCS will not support 64 bit SQL Server, but encourages the use of AWE and /3GB. I can not believe there are functionality differences between the two, unless their database performance is negatively impacted by the 64 bit architecture (naturally the document is silent on why they do not support 64 bit).

Anyway, the questions are does the quote above actually hold any water? And would 64 bit SQL server cause functionality problems, other than performance problems?

View 4 Replies View Related

Sql Server 2005 - Having Multiple Editions

Sep 17, 2006

Dear All

I would like to install and run visual studio .Net 2005 and sql server 2005 (may be enterprise or developer edition)on the same system.

What is the best approach that I should take ? should I install sql server 2005 first ?

Since visual studio .Net 2005 installs mobile edition and express edition will this cause a problem ?

Could multiple sql server editions run on the same machine with no problems ?



Thank you,

Daniel

View 1 Replies View Related

SQL Server 2012 :: How To Calculate Attendance For Single Student For Yearly Basis

Jul 2, 2015

I have to calculate the Total number of days present and absent for a singel student.

AS of now i have 3 tables.

1.Daily attendance - Columns -[Guid][,AcademyId],[StudentId],[Date],[Status],[Reason]
2.Student details - Columns - [Guid],[FullName],[DOB],[Address]
3.Class Details - Columns - [Guid],[AcademyId],[Class],[Section],[Startdate],Enddate]

So now i have loaded all the data into the table.

I can fetch the counts for total present and absent

Query i have tried is

Declare
@StudentId Uniqueidentifier ='0B2D4D41-8D33-4D79-A981-03E0F093F458'
Begin
select A.StudentId ,A.Date,Count(Date)Total,B.Guid,

[Code] ....

AS result of this query i get the data.Present count and Absent count from date inserted in Dailyattendance tables.

SO my problem is if the student have promoted to next class then by this query it will count the before year also how do i need to calculate the count according to the Class StartDate and Enddate as i mention in the Class Details table what will be the query.

View 7 Replies View Related

Student Trying To Install SQL Server 2005 Developer's Edition On Windows Vista

Jan 18, 2008

Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!

View 3 Replies View Related

SQL 2012 :: Can Connect Other Server Editions By Express Edition

Sep 29, 2014

We are having 2012 Enterprise Edition,If I installed the Express Edition in other Client system is it possible to connect the Server system by using Express Edition....And Can we Connect the other server editions like Enterprise,Standard..etc by Express edition...

View 2 Replies View Related

SQL Server Integration Services (Standard Vs Enterprise Editions)

Mar 9, 2006

The advanced transforms only available with Enterprise edition:

Data Mining Training Destination
Data Mining Query Component
Fuzzy Grouping
Fuzzy Lookup
Term Extraction
Term Lookup The advanced tasks only available with Enterprise edition:

Data Mining Query Task

Now what does all of those terminologies mean above? We are trying to determine if we need to really invest in the enterprise edition for the integration services. The information I got came from:

http://www.sqlis.com/default.aspx?31

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved