Hill Climbing -- A More General Question On Systematic SQL Skill Upgrade

Jul 23, 2005

I'm wondering if someone has thought about this, one desires to enhance
his/her sql skills proactively vs. skills gained over a period of time
merely because of work experience. SQL skill here refers to mainly MS
SQL Server related skill.

What could be reasonably effective ways to go for the proactive
approach?

Off head, I'm thinking of the following:
*) read up and re-read on a few selected books such as sql for smartie
except old textbooks (some of them have been read/studied)?
Little challenge: definition of great sql books or online materials?

*) get into a habit of visiting some good sql web sites include MS sql
web site. Little challenge: definition of "good sql web sites"?

*) form a routine of reading good SQL NGs like this
Little challenge: which thread(s) to read? By interest only is sort of
limiting.

*) find an interesting project (non-work related) to embark on to test,
verify the above three?

Big challenge: the above 1 through 3 is pretty dry, how could one
manage to do it in the evening/at night after work when a bit tired and
desires to relax instead?

TIA.

View 2 Replies


ADVERTISEMENT

Sqlservr.exe Memory Steadily Climbing

Feb 22, 2002

I've a SQL 7 SP3 server that was running for more than 6 months without any problem and hence I never give much thought to it other than the monitoring the growth of the database size.

Just the other day, I was pretty shocked to see that SQLSERVR.EXE was using nearly 1 GB of RAM (and I have 1 GB of physical RAM)!!! My database size is only about 2 GB and there aren't many simultaneous users online. This database is used for a web application.

Today I have the opportunity to restart the SQLServer service (to apply the security hotfix). And I'm pretty dismay to see its memory usage climbing steadily at the rate of around 20 to 30 KB every few seconds. I guess it'd hit 1 GB in a matter of hours or days..

Now, I've a similar server on another machine.. but its SQLSERVR.EXE is only using around 20 MB and it doesnt grow much.

So..what should I do?? Ideas? Suggestions? Thanks!!

View 3 Replies View Related

Sorry For The Low Skill Qustion, Maybe It's Not The Right Place

Sep 28, 2007



How am I configuring permission for an SQL database, that user within my program should'nt read private information?

as well how can I protect my database with a UN & PWD to allow access only for authenticated users, not within the program, just the *.mdf file?

View 7 Replies View Related

Select Candidates With More Than One Skill (was Help Required)

Jan 18, 2005

I am struggling with a query and need urgent help.

I have a table with fields

canid
skillLevel
percent
date

and example of the results wud be

canid skillLevel Percent Date
704 1 20 n/a
705 2 10 n/a
775 1 50 n/a


what i want to do is produce a query that would return a result from the following search critera

return all results that match

skilllevel 1 and 20 percent AND skillLevel 2 and 10 percent

I tried this below but obviously im doing something wrong

select * from simulatedHistory where
((skilllevel = 1 and percent = 20) And (skilllevel = 2 and percent = 10))


I need the query returning

canid skillLevel Percent Date
704 1 20 n/a
705 2 10 n/a

any suggestions??? any help wud be much appreciated

View 9 Replies View Related

Count And Percentage Of Skill Ratings

Jul 21, 2013

I have a program which brings in Skill ratings for an assesmnet people with the title of "Worker have to take aolng with a file number they are assigned. The program also being in the reporting line that each worker is a part of.

SELECT distinct
o.VP,
o.AVP,
o.Director,
o.Supervisor,
o.Worker,
bs.File_NBR,

[Code] ....

The rating levels are 1 through 5. What I need to do is to do is create a table that shows the count and percentage of each rating giving to the workers for each skill grouped by Vp, AVP, Supervisor and Director. So all the works that are Ultimately under a AVP and all the wokers that are Ultimately under a director and so on.

NameRoleSkillCount of % of Count of % of
Rating 1 Rating 1 Rating 2 Rating 2
Gerald VPA1100 29% 13033%
Gerald VPB195 28% 9524%
Gerald VPB2120 35% 7018%
Gerald VPB330 9% 10025%
KimVPA1
KimVPB1
KimVPB2AND SO ON

[Code] ....

View 1 Replies View Related

