Search results for query: *

I want to learn sql as in writing sql scripts and procedures and things like that. Thanks for the response...any others???

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...

The server will be used for reporting services and sql server only.

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 mean logged into SQL SERVER as a whole. From time to time we get questions about how many people have been logged into the sql server at any given time and I want to be able to track this. Maybe have a script that runs a couple of times a day and store the results in a table for historical...

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.

Thanks for the reply..... When I tried this it failed with column prefix 'ORIG' does not match with a table name or alias name used in the query. Its almost as if this is running in an infinite loop. Anyone else hav any ideas....???

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 =...

Thanks for your reply...... But, Is this a bad thing and something I need to worry about or look into further.

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...

Thanks for the response....But there still seems to be an issue with either the format or the operator I used the following format... FO_PRINT_TASK == 0 ? 0 : 0 and it works fine...but with I try to add the other condition FO_PRINT_TASK == 0 ? 0 : 0 || FO_PRINT_TASK == 1 ? 0 : 1 it does not...

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...

those were my thoughts.....but just needed someone in my amen corner. Thanks

What if the tables dont have any common column on which to join the tables. Basically having 3 tables that dont have any fk relationships between them.

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.