Late Get error

While doing a demonstration of an alpha application written in VB.NET, I got
an error message complaining of a Late Get. I am presuming that this is a
SQL Server related error, rather than a VB.NET error, but not sure. Any
know what might generally be causing this error message?
I have never seen this error during extensive testing of that form prior to
the demonstration, and tried to recreate it after the demonstration, but to
no avail.
Any thoughts would be appreciated.
Dean SlindeeCan you post the exact error message, plus some demo code. Someone might
have some insight to the problem.
-oj
"Dean Slindee" <slindee@.charter.net> wrote in message
news:hU1Wd.29517$Ep.6413@.fe06.lga...
> While doing a demonstration of an alpha application written in VB.NET, I
> got
> an error message complaining of a Late Get. I am presuming that this is a
> SQL Server related error, rather than a VB.NET error, but not sure. Any
> know what might generally be causing this error message?
> I have never seen this error during extensive testing of that form prior
> to
> the demonstration, and tried to recreate it after the demonstration, but
> to
> no avail.
> Any thoughts would be appreciated.
> Dean Slindee
>

last is not a recognised function name

Hi all,
ive tried to run a query in a view and am getting this error message:
'last' is not a recognised function name
i was sure that last was used in sql, how can i get the same result if it wont accept 'last'?
greguse MAX

LAST is a microsoft access function|||oh yeah!! forgot the syntax changed-

cheers

greg

Large text column

I'm trying to store a binary data file in my database. I've tried data types image, varchar(max) and text. I don't get error message on loading the data but as soon as the text file exceeds 32,000 bits a query returns an empty data set.

Is this a SSMS display problem and the data is really there? Or is this another one of Microsoft's memory bugs?

After further study it would appear that the data is being loaded, it is just not being displayed in SSMS.

Is this a Microsoft "feature" that is scheduled to be fixed in 2008?

|||

Hmmh, for my opinion SQL Server MS should be used for adminstration, not a presentation layer for you data. I did not reflect the sources to see if this is limited by code, but you should consider using the query window to see more data instead of using the grid. You used the grid only so far, right ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

We typed a SELECT fieldname FROM tablename in a new query and the display window is blank. We've tried both view results as table AND view results as grid. No error message, just a blank display. We're not using SSMS as a presentation layer, that is all done with C#. We are only trying to see if the table load was successful.

We can copy paste from the cell to word so we're assuming it is being handled. We were just wondering if some unknown bug was going to bite us as we proceed, assuming the data IS there.

Large text column

I'm trying to store a binary data file in my database. I've tried data types image, varchar(max) and text. I don't get error message on loading the data but as soon as the text file exceeds 32,000 bits a query returns an empty data set.

Is this a SSMS display problem and the data is really there? Or is this another one of Microsoft's memory bugs?

After further study it would appear that the data is being loaded, it is just not being displayed in SSMS.

Is this a Microsoft "feature" that is scheduled to be fixed in 2008?

|||

Hmmh, for my opinion SQL Server MS should be used for adminstration, not a presentation layer for you data. I did not reflect the sources to see if this is limited by code, but you should consider using the query window to see more data instead of using the grid. You used the grid only so far, right ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

We typed a SELECT fieldname FROM tablename in a new query and the display window is blank. We've tried both view results as table AND view results as grid. No error message, just a blank display. We're not using SSMS as a presentation layer, that is all done with C#. We are only trying to see if the table load was successful.

We can copy paste from the cell to word so we're assuming it is being handled. We were just wondering if some unknown bug was going to bite us as we proceed, assuming the data IS there.

Large text column

I'm trying to store a binary data file in my database. I've tried data types image, varchar(max) and text. I don't get error message on loading the data but as soon as the text file exceeds 32,000 bits a query returns an empty data set.

Is this a SSMS display problem and the data is really there? Or is this another one of Microsoft's memory bugs?

After further study it would appear that the data is being loaded, it is just not being displayed in SSMS.

Is this a Microsoft "feature" that is scheduled to be fixed in 2008?

|||

Hmmh, for my opinion SQL Server MS should be used for adminstration, not a presentation layer for you data. I did not reflect the sources to see if this is limited by code, but you should consider using the query window to see more data instead of using the grid. You used the grid only so far, right ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

We typed a SELECT fieldname FROM tablename in a new query and the display window is blank. We've tried both view results as table AND view results as grid. No error message, just a blank display. We're not using SSMS as a presentation layer, that is all done with C#. We are only trying to see if the table load was successful.

We can copy paste from the cell to word so we're assuming it is being handled. We were just wondering if some unknown bug was going to bite us as we proceed, assuming the data IS there.

Large Page Extensions

Hello
After a reboot on my SQL Server 2000 64 bits the following message appeared
on the Errorlog:
Cannot use Large Page Extensions: Failed to allocate 32MB
I searched Google and the Books On-Line but found nothing about it.
Could someone point to me some documentation about that message? Or explain
what does it means?
Thanks
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.org
On 64-bit platforms, SQL Server makes use of the 'large page' API support
provided by the operating system. You can read more about it here
http://msdn.microsoft.com/library/de...e_support.asp.
The error you're receiving is hinted at in the article, but is due to the
fact that SQL Server cannot get a contiguous region of 32 MB for the large
page region.
Hope that helps.
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos Selonke" <CarlosSelonke@.discussions.microsoft.com> wrote in message
news:73B198C4-7B9B-4063-8866-97D4108B3F06@.microsoft.com...
> Hello
> After a reboot on my SQL Server 2000 64 bits the following message
> appeared
> on the Errorlog:
> Cannot use Large Page Extensions: Failed to allocate 32MB
> I searched Google and the Books On-Line but found nothing about it.
> Could someone point to me some documentation about that message? Or
> explain
> what does it means?
> Thanks
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org