Error When Attempting To Upgrade MSDE To Express Using Command Line /UPGRADE

Nov 29, 2006

When attemping to install SQL 2005 Express using the following command line arguments

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE

or

/qb UPGRADE=SQL_Engine INSTANCENAME=MY_INSTANCE SECURITYMODE=SQL SAPWD=MY_PASSWORD

the following error occurs.

Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

The following version and editions have been verified.

1. .NET 2.0 installed

2. Windows XP SP2

3. MSDE 8.00.2039(SP4)

4. all MSDE databases are owned by sa

5. Instance and SQLAgent running under user that is member of Administrators

What are the possible reasons this error is occurring?





View 4 Replies View Related

SQL Server Upgrade MSP Error: 29538 On KB934458 Upgrade

May 13, 2008


We have a server instance on SQL Server 2005 SP2 build 3042. We have a 32 bit x86 server. We attempted to upgrade to SP2 build 3054 KB934458. And we got the following error as stated in the Summary.txt file.




Code Snippet
**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
Error Number : 29538
Error Description : MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
----------------------------------------------------------------------------------






The client tools and workstation components were successfully installed. The server is still reporting build 3042.

Here is the portions of the HotFix.log file.




Code Snippet
05/12/2008 09:19:09.041 Copy Engine: Creating MSP install log file at: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log
05/12/2008 09:19:09.072 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"
05/12/2008 09:19:09.103 Registry: Cannot read registry key value "Debug"
05/12/2008 09:21:29.382 MSP Error: 29538 SQL Server Setup did not have the administrator permissions required to rename a file: e:SQLDatamssqlsystemresource1.ldf. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
05/12/2008 09:22:33.678 MSP returned 1603: A fatal error occurred during installation.
05/12/2008 09:22:33.724 Registry: Opened registry key "SoftwarePoliciesMicrosoftWindowsInstaller"






Any help would be appreciated.

View 3 Replies View Related

SQL 2005 SP1 Upgrade Error For Upgrade Advisor

Jan 19, 2007

Hi,



We are performing a SQL 2005 SP1 upgrade from SQL 2000 on our Windows 2003 SP1 Standard Edition.

When we run the upgrade, we got a error "Upgrade Advisor Return -1" as a pop-up window.

When we run the Upgrade Advisor separately, we get this error :



===================================

Common Language Runtime detected an invalid program.

===================================

Common Language Runtime detected an invalid program. (System.Xml)

------------------------------
Program Location:

at System.Xml.Schema.SchemaInfo..ctor()
at System.Xml.Schema.XmlSchemaSet..ctor(XmlNameTable nameTable)
at System.Xml.XmlReaderSettings.get_Schemas()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReportController.LoadAndValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAReport.ValidateDataFile()
at Microsoft.SqlServer.UpgradeAdvisor.ReportViewer.UAIssueReport.Refresh()
at Microsoft.SqlServer.UpgradeAdvisor.ReportPanel.OpenReport(String reportFile)



We are in a lost for solutions. We do hope to hear from anyone asap...

Greatly appreciated for any kind assistance.



Thanks.

View 1 Replies View Related

SQL 2005 Upgrade Problem - In Place Upgrade

Feb 10, 2007

Hi,



We are running a test upgrade form sql 2000 standard edition 32 bit to sql 2005 developer edition 32bit. Followed through all the steps and specified the account(SA priveleges and currently used by the 2000 version) and is the local admin on the box for the services and the setup seemed to move fine, except for when it got to the point of installing database services - This is the error message that I got:

MSSQLServer could not be started. Verify you have sufficient priveleges to start system services. The was no choice but to hit cancel and then the set up progressed with a final message of 'SEtup failed'.

Here is a portion of the error log:
Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
Database Mirroring Transport is disabled in the endpoint configuration.
Starting up database 'master'.
Converting database 'master' from version 589 to the current version 611.
Database 'master' running the upgrade step from version 589 to version 590.
Error: 946, Severity: 14, State: 1.
Cannot open database 'master' version 589. Upgrade the database to the latest version.
System Task Aggregate global counters produced an error that was not handled. Major: 9, Minor: 46, Severity:14, State:1
Error: 928, Severity: 20, State: 1.
During upgrade, database raised exception 15151, severity 16, state 1, address 01C4C50B. Use the exception number to determine the cause.
Error: 15151, Severity: 16, State: 1.
Cannot find the endpoint 'TSQL Local Machine', because it does not exist or you do not have permission.



