Read up on "pinned tables" in BOL ..

Read up on "pinned tables" in BOL. I've never used this feature before, but
according to the reference, DBCC PINTABLE can be used to mark a table so
that it's pages are not flushed from memory. However, I'm thinking that if a
table relatively small (only a few thousand records), the table is hit quite
often, and your sever has average or better memory (1 GB or more), then the
table is mostly held in the buffer cache automatically. The article also
provides a warning that this could fill the buffer cache and not leave
enough room for servicing other tables.
"BBM" <bbm@.bbmcompany.com> wrote in message
news:8C8DC765-3E23-403B-A206-E4ED44CB5117@.microsoft.com...
> Thanks to all the responders. You all had good input. Right now I'm
going
> to proceed just using regular SQL Server Tables/Indexes until I prove to
> myself that performance is an issue. I was hoping that there was some way
to
> tell SQL Server to keep a table in memory, but I guess there's not.
> Is there a way to tell SQL Server to keep it's cache at a certain size?
I'm
> familiar with DB2 and in DB2 you can do that by table. Essentially you
can
> set the cache size for a table so large that the entire table becomes
memory
> resident.
> I am intrigued by some of Aleksandar's responses. Could you elaborate on
> what you had in mind with "in memory" temporary tables?
> Thanks again for your responses.
> BBM
> "JT" wrote:
>
not
concurrency
lot, it
cause
isolation
in
that
one
ways.
during
the
going
part
I've
I
at
ServerFurther to PINTABLE. Note that this doesn NOT stop data being written
to disk. It simply means that data is not cleared from the buffer
cache. This is almost certainly undesirable as JT and Rick have noted,
especially on a system that isn't exclusively dedicated as a database
server.
David Portas
SQL Server MVP
--

read sql page data

can i look rows(data) from sql server data page
i can learn page information using dbcc page(...)
but i have to read data rows from page.
thanks
There are a number of print options for DBCC PAGE. Use the right one, and the data will be presented
in clear text. Experiment with print option 0, 1, 2 and 3.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks
|||Sabri,
Not sure what you're asking. Check out:
http://support.microsoft.com/kb/q83065/
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks
|||This article last applied to 6.5 but was updated in 2005 so I'm not sure if
it will with 7 or 2000. Might want to Google what DBCC PAGE or something
similar.
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks

read sql page data

can i look rows(data) from sql server data page
i can learn page information using dbcc page(...)
but i have to read data rows from page.
thanksThere are a number of print options for DBCC PAGE. Use the right one, and th
e data will be presented
in clear text. Experiment with print option 0, 1, 2 and 3.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks|||Sabri,
Not sure what you're asking. Check out:
http://support.microsoft.com/kb/q83065/
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks|||This article last applied to 6.5 but was updated in 2005 so I'm not sure if
it will with 7 or 2000. Might want to Google what DBCC PAGE or something
similar.
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks

read sql page data

can i look rows(data) from sql server data page
i can learn page information using dbcc page(...)
but i have to read data rows from page.
thanksThere are a number of print options for DBCC PAGE. Use the right one, and the data will be presented
in clear text. Experiment with print option 0, 1, 2 and 3.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks|||Sabri,
Not sure what you're asking. Check out:
http://support.microsoft.com/kb/q83065/
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks|||This article last applied to 6.5 but was updated in 2005 so I'm not sure if
it will with 7 or 2000. Might want to Google what DBCC PAGE or something
similar.
HTH
Jerry
"Sabri AKIN" <SabriAKIN@.discussions.microsoft.com> wrote in message
news:1B2B5D9B-4AE4-46D6-BD01-6CC9AB89A19C@.microsoft.com...
> can i look rows(data) from sql server data page
> i can learn page information using dbcc page(...)
> but i have to read data rows from page.
> thanks

Re Recorcer suspect database

Hi
One of my client give me a suspect database, but he doesn't have any backup
of this base.
When i try to recorver the data with the command : DBCC CHECKDB with
REPAIR_REBUILD (or REPAIR_ALLOW_DATA_LOSS)
(http://65.214.43.26/articles/18/view.asp?id=7381), i got an error :
Serveur : Msg 8946, Niveau 16, tat 12, Ligne 2
Erreur de table : La page d'allocation (1:1) a des valeurs d'en-tte de page
PFS_PAGE incorrecte. Le type est 0. Contrlez le type, et les ID d'objet et
de page pour cette page.
What can i do?
The Microsoft support is too expensive, and i want to find an other solution
for the futur, to recorver my data.
When i try MSSQLRecorvery, i recorver all data, and it seems to be the best
solution. What do you think about this software?
Best regards
Herv RESCOURIO
"Hari Prasad" <hari_prasad_k@.hotmail.com> a crit dans le message de news:
eulsf9bNFHA.1948@.TK2MSFTNGP14.phx.gbl...
> Hi,
> First identify the cause for the Suspect. If it is due to some file access
> issues you do not want to use any tools instead use the SQL Server
> commands
> to recover the database.
> Various Reasons for database going to suspect Status.
> 1. The MDF or LDF file for the database is not available during startup
> 2. LDF file missing or Corrupted
> 3. MDF file page allocation problems.
>
> 1. The first one can be resolved by executing "sp_resetstatus" stored
> procedure and restart SQL server services
> 2. Start the database in Emergency mode , Update the Status column in
> master..sysdatabases table for that database to 32768.
> After this database will be usable with out transaction log. AFter this
> create a new database and use DTS to transfer objects and data.
> 3. Third one is critical , try executing DBCC CHECKDB with REPAIR_REBUILD
> option. If the problem is not rectified
> wither restore from Backup or contact Microsoft support.
>
> How to set to Emergency Mode
> --X-
> Use emergency mode (also called bypass mode) to recover data when SQL
> Server marks a database suspect and the automatic recovery will fail.
> Setting the database status to emergency mode tells SQL Server to skip
> automatic recovery and lets you access the data. To get your data, use
> this script:
>
> Sp_configure "allow updates", 1
> go
> Reconfigure with override
> GO
> Update sysdatabases set status = 32768 where name = "BadDbName"
> go
> Sp_configure "allow updates", 0
> go
> Reconfigure with override
> GO
>
> Thanks
> Hari
> SQL Server MVP
>
> "Herv RESCOURIO" <hr@.segilog.com> wrote in message
> news:ufots5bNFHA.3296@.TK2MSFTNGP15.phx.gbl...
>
> One of my client give me a suspect database, but he doesn't have any
backup
> of this base.

> The Microsoft support is too expensive, and i want to find an other
solution
> for the futur, to recorver my data.
> When i try MSSQLRecorvery, i recorver all data, and it seems to be the
best
> solution. What do you think about this software?
Just do the backups.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com