Programming SQL

Fastest way to move lots of data between databases on same ser
Erland, Thanks for the response. I have the db in Simple recovery mode for this operation, so logging shouldn't be an issue right? On a single statment insert into, if I have 50 GB of data, does that mean that I need more than 50Gb of RAM in order to avoid heavy useage of disk in the TempDB? Thanks, D... 11 Jun 2010 19:17

Calling a user-defined function?
In the below statement where I am calling user-defined function dbo.udf_calcbill_hotel, is that a legal select statement? I keep getting syntax errors and I can't figure out what's wrong. I'm attempting to call the function by passing in data from the other table that the function table is joined to. If this i... 11 Jun 2010 19:17

any word order match
Hi, I wanted to design any word order query for one of my assignment. I have a table containing around 10 million records, containing only 2 columns for example. [id] and [text] as follows. [id] is identity. [id] | [text] ------------- 1 | foo boo xoo 2 | foo xoo boo 3 | candy 4 | abc xy 5 ... 11 Jun 2010 03:49

Fastest way to move lots of data between databases on same server.
I need to move 100 Million rows of data from a table in one SQL 08 DB to another database on the same server. What is the fastest way to do this? - Insert Into in one big query - Multiple Insert Into statements looping through xxxx number of rows at a time to "batch" it up -bcp -BULK INSERT -SSIS Accordi... 11 Jun 2010 07:03

Operation between alias
I have a query like this; SELECT blabla, (SELECT ....) AS value1, (SELECT ....) AS value2 .... Why cant' I simply add value1 + value2 to the select, but I need to repeat the entire subqueries in order to do operations between them? Thanks. Luciano ... 12 Jun 2010 14:54

image field where clause
I have sql table (20million records)with a image field A. I need to set up a where clause like ---- select * from tablea where A(image type) is not null. that query takes forever. How do I optimize that query? Thanks, ... 10 Jun 2010 19:04

Plain Text In Image Field
It was not my choice to use an image field to store text in software released in 2009, but here it is... I'm trying to debug a script that is writing updates from another database to the history log that uses an image field to store the text data. All is well using either writeText or updateText w/out errors. ... 10 Jun 2010 19:04

Grouping stored procedures
Hello folks. I have an application that uses about 110 "small" SPs. Most are only 4 lines long. I would like to be able to group my SPs together. I suppose I could add a parameter to each group of SPs and then use the case functionality such as create proc GetFruit @id,@fruit varchar(20),@newfruit varchar... 10 Jun 2010 03:28

sql 2000 error handling
hi, I have a sql SP that process text file into a sql table. I need to have error hjandling for the SP. .net interface can get the error message. Raiserror() ---how do i get error message? SQL2000 sp4a thanks, ... 10 Jun 2010 16:49

SQL insert query help needed
Hi all I am new to SQL and i would to know if anyone can help me work around this problem: i have 2 tables table1 (column1, column2, column3, column4) where column1 = integer - auto increment, clumn2 = text, column3 = text , column 4 = integer and table2 (column1 , column2) where column1 = integer - au... 10 Jun 2010 22:22