Any help would be greatly appreciated

Thanks KR



View 7 Replies View Related

Upgrade Advisor Post-upgrade

Dec 6, 2006

Greetings,

I have a client whose DBA upgraded their SQL 2000 database to SQL 2005. They still have it running in 8.0 compatibility mode, for various reasons, and would like me to help them develop a migration strategy to get them to full 9.0 compatibility.

My question is: can I run the Upgrade Advisor on a SQL 2005 engine database running in 8.0 compatibility mode and get anything useful? I already know there will be some issues with existing DTS packages but it would be nice to catch any other issues in advance.

I know that the Upgrade Advisor was run before the upgrade took place but to my knowledge the report was not saved and none of the recommendations were followed.



Any help would be greatly appreciated.

Cheers,

Lon

View 1 Replies View Related

General T-sql Help.

Oct 19, 2005

The following is my code.  What I am trying to do is find all the students a teacher as assessed during a give time.  Then find out which assessment was done the most recently.  After that I will then be aggregating those results.  I have never written any pl/sql or T-SQL... heck I don't even know what to call it!The first sql command is doing what I want it to.  I can only assume the cursor is working correctly.  Any help would be greatly appreciated.BryanALTER procedure Domain@UserID numeric,@StartDate datetime,@EndDate datetime
AS-- Variable DeclerationDECLARE @SessionID varchar(1000)DECLARE @EachSessionID numeric
--Cursor to find all Children that the teacher has assessed for the given timeDECLARE ChildID_cursor CURSORFORSELECT DISTINCT childID FROM capsessionWHERE userid = @UserIDAND sessiondate BETWEEN @StartDate AND @EndDate-- looping through all Children to find there most recent assessment.OPEN ChildID_cursorDECLARE @ChildID numeric FETCH NEXT FROM ChildID_cursor INTO @ChildIDWHILE (@@FETCH_STATUS <> -1)BEGIN IF (@@FETCH_STATUS <> -2) BEGIN  DECLARE SessionID_cursor CURSOR   FOR  SELECT  TOP 1   CAPSessionID  FROM         CapSession  WHERE     (ChildID = @ChildID) AND (SessionDate BETWEEN @StartDate AND @EndDate)  ORDER BY SessionDate DESC END FETCH NEXT FROM ChildID_cursor INTO @ChildIDENDCLOSE ChildID_cursor
OPEN SessionID_cursorFETCH NEXT FROM SessionID_cursor into @EachSessionID SET @SessionID = ''WHILE (@@FETCH_STATUS <> -1)BEGIN IF (@@FETCH_STATUS <> -2) BEGIN  SET @SessionID = @SessionID + @EachSessionID+ ',' END FETCH NEXT FROM ChildID_cursor INTO @ChildIDENDCLOSE SessionID_cursorRETURN @EachSessionID

View 3 Replies View Related

GENERAL QUERY

May 30, 2008

Hi, I wanna know if one has to undergo the 'sql video tutorials' on this website before trying to understand data access tutorials, again on this site.
Are the two related by any chance. Also I am not able to find the customer database files he has created in tutorial # 5, dumb to ask, but what to do?,...so anyone willing to shed light!!!

View 2 Replies View Related

General SQL Abilities...

Jan 12, 2003

Hello everyone,

as you might have seen, I'm a total newbie to this Site and M$ SQL.
I browsed the forum to see if there are already matching answers to my question, with no success.

My question:
As a MySQL & PHP user I ask myself if there is a possibility to use M$ SQL the way I use MySQL and PHP!?
Is there a way to generate dynamic websites with M$ SQL 2000 and a webserver running PHP sources?
A brief yes or no would really help me, if you have any links or resources on this topic, I'd be glad to hear about it.

Thanks
Tom

View 2 Replies View Related

&#34;General SQL Error&#34;

Mar 1, 1999

