Viewing 15 posts - 2,236 through 2,250 (of 3,221 total)
Excuse this reply as it is not a complete answer to your question, but hopefully it will give you a place to start.
For date of last update of statistics for...
December 18, 2009 at 9:06 am
Ran across this article which might spread some light on your problem:
I believe the required driver is also available to download from:
December 17, 2009 at 11:17 am
If you are using EXCEL earlier than 2007 have you tried OPEN ROWSET .
An example:
INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\MSSQL\Test.xls', SELECT * FROM [Sheet1$]')
SELECT * FROM Keywords
You would have to use...
December 16, 2009 at 2:28 pm
This link might provide you with the information you are looking for
http://www.tek-tips.com/viewthread.cfm?qid=832355
and
December 15, 2009 at 1:06 pm
This probably as good a place to start as any other
December 15, 2009 at 11:47 am
Were you thinking of storing multiple columns from the source into a single column of this data type?
Not knowing your actual data and its sequence across a row of...
December 14, 2009 at 4:37 pm
While waiting for some one with a better understanding of data storage you might while away your time reading the following, in particular how the database engine stores VARCHAR(Max) data.
December 14, 2009 at 1:34 pm
If you present your data as discussed in the link in my signature block, and be very specific about what you desire to do with this data I would be...
December 14, 2009 at 12:11 pm
I am making the assumption that you wish to perform tasks such as selects, updates, inserts, deletes on DBs located on a linked server.
If that is the situation...
December 13, 2009 at 2:05 pm
Might I suggest that you use GOOGLE, MIcrosoft's TECH NET and MSDN (Microsoft Developer Network) to search for what you want and then if you have a specific problem...
December 13, 2009 at 7:40 am
You might wantto review this dynamic management view before and after your rebuild
SQL Server 2005 Books Online (September 2007)
sys.dm_db_index_physical_stats
December 13, 2009 at 7:24 am
Here is a method to "adjust" all the addresses to match by removing any unwanted periods .
CREATE TABLE #Table(Id INT, Address VARCHAR(20),Description VARCHAR(40))
INSERT INTO #Table
SELECT 1,'1111 E.Valley St','Period w/o...
December 12, 2009 at 12:25 pm
Barry go to this site for a preview of your new car
December 12, 2009 at 10:55 am
My suggestion to you would be to create a requirements document.
Some simple questions which need to be answered before starting the database design would be:
1. What model...
December 12, 2009 at 8:49 am
Might I suggest you use Books On Line
SQL Server 2005 Books Online (September 2007)
SQL Server Profiler Terminology
It will explain how you can set up a trace...
December 11, 2009 at 4:09 pm
Viewing 15 posts - 2,236 through 2,250 (of 3,221 total)