About Inside SQL Server 2005 E-book
Jan 8, 2007Dear all,
Can you please help me to get Inside SQL Server 2005 e-book.
Where i can download this book?
Regards
Magesh
Dear all,
Can you please help me to get Inside SQL Server 2005 e-book.
Where i can download this book?
Regards
Magesh
We are currently have SQLS ERVER 2000 . We are planning to upgrade to SQL SERVER 2005 Next month. I believe DTSPkgs have changed significantly in 2005.. I have not used SQLS ERVER 2005 a whole lot yet. Can you pl recommend me aa GOOD Book that I can read, to get a GOOD understanding of SQL SERVER 2005.
Hello everyone ,
I am looking for an useful sql server 2005 performance tuning book. i have been searching for a real nice book as i m going to start my job from next month in a financial domain with one of the requirement as sql server 2005 performance tuning.so i m looking forward a book which can help me doing well at my workplace. Any suggestions and links appreciated in advance .
Hi all,
Is this book still the only book written for SQL2005's data mining? Does anyone know where I can find its errata? I have never seen so many editorial errors (typos, mislabeling, etc.) in other books. I am not worried about those obvious errors, but I am afraid that some errors may be so deceiving that when I find out, a lot of time will have been spent on misguided effort.
Hello, I would love to know where people are discussing the book Microsoft SQL Server 2005 Integration Services book by Kirk Hasleden.
I'm on page 41 and I'm getting an error with the example in the "SELECT "2004" FROM Sales.vSalesPersonSalesByFiscalYears"
part because there is not a table called Sales.vSalesPersonSalesByFiscalYears in the AdventureWorks database.
Thank youo
I am attempting to create the "Classification - Children at Home" Data Mining Model as described in Larson's book.
Each time that I create it.. ONLY the ALL LEVEL is shown and it is impossible to expand the model to look at the Decision Tree, Neural Network, or the Clustering model etc. Drill down is enabled (tried it with and without enabling the drill down).
The Children at Home field has been populated with values from 0 - 4.
Any ideas would be greatly appreciated.
regards Steve
I am attempting to create the "Classification - Children at Home" Data Mining Model as described in Larson's book.
Each time that I create it.. ONLY the ALL LEVEL is shown and it is impossible to expand the model to look at the Decision Tree, Neural Network, or the Clustering model etc. Drill down is enabled (tried it with and without enabling the drill down).
The Children at Home field has been populated with values from 0 - 4.
Any ideas would be greatly appreciated.
regards Steve
For inserting current date and time into the database, is it more efficient and performant and faster to do getDate() inside SQL Server and insert the value
OR
to do System.DateTime.Now in the application and then insert it in the table?
I figure even small differences would be magnified if there is moderate traffic, so every little bit helps.
Thanks.
Hi All,
Please let me know where can i find the sample files and rs2005sbsDW database in msdn library as i dont have CD provided along with the book.
Please give me the link of the sample files so that i can download it for testing the sample application.
Regards,
Prabhanjana
Hi!
View 12 Replies View RelatedAnyone know a good book on SSIS. I need a good beginer book on SSIS 2005 I am very interested in using it for capturing data from other database and loading that data into the database that I'm working on . Weather it be from another database, textfiles, spread sheets. Any suggestion.
View 1 Replies View RelatedI am going to start out with covnerting reports from Sql server Reporting services 2000 to Sql server Reporting services 2005. Pl recommend a GOOD BOOK For SSRS 2005.
Thanks.
What are reporting services? i know asp or something like that, do i have to use asp? or can i use crystal Rpts?
Can anyone offer a good book on SQL Serv 2005?
i need to get the result of two different queries into 2 different sheets of the same excel file while exporting a report to excel using reporting services..
somebody please help
When I create a new Sql Sever 2005 express database inside of the VS 2005 Pro IDE I cant see the database from the Management Tool (Sql Srvr Express Management Studio). Is this normal? I can "attach" it and see it, but I wanted to make sure my environment was working correctly.
Thanks in advance for any input.
Tim
Hi mates,
My company has just started in the SQL Server's world and we are going to buy books
on this software. Our systems will run on SQL Server Standard Ed. 2000.
The question is: should I buy books on SQL Server 2005 ? Or 2000?
I'm not quite sure what kind of material to buy nor the differences between them.
Could anyone give me a hand with this?
Cheers
Bruno
Hi,I am looking for a book on SQL Server 2000. One that covers enterprise manager, query profiler, stored procedure syntax etc.I have about intermediate knowledge of both SQL and SQL Server 2000 but want to expand my knowledge for work etc. as I will be using it more and more for work.
I will predominately be using SQL Server as a backend for web and software applications, programming in .NET.Any recommendations?
Greetings:I would like to ask for recommendations for a good beginning book onSQL Server. My web host offers a 100MB SQL Server database as part ofthe package, and I'd like to use the feature to learn.I am proficient in Access and familiar with basic connectivity to itvia ASP. I don't have my own license for SQL Server (and currentlycan't afford one) so all development will need to be done byinterfacing with the remote database. As such, I won't need a lot ofexplanation regarding installation and software setup.Does anyone here know of a good study resource for someone in thisscenario?Many thanks in advance,Kay
View 5 Replies View Related
Hi,
I have been using SQL Server 2000 for sometime now but I am still not very familiar with some of the functionalities.
Just wondering if anyone can recommend me some "must have" SQL Server 2000 reference books.
Thank you.
Danny.
Dear all
Please can u suggest a good reference book available to study report server..
Regards
Polachan
Hi,
Could anyone recommend a good book on the SQL-Server, please? I need to understand how to retrieve data with select statements and commands. It is urgent!
TIA
I am looking for a set of books that realy cover the SQL
7.0 cert exams. Do you have any comments on the
following and or any suggestions.
Microsoft Sql Server 7.0 System Administration Training Kit
Microsoft Sql Server 7.0 Database Implementation Training Kit
Thank You,
Andy Robbins
Sr. Dba at Aurora Loan Services
Greetings All, I would be much obliged if anyone can point me to agood book on Java/JDBC and SQL Server.Regards, Louis.
View 1 Replies View RelatedI'm trying to execute a stored procedure within the case clause of select statement.
The stored procedure returns a table, and is pretty big and complex, and I don't particularly want to copy the whole thing over to work here. I'm looking for something more elegant.
@val1 and @val2 are passed in
CREATE TABLE #TEMP(
tempid INT IDENTITY (1,1) NOT NULL,
myint INT NOT NULL,
mybool BIT NOT NULL
)
INSERT INTO #TEMP (myint, mybool)
SELECT my_int_from_tbl,
CASE WHEN @val1 IN (SELECT val1 FROM (EXEC dbo.my_stored_procedure my_int_from_tbl, my_param)) THEN 1 ELSE 0
FROM dbo.tbl
WHERE tbl.val2 = @val2
SELECT COUNT(*) FROM #TEMP WHERE mybool = 1
If I have to, I can do a while loop and populate another temp table for every "my_int_from_tbl," but I don't really know the syntax for that.
Any suggestions?
Can we show numbers inside graphs in SSRS 2005?
I want to show nums in each column in a bar chart graph.
Thanks
hi,are there any good books or tutorials anyone can recommend to someone who wants to get more into stored proc in sql server? i'm already good with sql, use it everyday at work, but want to start learning more about stored proc, know just a little, how to write simple ones to retrieve and insert/update, but want to get more into them. a book for beginners to advanced, thanks.
View 2 Replies View RelatedCan someone recommend a good book for a beginner to learn MSFT SQL SEVER 2000 ? Thank you. lar
View 2 Replies View Relatedi am new to sql. plz let me know from where can i get free book to study sql server 2000.
View 3 Replies View RelatedHello,
I am new to SQL and in need to find a good book to learn.
I am from a small town in Canada and dont have access to local book store. I will need to order a teach yourself book on SQL server 2005 express edition.
Is there a book that is specially tailor for this with example from C# .NET instead of VB.NET?
Thanks
Just wonder whether is there any indicator or system parameters that can indicate whether stored procedure A is executed inside query analyzer or executed inside application itself so that if execution is done inside query analyzer then i can block it from being executed/retrieve sensitive data from it?
What i'm want to do is to block someone executing stored procedure using query analyzer and retrieve its sensitive results.
Stored procedure A has been granted execution for public user but inside application, it will prompt access denied message if particular user has no rights to use system although knew public user name and password. Because there is second layer of user validation inside system application.
However inside query analyzer, there is no way control execution of stored procedure A it as user knew the public user name and password.
Looking forward for replies from expert here. Thanks in advance.
Note: Hope my explaination here clearly describe my current problems.
What up-to-date books on this topic can people here recommend? Thanks.- Bob
View 1 Replies View RelatedInside my sp on the Primary server are 3 commands:
exec msdb..sp_start_job @job_name = N'JobA' --
Running on Primary ServerEXEC Server2.msdb.dbo.sp_start_job @job_name = N'JobB';Running on Secondary ServerSelect * from Server2.Table --
Running on Secondary Server
So far the commands are working just fine when I kick them off one at a time. But when I kick off the sp as a whole I notice that the timing just isn't keeping up. For instance, Step 3 is running before Step 2 is finished. It appears that as the Primary Server kicks off Step 2, it doesn't seem to care about the outcome and moves right to Step 3 which in turn provides me erroneous data.How can I get Step 3 to wait until Step 2 is actually finished keeping in mind the Secondary server is part of this equation?
Hi guys, I got some problem now with my last e-commerce ASP.net project because there's to many records in my database.
right now the website run slower and sometimes very slow esp when doing some search products or members query.
Do I need to change server hosting with Itanium processor or not? just for note right now I still using Xeon 1 Ghz.
or maybe are there some software tricks to optimize the records for faster access?
thanks.