I get the error "General SQL Error" when reading or writing to a memo field in Sql Server through a frontend build in Delphi 4.
I'm Using the latest BDE.
I have recently installed this onto a NT enviroment in the same manner as my own enviroment but get the error message above.

On my own enviroment and a friends enviroment I do not get any errors.

Can someone please give me some help on this or a direction to run in ?

Thanks

Dave.

View 1 Replies View Related

General SQL Questions

Apr 3, 2008

1. What is the SQL error you receive when you try to fetch data from a cursor after it has run out of data?

2. After a SQL statement is executed, what does a negative value in the SQLCODE variable indicate?

View 7 Replies View Related

General Recommendation

Sep 26, 2004

Hi, folks. I've a production SQL machine with more than 20 users making transactions 24 hrs in 6 days a week. I've only Sunday for maintenance. The server has fixed 2 GB RAM allocation for SQL. Is it good to Restart SQL ( or machine) to clear the Buffer-Cache( or is it good to keep the cache) .... :rolleyes:


Howdy!

View 3 Replies View Related

General DB Help Needed

Mar 16, 2006

:eek: I am not going to lie, I am taking a DB course and am finding it extremely difficult to understand. :o

We are doing Relational DB & ER modeling as well as table normalization.

I only have 1 hour to take an upcoming and know I will score poor on my own.

Anyone want to help me out with my quiz?

I can post the Q's here.

Thanks much

View 14 Replies View Related

General DB Query

May 3, 2004

Hi! How do you query an entire db for a value?

I know how to do table queries from the SQL Analyzer, but not a full DB search.

Like, if I wanted to find a value '137.51 in a DB, what would I use?

Many thanks!

JJ

View 1 Replies View Related

Best General SQL Forum

Apr 28, 2008

I'm not impressed with the speed/quality of responses from this forum...

Can anybody recommend a more active forum?

View 20 Replies View Related

General Search

Oct 5, 2007

Hi,

is there a search function in MS SQL server 2005 to search for a name of a table or a name of field or entry in a field?

what/how should be the fastest way to do it?

thank you

View 4 Replies View Related

General Questions

Mar 11, 2008

Maximum Number of rows allowed in sql server 2005 tables ?
Maximum Number of columns allowed in sql server 2005 tables ?
What are all the built in string functions can be allowed for 'TEXT' DataType in sql server 2005?

View 1 Replies View Related

General Q About Formulae

Aug 3, 2005

Before I go into specifics, this is my problem. I've have a tablethat gets updated with large amounts of data on a monthly basis.Sometimes (rarely) identical rows of data are on one months import thatalready exist from the previous month. I can identify these rows from acombination of two fields (sampleID and testname).My question is this. Would it be an appropriate 'fix' if I created anew 'formula' field on the table comprising of a concatentation ofthese two fields and then made that an index field (no duplicates)? Myguess would be that if we then tried to import a record with a sampleIDand testname that already existed, then the import for that recordwould simply fail.Would this work? Is there a better way? My background is more withAccess so apologies if I'm not using the right terminology.Simon Harris

View 4 Replies View Related

General Question

Jul 26, 2007

hi...i would like to know best practice when assigning a value to a variableexample belowsetorselectdeclare @var1 varchar(25)set @var1='abc'select @var1='abc'to meset is implicitselect implies conditionsi see both used all over the place here at my new company....so witch is better practicetksMJ

View 6 Replies View Related

Which General SQL NG Is More Active??

Jul 27, 2007

Is comp.databases.ms-sqlserver more active thanmicrosoft.public.sqlserver.server, or is it the other way around??Which NG is better for general and 'learning SQL 2005' types ofquestions??Thank you, Tom

View 2 Replies View Related

General Questions

Jul 20, 2005

New to using databases that are NOT Access. New to MS SQL Server. I'dlike help understanding some concepts.Firstly, I'd like to know how to connect to a database using MS SQLServer on a remote web server using Windows XP; I know the IP and havethe username and password to connect...but what program do I use?Suggestions, appreciated.Secondly, I'd like to make changes to the remote database - anyonesuggest programs to use?Regards,OZ

View 1 Replies View Related

General Question

Mar 28, 2006

