Search results for query: *

I have a large table with 24 million rows. I have one complex update statement that is updating about 15 columns, but it is taking 4 hours to update the entire table. I noticed when evaluating the table structure, that I have datatypes that are larger than necessary. For example, I have a...

My source table has a integer key that sequentially numbers all the records inserted. I copied the records from that table into another with a slightly different structure for further staging. I did not set any constraints/properties on the second table's corresponding integer key, because I...

How do you load Query Designer? I see the reference in the manuals as Visual Database Tools. Is this a tool I have to load during the installation process? Thank you for your help!

I'm attempting to make SQL Server transparent from a particular user's perspective. The user is very comfortable with MS Access. I have not done much using Access as a frontend to SQL Server, except linked tables through an ODBC connection. What are the basic steps/commands to allow...

What is the most efficient route to go? Joining a table that has 2 million records to a table that has 26 million and feeding the 26 million rolls into an OLAP model. OR Or having the 2 million row table join to a lookup table of about 100,000 rows and calculate on the fly the 26 million...

I am using user-defined functions in a SQL View to create additional columns. For example, I may have a product function that receives a parameter from a field and uses a case statement to pass back a product description such as "receiver". I used to have the case statements embedded directly...

Does SQL Server have a method of running procedures on one record, and then moving to the next record and to the next, etc.? The analogy is similar to old dbase/foxpro using the NEXT and EOF (end of file) commands.