Search results for query: *

I'm wanting to learn sql and was looking for suggestions of what would be the best book to buy to learn sql. I'm looking for one that maybe has a cd with it with sample data to practice my sql against it. Moreover one that is pretty user friendly for someone learning for the first time. Any...

We have recently acquired a Dell 2950 Quad Core machine with 32 GB of RAM. We will be installing windows server 2003 enterprise and sql server 2005 Enterprise. My question is how much of the RAM should you give to the o/s and how much would you give to the sql server. The database supports...

I am trying to update a table with the following sql: update f_quoteItem set ql_batchNumber = qt_number from f_quote where ql_qt_fk = qt_pk When executed I get error converting nvarchar to float. f_quoteitem.ql_batchnumber is a float that allows nulls the values in ql_batchnumber are all...

I am not that great with sql scripting so I thought I'd ask for help after struggling to get my problem solved. I need a script that will give me a list and count of users logged into the sql server at one time and store this information in a table. I need this information to trend the number...

Our company is looking for a disaster recovery plan and I thought I'd ask what everyone else is using?..i.e Hosting company, replication software etc. Thanks for the info in advance.

I'm running an update statement in a sql2000 environment that hangs and gives no error. But if I run the same statement in a sql2005 environment it runs fine. I'm using the same database on both environments. Here is the statement..... UPDATE F_PARTS SET F_PARTS.PA_ON_ORDER =...

I'm running a profiler trace on a web application and the duration for the audit logout process seems high. Profiler duration: 2280043 Audit Logout .Net SqlClient Data Provider webtma 10595 1776087 24 2280043 2880 96 2008-07-17 16:03:21.607 Initially I'd like to know what is audit logout...

I'm trying to create a derived column using the conditional operator. I have a source column called f_print_task that contains the following values 0,1,2,3. Based on the value in the f_print_task column I need to populate two destination columns with values. if f_print_task = 0 I want to put...

I desperately trying to find a solution to converting a varchar column to a bit column. I'm doing some data conversion between two databases and there is one table that has a varchar in the old database and needs to be converted to a bit in the new database. Can anyone assist with this...

I'm getting the following(see below) in my sqlserver errorlog. Its occurring every 5-6 minutes. Also it looks as though the server is restarting every time. SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some...

I am currently trying to merge three tables into a single table using SSIS. I can merge two but adding the third table is whats giving me problems. Has anyone performed this task before. If so any help would be appreciated.