Viewing 15 posts - 3,121 through 3,135 (of 7,429 total)
I haven't noticed any of our queries running any slower between the SP revisions. However, I did do a DBCC DBREINDEX after the update along with sp_updatestats and DBCC UPDATEUSAGE....
April 23, 2003 at 3:41 am
However 5 million records is not a large enough percentage of the 200 million to make using SELECT INTO worth while. The reason is you are then building a table...
April 23, 2003 at 3:38 am
There are many outstanding possibilities that affect either. Primary amoung them is indexes. If the update causes a column that is involved in an index to change it may have...
April 23, 2003 at 3:32 am
You might try reinstalling SP2 or find the proper version of the missing file and put in the proper place.
April 22, 2003 at 8:20 am
Take a look at
sp_tables_ex
in SQL BOL.
April 22, 2003 at 5:12 am
I hope not but I have not had any issues related to this. However, I do know Amazon sells there list to companies unless you explicitly tell them not too....
April 22, 2003 at 5:07 am
Always see the redist.txt file on the disk for these things. But here is the pieces for DTS
quote:
Data Transformation Services (DTS)----------------------------------------------
File...
April 22, 2003 at 3:43 am
I ended up out of town on the weekend and didn't get a chance. I will see if I can get a chance today and try plain and then Eval...
April 22, 2003 at 3:30 am
sp_trace_create has an output parameter to fill that for you. You declare your value then run sp_trace_create to get the output and then you pass to later items.
By default at...
April 21, 2003 at 10:36 am
No you cannot place in a specific position. The way EM does this is by making a new table with the new column and populating from the old and scripting...
April 21, 2003 at 4:28 am
You do have to keep in mind the 5 concurrent operations fact. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/distsql/distsql_0mhx.asp
and a bit more here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa2_9gz4.asp which explains the performance decreases over 5 concurrent operations based on...
April 21, 2003 at 4:22 am
Andy is correct and this it what makes it hard to keep up. But uniqueidentifiers as PKs will make it easiest to identify incositancies as they are unique and will...
April 21, 2003 at 4:15 am
I have not seen a way to DELETE the data. However you can DROP TABLE sheetname as a SQL task then do create as another then run the push this...
April 21, 2003 at 4:08 am
What you are loking for is called a Pivot table. In SQL The way to do this is by using CASE and GROUP BY to move the data sideways.
With a...
April 21, 2003 at 3:47 am
We use Dells and Compaqs. Both have been quite well for us and we are considering moving to blade servers in some areas.
Personally I like the Dells but stress them...
April 21, 2003 at 3:28 am
Viewing 15 posts - 3,121 through 3,135 (of 7,429 total)