I have a general question about transactions and commands that are replicated in a Transactional replication.

My screen shot says:

A total of 5 transaction(s) with 85 command(s) were delivered.

I know what a transaction is, but what is a command?

I am assuming a transaction is

begintrans

committrans, correct?

View 4 Replies View Related

General Question

Sep 21, 2006

I am currently upgrading my companies database from 6.5 to 2000. Including the replication. I am curious about something. Currently we are using the commands in 6.5 to do the replication instead of stored procedures. (except for one table that requires custome filters). When I reestablished replication on 2000, the default is to create stored procs on the subscribers to hande the replication. (sp_MSins_tablename). My question whether anybody knows why it defaults to using sp's? Is there a reason or is that just the way it is. I want to know if using sp's is better than just sing the commands before I change my setup.



Thanks for any responses.

Johnny

View 3 Replies View Related

General Question About RS

Jul 16, 2007

Hello,



Can someone please answer the following questions:



1) Am I correct that SSRS 2005 can access a remote data source on SQL Server 2000? (this one I'm pretty sure about). I'm also trying to determine whether I can move up to SSRS 2008 when it is released and keep running all the same report types against SQL 2000.



2) Where is the bulk of the reporting services calculations performed (e.g. NOT the database query itself)? The Reporter Server? Or the Reporter Server Database?



3) Is it advisable to have the Report Server and Report Server Database on the same server? How do people typically handle this?



4) Is it advisable to have the Report Server and the Datasource database on the same server?



Thanks!



Michael

View 4 Replies View Related

General Question

Apr 19, 2007

I have a website. It is a SAS Site. It has a structure similar to

tbClient (ID, Username, password)

tbData (ID, ClientID, info)

tbDatax(ID, tbDataID, info)

tbDatay(ID, tbDataXID, info)





This is a reporting nightmare for me. I Ihave a sollution, but i was wondering if SRS has an out of the box sollution or if anyone knows of an out of the box sollution.



It is a reporting nightmare because clients want to be able to create reports out of the system, but I can't let them see other clients data.



My sollution is give them a username CLientA



They log into The database with CLientA login



I have views that mask the data by enforcing all of the relationships through the view.

create view vutbDatax as

Select tbDatax.*

from tbDataX

Inner Join tbData on tbData.ID = tbDataX.tbDataID

Inner Join tbClient on tbClient.ID = tbDataX.ClientID

where tbCLient.Username = User



User is a Database function that returns me the Username they logged into the database as.



Imagine doing that for 100 views. And managing the security on it. I have done it and it is in the process of testing right now but Does anyone have a better sollution.















View 1 Replies View Related

General SQL - Need Same Inner Select In FROM And WHERE Sections...

Feb 29, 2008

Hi, I've got the query below which works as needed, but it performs the same inner select twice at present. What is the best way of eliminating the second evaluation of the inner select statement?
SELECT TOP 1 condition FROM
  (SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition)
WHERE total = (SELECT MIN(total) FROM
  (SELECT condition, COUNT(condition) AS total FROM [JCM].[dbo].[jcmresults] GROUP BY condition))
 
Thanks,
Andrew

View 5 Replies View Related

General Question About SQL Efficiency

Apr 14, 2008

I have a website that is probably going to hold a sizable amount of data.  The data will be specific to groups of users based on login credentials.  Would it be more efficient to create a whole new database for each group of users, or create new tables for the groups in the existing database? 
Any thoughts on the topic would be appreciated.
Thanks

View 3 Replies View Related

General Question On Triggers

Jun 16, 2008

If I have a foriegn Key stored in a primary table, are triggers used to automate routines in the foreign table when ever the foreign key is changed.
 Is there a forum reference with practicle examples of where to use triggers?
 

View 3 Replies View Related

General Network Error

Apr 20, 2005

Hello.
I'm running into a rather intermittent problem when a search query is run on an ASP.Net web application.
The error is 'General Network Error' Check your Network Documentation...
As I said, it doesn't happen everytime which leads me to beleive that there is a problem with the database connection
There's probably no more than 50-60 max users hitting the app at any one time.
Anybody familiar with this?

View 1 Replies View Related







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