Viewing 15 posts - 47,641 through 47,655 (of 49,571 total)
Terry Gamble (1/18/2008)
The table being imported into is indexed against duplicates based on cust_id field.
What I'm thinking...
January 19, 2008 at 9:54 am
Terry Gamble (1/18/2008)
truncate table [LM_Date1]
insert into [LM_Date1]
select
...
Order by H.[Sold_Date] DESC
Order bys have no real use in an insert statement. The 'order' that the data's stored in the table depends...
January 19, 2008 at 9:51 am
It looks like it gets the trace ID from the nic_aud_trace table. Check that table, see what's in there
declare get_traces cursor for
select curr_trace_id from nic_aud_trace
Also, it's not tracing to a...
January 19, 2008 at 9:47 am
Not with the native SQL backup/restore. I know litespeed can restore a single table from a backup. It's a time-intensive operation on a larger DB, but it can be done....
January 18, 2008 at 11:51 am
Yes. There's another post active at the moment on exactly this issue.
If you don't prefix the table you risk double lookups for SQL to find the table and you also...
January 18, 2008 at 11:48 am
Brandie Tarvin (1/10/2008) Lastly, I can't remember if I heard the Dev exams are harder or easier than the Upgrade Admin cert. Thoughts on this? Or is it...
January 18, 2008 at 11:36 am
Brain dumps are nothing more than cheating. Using (or passing on) brain dumps can get you your MS certifications revoked, permanently.
The MS links I gave earlier list the courses and...
January 18, 2008 at 11:25 am
No. All this is doing is dropping a bunch of tables, procedures and functions if they exist.
To stop a trace requires the sp_trace_setstatus proc to be called. (Assuming that we...
January 18, 2008 at 11:15 am
Compile by running them?
By recreating them?
By calling sp_recompile (Which actually does nothing other than mark the execution plan to be recompiled on next run) ?
Some other way?
What happens...
January 18, 2008 at 12:15 am
What do you mean by 'become invalid'?
January 17, 2008 at 11:58 pm
The first one usually means that there's a syntax error in the statement that you're sending to the remote server.
Thse second one is because the SQL server that you're running...
January 17, 2008 at 5:38 am
It's a property of logarithms.
Edit: My maths stinks. So out of practice.
e(ln(x) + ln(y)) = x * y for all values of x and y
January 17, 2008 at 5:16 am
Look up Pivot in Books online. I think it may do what you want.
Also, take a look at this article. It's not completely clear which columns are which in your...
January 17, 2008 at 5:15 am
How ae you loading the data? If you're using a bulk load (bcp, Bulk insert) then put the DB into bulk-logged recovery.
In that mode, bulk operations are minimally logged and...
January 17, 2008 at 5:13 am
avipenina (1/17/2008)
are you sure that rebuild index do what update statics and reorganized index do?
Very sure. If I wasn't sure, I wouldn't have said so. But, feel free to check...
January 17, 2008 at 2:42 am
Viewing 15 posts - 47,641 through 47,655 (of 49,571 total)