Nice Books?
Jun 14, 2006hi guys,
i m a newbee in SQL. i wanted to know which is the nice book to start with? anyone got ebooks of SQL2005?
ADVERTISEMENT
Very Nice; That Worked.
Sep 29, 2006Very nice; that worked.
It seems like a lot of code for each date field, but we are up and running now.
What Happened To Nice BCP Interface In SQL 6.5
Nov 20, 1998In the SQL Object manager tools for sql server 4.21 there was a gui interface for running BCP where you could select tables and fields etc.
I haven't beem able to find abnything equivalent in sql 6.5 enterprise manager. Am I missing someting, or was this dropped?
Thanks.
Jerry Dunn
ViaHealth
jerry.dunn@viahealth.org
SP3a + Extended Procedures = Not Nice (help!)
Jul 20, 2005Hi(sorry this has turned into a bit of an epic...thought I'd as theexperts!)SQL 2k, sp3a. Dual xeon 2.4. 2 gig ram. everything on a 3 disk raid 5.Microsoft SQL Server 2000 - 8.00.760 (Intel X86)Enterprise Edition on Windows NT 5.0 (Build 2195: )Problem seems to be some extended procs that seemed to be running fineon a 'vanilla' install on a different server now seem to be failing.Failures occuring c 6 - 10 hours.Sometimes the failure logs as the xp failure with severity 20 that Ikindof expect :s. other times absolutely nothing is logged.There are a variety of error messages - or sometimes nothing at all.http://www.mapinfo.com/common/docs/.../SWMSS48_RN.pdfdescribes one of our issues, which seems to come out on the restartafter a failure:Error event id is 19011, Message "SuperSocket info:ConnectionListen(Shared-Memory (LPC)) : Error 5."That site suggests:[color=blue]>Workaround>Suggested solutions include:>• Obtain a hotfix from Microsoft (http://www.microsoft.com). You will[/color]need to >cite the 94302[color=blue]>reference number.>• Turn off shared memory in the client network configuration utility[/color]to >disable shared[color=blue]>memory.>• Replace the SQL Server SSMSLPCN.DLL with the SSMSLPCN.DLL[/color](8.00.540) from >SQL[color=blue]>Server 2000 Service Pack 2.[/color]- but I cant find any sensible information which describes this tocorrelate! Searching MS for that number (94302) came up with zip.The dll version we are running is 2000.80.760.0, although earlierversions are elsewhere on the server (disk images).Interesting to note that we seem to be able to replicate the 'leakage'of improperly closed handles on this version, but not on the oldserver runningthat dll version 2000.80.194.0. This I understood to have been fixedin sp3.On one failure we caught the following (involving our extended procs):2004-02-15 15:03:31.40 spid58 Error: 0, Severity: 20, State: 02004-02-15 15:03:31.40 spid58 Stored function'xp_Contest_CalculateScores' in the library 'e:sqlxpga_procs.dll'generated an access violation. SQL Server is terminating process 58..2004-02-15 15:04:32.14 spid64 Error: 0, Severity: 20, State: 02004-02-15 15:04:32.14 spid64 Stored function 'xp_XML_GetSubTree'in the library 'e:sqlxpga_procs.dll' generated an access violation.SQL Server is terminating process 64..2004-02-15 15:04:48.48 spid53 Using 'dbghelp.dll' version '4.0.5'*Dump thread - spid = 53, PSS = 0x472d7200, EC = 0x725fc098*Stack Dump being sent to e:sqlMSSQLlogSQLDump0001.txt* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:48 spid 53This was followed about a minute later by:2004-02-15 15:04:55.75 spid53 Stack Signature for the dump is0x1CC032652004-02-15 15:04:55.75 spid53 SQL Server Assertion: File:<recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.2004-02-15 15:04:55.89 spid53 Using 'dbghelp.dll' version '4.0.5'*Stack Dump being sent to e:sqlMSSQLlogSQLDump0002.txt2004-02-15 15:04:56.01 spid53 SqlDumpExceptionHandler: Process 2292generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQLServer is terminating this process.* ************************************************** ******************************* BEGIN STACK DUMP:* 02/15/04 15:04:55 spid 53As a side issue we have a number of 'initialisation of notify failed'notes.Any one have any clue about this?Might the DLL need rolling back?Is sp3a knacked for extended procs?Is there some daft setting I've missed :/Any good events to track in particular?Cheers all!
View 1 Replies View RelatedONE ZERO ZERO -------&&> One Hundred = Nice String Formula !
Feb 21, 2008
Im trying to build myself a report that recieves a values as worded text e.g
zero zero one zero zero
it would be nice if i write some clever bit of code that would convert this to
One Hundred
Has anyone come up against this before, or could point me in the direction of a tutorial, i would appreciate it
thank you in advance
Jonny
What Happened To Nice SqlDataAdapter.Fill Method In ASP.net 2.0
Dec 26, 2005What happened to nice SqlDataAdapter.Fill method in ASP.net 2.0 + How can i now access and traverse trhough table.
ex : sqlDataAdapter.Fill(dataSetname.tblsname);
dataSet11.rows[][]
Nice Problem: How To Combine Different Columns Into A Table
Jan 18, 2004It's rather easy to combine resultset from the same table structure...we can either insert the entries or union the results.
But let's say you select different columns from different tables and want to combine them to form a new table, how would you do it (assuming you can't join those tables since they are not related), assuming they all return the same number of rows.
select col1 from table1
go
select col2 from table2
go
Now I want to combine them so table3 is made of col1 and col2.
Rolling Up Records Problem (nice Puzzle) :)
Feb 21, 2008Here's a nice puzzle for all you masochistic programmers LOL.
Actually, it's just something that's been giving me problems and I know this forum has some amazing programmers who will probably find my problem to be easy.
I'm using 2005.
Simply put...
Here's the data:
ID Start End X
123 10 15 a
123 9 10 b
123 11 18 d
123 14 16 z
123 19 21 x
234 16 18 bb
I'd like to roll up overlapping start and end numbers into one set.
So here would be the output:
ID Start End [Ttl X]
123 9 18 4
123 19 21 1
234 16 18 1
The way I'm thinking of attacking this is maybe a combination of RowNumber & a CTE of some sort.
Please no loops or cursors, or extra tables.
Any ideas guys/gals?
Thanks a mil,
Denvas
Books
Sep 2, 2004any all-rounder good book on SQL Server
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSQL Books
Aug 11, 1999I would like to know what book is considered the best when it comes to optimizing SQL Server configurations and troubleshooting SQL Server problems encountered in the error log.
View 1 Replies View RelatedSql Books
Feb 5, 2002Hi,
I have to buy two books for the MIS dept for sql server 2000. Which one do you recommend? We are still on sql 7.0 and migrating to 2000 soon. All developers have good experience with sql server 7.0.
Want something that gives you recommendation about better practices for performance issues for writing SPs.
I read all the reviews on amazon and b&N . It's confusing to choose only two.
Any recommendations?
Books
Sep 20, 2001Can Anyone tell where I can found a tutorial about Transact-SQL ?
Thanks
Books SQL
Sep 2, 2004Hello, I wish SQL' Books.
Anyone help me..
Bye :rolleyes:
Sql Books
Jul 20, 2005hipls tell the site's where i can download free e-books,bye,s.premkumar
View 1 Replies View RelatedBooks
May 21, 2007Hi , i am new to certifications in general..
I would like to do the certification exam 70-431. However i want to study on my own instead of going to classes.
what if i get the microsoft e-learning books or microsoft press books? will this be enough in helpnig me with the course requirements?
what are the difference between the two e-learning and MS Press books?
Books On Line
Aug 7, 2001Hi,
I just started at a client's site and have found that the Books On Line has been removed (all other items are there in the program group instead of BOL). Is there a site at microsoft that mimicks BOL? (sybase has a 'sybooks on the web' which mimicks their 'Sybooks' product documentation.
Any help would be appreciated.
jim
Books On SQL Administrations
Feb 28, 2000Hi
I am looking for books on SQL 7.0 Administration. I would appreciate if any body could recomend.
regards
rajeev
Books - For SQL Server 7.0 DTS
Nov 3, 2000Can anyone recommend books on SQL Server 7.0 Data Transformation Services?
Looking to find info on importing data from a Sybase server to SQL server (need good examples). Thanks.
Any Good DTS Books
Sep 30, 2002Does anyone know of any good books on DTS? I am currently using SQL 7.
Thanks in advance
Any Good Books
Sep 14, 1998Hi there,
Any good books to Know the internals of MS-SQL server 6.5
Thanks
Vivek
Books Online
Aug 10, 2005How do you use BOL? I've heard time again that there is much info in BOL but when i look at it it seems too brief and not detailed. I find it hard to find what i'm looking for anyway. How do you use it?
Thanks!
CD, Books, Sites
May 24, 2006naresh writes "I would like to learn sql server 2000 and I do not have any programming experienc at all so how do i learn this programme. Do you have any suggestion or any basic books or materials you guys can refer to me
Thank you"
Ref: Books/webcast On ETL
Oct 9, 2006we are trying to build warehouse in our company its very small database but still.
we have come to a point where we are able to pull reports from the database that we have created as OLTP which is truncated and reloading everyday .
Now we have to stop doing that and just update the database and check for the changes in the existing data.
Can anyone suggest ETL book/webcast/weblinks that could help me.
Thanks in advance
Srini
Wrox SQL Books
Apr 2, 2007Ok I found these two books
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764589237.html
and this one
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584332.html
Could someone explain the difference between these 2 books besides the fact that one is geared towards the express edition. The SQL Programming book sounds more thorough than the Express Edition book.
Suggestions For Books
Aug 15, 2006I would be teaching an applied database course to buisness majorundergrads. I'm looking for a book that introduces database conceptsusing SQLServer as the database. I would really appreciate if you couldrecommend me a few such books.ThanksNemo
View 4 Replies View RelatedSSIS Books
Apr 2, 2007Hi,
I am new to SSIS and wondered if there are any books around to learn in depth regarding SSIS and exampls for transformation to try and help me understand it better.
If anybody knows any guide, please let me know
Aash.
Books For SSIS
Sep 12, 2006Hi,
Please give the Microsoft suggested book material list for learning SSIS
Thanks & Regards
S.Nagarajan
Recommended Books
Aug 22, 2005Can somebody recoommend me books for sql server 2005. I am interested specially in CLR inside sql and Business Intelligence.
View 4 Replies View RelatedBooks, Articles About ETL
Apr 22, 2008
Hello,
maybe anyone knows good books or articles about ETL, ETL processes, ETL optimization ?
If you know where i can download - post a link
Thanks
AS 2005 References/Books
May 4, 2007Hi All -
I have come across the need to use a cube in AS 2005 for an application. Unfortunately this will be the first time writting an ASP.Net application which uses one. I was wondering if any of you had any good books or references that I could look at to get an idea of how I should approach this issue.
Thanks in advance.
Books For SQL Warehousing Exam?
Jan 4, 2001Can anybody suggest a couple of good books to use to prepare for the SQL Data Warehousing exam (70-019)? I'm starting to get ready for that exam to complete my MCDBA and was wondering if anybody had any good recommendations or those to stay away from.
Thanks for any help that you can provide in this matter.
Tom
HELP ? Good Books To Read !!
Mar 16, 1999Sorry if this has been posted before, but I performed a search on the archives and didn't find anything !
I have just been turned over a SQL 6.5 SP3 / NT 4.0 SP3 server that has several SQL errors in the event log. I need to find a good book to read/scan, so I can get up to speed on SQL.
Thanks,
Mike Givens MCSE
mikeg@iowa.com