Monday, March 26, 2012
I/O error
I am getting following while creating a non-clustered
index on a table having 20 million records. Can anyone
suggest a solution for this...
Server: Msg 823, Level 24, State 11, Line 1
I/O error 33(error not found) detected during write at
offset 0x000002c8450000 in
file 'F:\SQL2K_Data\PROD_Data.MDF'.
Connection Broken
Regards,
ManojManoj,
This error came from the Operating system and not SQL Server. It
indicates a problem with your underlying hardware, most probably your
disk subsystem. Can you reproduce it on another server?
Run sqlhdtst available from http://support.microsoft.com/?id=178444 to
reproduce the error on your hardware.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Manoj Raheja wrote:
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>|||Manoj
It seems to be serious problem.
I suggest to restore database from the last BACKUP or if you don't have then
from query Analyser, master database, execute
dbcc checkdb(<databas_name> )
"Manoj Raheja" <manoj_raheja@.hotmail.com> wrote in message
news:1bfe301c451ed$eaba6680$a101280a@.phx
.gbl...
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>
I/O error
I am getting following while creating a non-clustered
index on a table having 20 million records. Can anyone
suggest a solution for this...
Server: Msg 823, Level 24, State 11, Line 1
I/O error 33(error not found) detected during write at
offset 0x000002c8450000 in
file 'F:\SQL2K_Data\PROD_Data.MDF'.
Connection Broken
Regards,
Manoj
Manoj,
This error came from the Operating system and not SQL Server. It
indicates a problem with your underlying hardware, most probably your
disk subsystem. Can you reproduce it on another server?
Run sqlhdtst available from http://support.microsoft.com/?id=178444 to
reproduce the error on your hardware.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Manoj Raheja wrote:
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>
|||Manoj
It seems to be serious problem.
I suggest to restore database from the last BACKUP or if you don't have then
from query Analyser, master database, execute
dbcc checkdb(<databas_name>)
"Manoj Raheja" <manoj_raheja@.hotmail.com> wrote in message
news:1bfe301c451ed$eaba6680$a101280a@.phx.gbl...
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>
sql
I/O error
I am getting following while creating a non-clustered
index on a table having 20 million records. Can anyone
suggest a solution for this...
Server: Msg 823, Level 24, State 11, Line 1
I/O error 33(error not found) detected during write at
offset 0x000002c8450000 in
file 'F:\SQL2K_Data\PROD_Data.MDF'.
Connection Broken
Regards,
ManojManoj,
This error came from the Operating system and not SQL Server. It
indicates a problem with your underlying hardware, most probably your
disk subsystem. Can you reproduce it on another server?
Run sqlhdtst available from http://support.microsoft.com/?id=178444 to
reproduce the error on your hardware.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Manoj Raheja wrote:
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>|||Manoj
It seems to be serious problem.
I suggest to restore database from the last BACKUP or if you don't have then
from query Analyser, master database, execute
dbcc checkdb(<databas_name>)
"Manoj Raheja" <manoj_raheja@.hotmail.com> wrote in message
news:1bfe301c451ed$eaba6680$a101280a@.phx.gbl...
> Hello,
> I am getting following while creating a non-clustered
> index on a table having 20 million records. Can anyone
> suggest a solution for this...
> Server: Msg 823, Level 24, State 11, Line 1
> I/O error 33(error not found) detected during write at
> offset 0x000002c8450000 in
> file 'F:\SQL2K_Data\PROD_Data.MDF'.
> Connection Broken
> Regards,
> Manoj
>
Friday, March 23, 2012
I want to transfer ONLY new records AND update any modified records from Oracle into SQL S
I want to transfer ONLY new records AND update any modified records
from Oracle into SQL Server using DTS. How should I go about it?
a) how do I use global variable to get max date.
Where and what DTS task should I use to complete the job? Data Driven
Query? Transform data task? How ? can u give me samples. Perhaps you
can email me the Demo Package as well.
b) so far, what I did was,
- I have datemodified field in my Oracle table so that I can compare
with datelastrun of my DTS package to get new records
- records in Oracle having datemodified >Max(datelastrun), and transfer
to SQL Server table.
Now, I am stuck as to where should I proceed - how can I transfer these
records?
Hope u can give me some lights. Thank you in advance.Hi,
Should could start trying the DTS Import wizard. You can start it form
the SQL Server Enterprise Manager. Select the Databases node in the
console window. Choose All tasks | Import data from the context menu. In
one of the steps you can choose to write a query to select the data. In
another step, you can choose to save the wizards action into a new
package. Later, you van view and modify the package. It is found in Data
Transformation Services node in the console window.
Allthough there may be a far better way to get a max date value, you
might consider storing the value in a settings table in the Oracle
schema, so you can include in in you queries.
Good luck,
Roel Schreurs
fhadlaq@.yahoo.com schreef:
> I need a little help here..
> I want to transfer ONLY new records AND update any modified records
> from Oracle into SQL Server using DTS. How should I go about it?
> a) how do I use global variable to get max date.
> Where and what DTS task should I use to complete the job? Data Driven
> Query? Transform data task? How ? can u give me samples. Perhaps you
> can email me the Demo Package as well.
>
> b) so far, what I did was,
> - I have datemodified field in my Oracle table so that I can compare
> with datelastrun of my DTS package to get new records
> - records in Oracle having datemodified >Max(datelastrun), and transfer
> to SQL Server table.
> Now, I am stuck as to where should I proceed - how can I transfer these
> records?
> Hope u can give me some lights. Thank you in advance.|||hi Roel ,
thank you for ur reply , i have created a DTS Package and and filled it
with queries and stuff :) , it is working fine now , thanks again :)
Roel Schreurs wrote:
> Hi,
> Should could start trying the DTS Import wizard. You can start it
form
> the SQL Server Enterprise Manager. Select the Databases node in the
> console window. Choose All tasks | Import data from the context menu.
In
> one of the steps you can choose to write a query to select the data.
In
> another step, you can choose to save the wizards action into a new
> package. Later, you van view and modify the package. It is found in
Data
> Transformation Services node in the console window.
> Allthough there may be a far better way to get a max date value, you
> might consider storing the value in a settings table in the Oracle
> schema, so you can include in in you queries.
> Good luck,
> Roel Schreurs
> fhadlaq@.yahoo.com schreef:
> > I need a little help here..
> > I want to transfer ONLY new records AND update any modified records
> > from Oracle into SQL Server using DTS. How should I go about it?
> > a) how do I use global variable to get max date.
> > Where and what DTS task should I use to complete the job? Data
Driven
> > Query? Transform data task? How ? can u give me samples. Perhaps
you
> > can email me the Demo Package as well.
> > b) so far, what I did was,
> > - I have datemodified field in my Oracle table so that I can
compare
> > with datelastrun of my DTS package to get new records
> > - records in Oracle having datemodified >Max(datelastrun), and
transfer
> > to SQL Server table.
> > Now, I am stuck as to where should I proceed - how can I transfer
these
> > records?
> > Hope u can give me some lights. Thank you in advance.sql
I want to Display records by Page
I am in the process to building a report using Reporting Services. The
report are invoices but I want the invoices to display one per page. I am
using a List and the report display invoice 1 , 2, 3 in the same page and I
want to diplay Invoice 1 in Page 1, Invoice 2 in Page 2 and so on... Please
advice!
Thanks,
Adolfo
--
DotNet GuerrillaAdolfo,
Try grouping by the invoice and then setting the group to have a page break
at the end of the group.
"DotNet Guerrilla" wrote:
> Hi,
> I am in the process to building a report using Reporting Services. The
> report are invoices but I want the invoices to display one per page. I am
> using a List and the report display invoice 1 , 2, 3 in the same page and I
> want to diplay Invoice 1 in Page 1, Invoice 2 in Page 2 and so on... Please
> advice!
> Thanks,
> Adolfo
> --
> DotNet Guerrilla|||Thank you David,
--
DotNet Guerrilla
"David Siebert" wrote:
> Adolfo,
> Try grouping by the invoice and then setting the group to have a page break
> at the end of the group.
> "DotNet Guerrilla" wrote:
> > Hi,
> > I am in the process to building a report using Reporting Services. The
> > report are invoices but I want the invoices to display one per page. I am
> > using a List and the report display invoice 1 , 2, 3 in the same page and I
> > want to diplay Invoice 1 in Page 1, Invoice 2 in Page 2 and so on... Please
> > advice!
> >
> > Thanks,
> > Adolfo
> > --
> > DotNet Guerrilla
Wednesday, March 21, 2012
I want to move an existing table from another
I want to move an existing table from another.
Example
B.mdf dbo.xx toC.mdf dbo.xx
B.mdf dbo.xx has records - I created a script and install the script for C.mdf dbo.xx
C.mdf dbo.xx is empty -
All I need now is to populate the records from B.mdf dbo.xx to the empty C.mdf dbo.xx
I was telling I could do a cut and paste to copy the dbo.xx
Thank you in advance.
~ Peaches ~
With SQL 2000 use DTS to copy to contents. With SQL2005 use SSIS.
There is another way and you don't need to create the target table first:
You can copy database tables from one database to another. Here is a sample for you to move one table from one database to another database without creating the new table first.
Run this from the database you want to export data:
SELECT*INTO newDataBaseName.dbo.yourNewTableFROM tableToExpost
|||Couple of things to keep in mind are:
(1) If you already created the target table with PK-FK relationships, indexes, you can either use DTS or
INSERT INTO TargetDB.dbo.TargetTable (<columns>)
SELECT <columns> FROM SourceDb.dbo.SourceTable
(2) If the target table does not exist, then you can uss limno's approach and do a SELECT * INTO TargetDb.dbo.TargetTable FROM SourceDB.dbo.SourceTable WHERE <Condition>
(3) IF there is lot of data ( as in > few million rows) you might also want to look into BCP utility in Books On Line.
|||Thank you very much !!!!!
I was able to take care of this in 5 minutes ...
Whew::: This makes my life easier today.
~ Peaches ~
Monday, March 19, 2012
I update SqlExpress database but i don't see the records
Hi everybody! I 'm facing a strange problem and i hope someone could help me understand what i'm doing wrong.
The situation has as follows:
1. I make a new windows project in VB .Net 2005 and add a listbox to form1
2. With "Add new Item" from the solution explorer I add a new Sql Database from the templates to the project (e.g. MyDatabase1.mdf)
3. I add a table to the SQL Database e.g. Books - with 2 only fields (BookID and BookDescription) and I add some records to the table
4. I add a new DataSource to the project and I bind the LIstBox to the table Books.
5. I add two buttons to the project. Button1 adds a new book, Button2 gives me record by record the books in the table (e.g. 1-Vb for begginers, 2-.Net for begginers etc.)
6. I Run the project and I add a new record to the table through button1. With button2 I confirm the record is added to the table (3-Vb for me)
Till here, everything works fine...
7. I close the project. I open the table Books to see for the new record (VB for me). There is no record in the Database!
Any idea?
P.S. I've done all possible ways to add the new record (with tableadapter and with a SqlCommand). In both ways the record in runtime is added to the table and it can be confirmed.
But when I close the project and try to find it , there is no record at all!
Hi,
make sure you call the update method on your SQLDataAdapter. Otherwise the data won′t be updated though the Dataset you are working with a in its normal "disconnected" mode.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Thanks for the suggestion but of cource and i do call the update method. As I told you I can confirm that the records have been inserted.
The point is that I cannot see the records when I close the project
|||Why do you think you got a confirmation ?Friday, March 9, 2012
I need to take the records from my MS Access DB and migrate them to SQL 2000
I need to take the records from my MS Access DB and migrate them to SQL. I have both db table structures somewhat mapped out and its only about 43 records or lines. The data in Access is all kept in a single table and in SQL I need to have it populate seperate individual tables.
I've successfully imported and exported data in SQL by doing simple DTS and queries. With this transfer I don't know how to write the correct query or statement.
Try the links below for options because Microsoft bought a migration tool company you can test drive it or use ready DTS packages from the second link. Hope this helps.
http://www.microsoft.com/sql/migration/default.mspx
http://www.sqldts.com/?220
Wednesday, March 7, 2012
I need some help on my Sql string
i have a sqlString to select records from database as below,
StrSql="Select Distinct ItemCode From StockOnHand Where " & _
"Description like @.Des"
this sql string works correctly, but i need to display those distinct ItemCode with their Description and Price, but i failed using the sql String at below...
StrSql="Select Distinct ItemCode, Description, Price From StockOnHand Where " & _
"Description like @.Des"
I know there is something wrong with my sql string.. but my SQL knowledge is onli at the basic level, can any1 pls help me on this...?
Thanks in advances
life's Ng::I know there is something wrong with my sql string..
Good, let's start VERY VERY VERY at the basics.
This:
::but i failed using the sql String at below...
will NOT get you help.
It did not "just fail", it gave you an error string DESCRIBING the error. Now, even while you may not understand this error string when you read it (and normally it is pretty self-explaining), WE may want to have a look at the EXACT error coming there.
So please, post the error you got, too.
Btw, using:
"Select DISTINCT" is about the best way to kill your peroformance anyhow. And - sorry - not really smart in the queries you give there. Unless, naturally, you want your database to be terribly slow.|||Without knowing the exact error, I can tell you that this is not correct:
"Description like @.Des"
try this instead:
"Description like '%@.Des%'"|||Hi, Sorry for my mistake to not descript my problem well and thanks for ur info bout "DISTINCT"
i dint receive any error with both of the SQL statements.
In my table, there is 10 columns ("Description", "ItemCode", "Prices".......)
the 2nd one return records which is not expected... few records selected with the same ItemCode, i onli want the distinct ItemCode displayed according to its description.
This page is created just for user to search&check on the ItemCode using their Description... I think i need to reconstruct my database design.
Best Regards
life's Ng
Sunday, February 19, 2012
I need help performing a date query where the output is all related records to one specific date
Hi Everybody,
I need help with a query where the output is all records related to one specific date. Like take for ex. all records which have been entered on 5/26/07. I would really appreciate the help. Thanks in advance. . .
I've pasted the code which I've been using but just gives me a reserved error 3646.
SELECT Escal_Tracker.Escal_Type, Escal_Tracker.Cross_func, Escal_Tracker.cas_no, Escal_Tracker.Inc_no, Escal_Tracker.esc_com, Escal_Tracker.nt_login, Escal_Tracker.Date
FROM Escal_Tracker
WHERE date = '5/26/07';
Regards,
Inspired_One
Hi inspired_one,
Move the thread from Visual Basic Forum in order to get better answers, since this issue is related to Transact-SQL.
Thanks for your understanding!
Your code is 'mostly' ok. I recommend using the ISO date format which for SQL Server, is unabiguous. Also, if any of the Date field values include a time component, they will not match. The best way to accomplish a filter criteria for a complete day is to bracket all values between midnight the desired date, and just before midnight the next date. Also when you use reserved words as your table or column names, you MUST then always enclose them in square brackets to let the server know that you made a mistake and now must type extra keystrokes to compensate. ( [Date] is a reserved word.) Refer to Books Online, Topic: 'Reserved Words'
Perhaps this will work for you...
Code Snippet
SELECT
e.Escal_Type,
e.Cross_func,
e.cas_no,
e.Inc_no,
e.esc_com,
e.nt_login,
e.[Date]
FROM Escal_Tracker e
WHERE ( e.[Date] >= '2007/05/26'
AND e.[Date] < '2007/05/27'
Arnie,
Thanks a lot for the help bro. that actually led me to the answer to this problem which was .
SELECT
e.Escal_Type,
e.Cross_func,
e.cas_no,
e.Inc_no,
e.esc_com,
e.nt_login,
e.[Date]
FROM Escal_Tracker e
WHERE ( e.[Date] >= # " & varfirstdate & " # AND e.[Date] < # " & varseconddate & " #
The difference is I'm using vba variables for this code. . .
Regards,
Inspired one
I need help performing a date query where the output is all related records to one specific date
Hi Everybody,
I need help with a query where the output is all records related to one specific date. Like take for ex. all records which have been entered on 5/26/07. I would really appreciate the help. Thanks in advance. . .
I've pasted the code which I've been using but just gives me a reserved error 3646.
SELECT Escal_Tracker.Escal_Type, Escal_Tracker.Cross_func, Escal_Tracker.cas_no, Escal_Tracker.Inc_no, Escal_Tracker.esc_com, Escal_Tracker.nt_login, Escal_Tracker.Date
FROM Escal_Tracker
WHERE date = '5/26/07';
Regards,
Inspired_One
Hi inspired_one,
Move the thread from Visual Basic Forum in order to get better answers, since this issue is related to Transact-SQL.
Thanks for your understanding!
Your code is 'mostly' ok. I recommend using the ISO date format which for SQL Server, is unabiguous. Also, if any of the Date field values include a time component, they will not match. The best way to accomplish a filter criteria for a complete day is to bracket all values between midnight the desired date, and just before midnight the next date. Also when you use reserved words as your table or column names, you MUST then always enclose them in square brackets to let the server know that you made a mistake and now must type extra keystrokes to compensate. ( [Date] is a reserved word.) Refer to Books Online, Topic: 'Reserved Words'
Perhaps this will work for you...
Code Snippet
SELECT
e.Escal_Type,
e.Cross_func,
e.cas_no,
e.Inc_no,
e.esc_com,
e.nt_login,
e.[Date]
FROM Escal_Tracker e
WHERE ( e.[Date] >= '2007/05/26'
AND e.[Date] < '2007/05/27'
Arnie,
Thanks a lot for the help bro. that actually led me to the answer to this problem which was .
SELECT
e.Escal_Type,
e.Cross_func,
e.cas_no,
e.Inc_no,
e.esc_com,
e.nt_login,
e.[Date]
FROM Escal_Tracker e
WHERE ( e.[Date] >= # " & varfirstdate & " # AND e.[Date] < # " & varseconddate & " #
The difference is I'm using vba variables for this code. . .
Regards,
Inspired one