Large Page Extensions

Hello
After a reboot on my SQL Server 2000 64 bits the following message appeared
on the Errorlog:
Cannot use Large Page Extensions: Failed to allocate 32MB
I searched Google and the Books On-Line but found nothing about it.
Could someone point to me some documentation about that message? Or explain
what does it means?
Thanks
--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.orgOn 64-bit platforms, SQL Server makes use of the 'large page' API support
provided by the operating system. You can read more about it here
http://msdn.microsoft.com/library/d...ge_support.asp.
The error you're receiving is hinted at in the article, but is due to the
fact that SQL Server cannot get a contiguous region of 32 MB for the large
page region.
Hope that helps.
--
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos Selonke" <CarlosSelonke@.discussions.microsoft.com> wrote in message
news:73B198C4-7B9B-4063-8866-97D4108B3F06@.microsoft.com...
> Hello
> After a reboot on my SQL Server 2000 64 bits the following message
> appeared
> on the Errorlog:
> Cannot use Large Page Extensions: Failed to allocate 32MB
> I searched Google and the Books On-Line but found nothing about it.
> Could someone point to me some documentation about that message? Or
> explain
> what does it means?
> Thanks
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org

Large Page Extensions

Hello
After a reboot on my SQL Server 2000 64 bits the following message appeared
on the Errorlog:
Cannot use Large Page Extensions: Failed to allocate 32MB
I searched Google and the Books On-Line but found nothing about it.
Could someone point to me some documentation about that message? Or explain
what does it means?
Thanks
--
Carlos Eduardo Selonke de Souza
http://carlos.geekbunker.orgOn 64-bit platforms, SQL Server makes use of the 'large page' API support
provided by the operating system. You can read more about it here
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/memory/base/large_page_support.asp.
The error you're receiving is hinted at in the article, but is due to the
fact that SQL Server cannot get a contiguous region of 32 MB for the large
page region.
Hope that helps.
--
Ryan Stonecipher
Microsoft SQL Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Carlos Selonke" <CarlosSelonke@.discussions.microsoft.com> wrote in message
news:73B198C4-7B9B-4063-8866-97D4108B3F06@.microsoft.com...
> Hello
> After a reboot on my SQL Server 2000 64 bits the following message
> appeared
> on the Errorlog:
> Cannot use Large Page Extensions: Failed to allocate 32MB
> I searched Google and the Books On-Line but found nothing about it.
> Could someone point to me some documentation about that message? Or
> explain
> what does it means?
> Thanks
> --
> Carlos Eduardo Selonke de Souza
> http://carlos.geekbunker.org

Large number of rows issue

Hi ,

There is a table with the following structure

_
Date-Time of Operation | Message | details | Reason | Username | IP | MAC-Address
_

A user can fire query based on some condition on columns. The maximum no of rows that should be returned are 1 billion.

By default the data returned to the view is sorted on Date-Time. Further user can sort the data in the view on Message, details , reason , username , IP , Mac-Address.

Suppose i have a scenerio where the user first gets the 1 billion records, then some records are inserted in the database.Then user sort on IP column. Now for differnt sorting if i again fire the query new data will be obtained. Thus i will get different result.

One way is to maintain the data in my memory. But the number of records are huge,so this is not a good solution. So what should i do to get the disconnected data without actually getting everything in the memory.

Regards,
Sunil

One way would be to have a stored procedure to fire this information into another table, then have a view of that table. Hence you are in control of the "loading" of that data for reporting purposes.|||

Hi,

I had a similar case in my company.

The solution for the case was creating a second instance on a different server which keeps denormalized data partitioned according to a date field. And loading the most recent partition into memory.

Also the query should have to use the date field since it will use that criteria in the index.

The OLTP database server was using 4GB of RAM on the other hand this second instance was using 12 GB of RAM only for maintaining such reporting processes.

Perhaps you may create covering index on the table. But this will increase the size of data.

Eralper

Large Log File

Have a log file that seems to be growing out of all proportion to the
database.
Have tried SHRINKDATABASE and SHRINKFILE
Get error message 'Cannot shrink log file because all logical files are in
use'
As all transactions completed ages ago, am puzzled as to why MSDE seems to
want to hang on to such a big log file.
How can I get MSDE to clear all the transactions, to the database, so can
reduce the log file size?
hi Kevin,
Kevin wrote:
> Have a log file that seems to be growing out of all proportion to the
> database.
> Have tried SHRINKDATABASE and SHRINKFILE
> Get error message 'Cannot shrink log file because all logical files
> are in use'
> As all transactions completed ages ago, am puzzled as to why MSDE
> seems to want to hang on to such a big log file.
> How can I get MSDE to clear all the transactions, to the database, so
> can reduce the log file size?
perform a BACKUP LOG
(http://msdn.microsoft.com/library/de...ba-bz_35ww.asp
) in order to consolidates aged transactions and clear all virtual logs...
then shrink the log file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Works brilliantly well - Thanks Andrea
Kevin
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3og1vbF55dn8U1@.individual.net...
> hi Kevin,
> Kevin wrote:
> perform a BACKUP LOG
> (http://msdn.microsoft.com/library/de...ba-bz_35ww.asp
> ) in order to consolidates aged transactions and clear all virtual
> logs... then shrink the log file..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>