Viewing 15 posts - 1 through 15 (of 27 total)
What I don't like in Michael's query is this: "null as AuditXml". I would say that in this case SQL Server does not know what type is this field. I...
May 22, 2008 at 1:24 am
I would say that either the tables (PolicyProcessAudit2 and PolicyProcessAudit have different structures - one of columns in the first table is longer than column length in the other table,...
March 26, 2008 at 7:58 am
The log is hard to read. I suggest that you use the sp_lock procedure:
The information is provided in a very clear way. Especially you have ObjectId and all...
March 12, 2008 at 9:25 am
I think that if you start Profiler, you will see the queries. Maybe Agent service is running some procedures in background. Or check whether you have any active jobs.
March 12, 2008 at 5:09 am
Are you sure that the export works correctly? I heard about various errors caused by "queryout" parameter and I prefer rather to create a view and export the view with...
March 12, 2008 at 4:46 am
I cannot directly answer to your question but I have few remarks:
1. If you use such universal key generator table, sooner or later you will run into locks/deadlocks problem (it's...
March 12, 2008 at 1:57 am
I often work as an advisor on database tuning for various companies and from my experience the hardware was never an issue (although it's good to have top level hardware)....
March 12, 2008 at 1:26 am
In the meantime I checked that BCP import works fine with views with columns renamed from e.g.: [Desc] to [Tmp_Desc_Tmp] - so renaming columns in the database is not required....
March 11, 2008 at 4:37 am
Thank for the hint with import view. In fact I'm exporting data by means of a view. In this case I don't even need to rename the 'Desc'. It is...
March 11, 2008 at 1:52 am
You may take a look at samples available on the Internet like:
or http://www.windowsitlibrary.com/Content/77/14/1.html (look at second page - there are examples there)
or directly to Microsoft...
March 10, 2008 at 11:36 am
Data models for Purchase Order are well known and you don't need to reinvent it from scratch. I suggest that you start Google and type "Purchase Order Data Model" (and...
March 10, 2008 at 11:28 am
Jeff is right. If you start BCP at 5:00PM on Friday, you will get the job done in 10 minutes (so you can still have few beers in the evening)....
March 10, 2008 at 7:08 am
You may consider the SqlBulkCopy class from .Net Framework 2.0:
older version of the same: SQL-DMO objects,
or just simple INSERT statement (INSERT INTO ... SELECT * from linked_server_table).
March 10, 2008 at 6:48 am
It's because the servers have collation set up in a different way; on one server it's on server level, and on the other it's on database level. And also something...
March 10, 2008 at 6:34 am
In the first version I was using native format but than I found out that national charactes are not transferred correctly despite the fact that I provided correct code page....
March 10, 2008 at 4:57 am