Get Next Number: February 2012

Sunday, February 26, 2012

Free XML ODBC Drivers?

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the
Enterprise Manager.
I've tried successfully to import the XML using a DataDirect ODBC
driver. Unfortunately it's not free and its evalutation version
doesn't long too much...
So, I'd like to ask the community if somebody knows and ODBC driver
that could be used to import XML into SQL Server 2000 and that would
be free/open source.
Also, since it seems that XML Bulk Load can only be accessible through
the 'DTS Designer' I'd like to know if I'm wrong and where I can find
the info to make this useful feature work in the import/export wizard.
Greetings,
DavidI didn't think SQL XML Bulk Load had any UI at all. I thought it was just a
COM object. Well there is a COM object as I use this from VBScript daily.
This script happens to be inside an ActiveX Script Task, but that is just my
implementation.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David|||Dear David, I'm newbie too...and I'm improving in your same problem...
Can you indicate me the DataDirect driver you have downloaded and a little
example of DTS you have developped to import the xml file?
Best regards
Bruno Stefanutti
"David Grant" wrote:

> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
>|||See below.
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.com...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
This is incorrect. The SQLXML XML BulkLoad component is accessible as a COM
object.

> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
SQLXML is not an ODBC driver but internally uses an OLEDB provider.

> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
Check out http://msdn.microsoft.com/sqlxml.

> Greetings,
> David

Free XML ODBC Drivers?

Hi to everybody, I am a newbie who is trying to import data from and
XML file into a table in SQL Server 2000. I've reading all the MS
information about the SQLXML's 'XML Bulk Load' and it seems that this
feature can only be accesible through the 'DTS Designer' in the
Enterprise Manager.
I've tried successfully to import the XML using a DataDirect ODBC
driver. Unfortunately it's not free and its evalutation version
doesn't long too much...
So, I'd like to ask the community if somebody knows and ODBC driver
that could be used to import XML into SQL Server 2000 and that would
be free/open source.
Also, since it seems that XML Bulk Load can only be accessible through
the 'DTS Designer' I'd like to know if I'm wrong and where I can find
the info to make this useful feature work in the import/export wizard.
Greetings,
David
I didn't think SQL XML Bulk Load had any UI at all. I thought it was just a
COM object. Well there is a COM object as I use this from VBScript daily.
This script happens to be inside an ActiveX Script Task, but that is just my
implementation.
Darren Green
http://www.sqldts.com
http://www.sqlis.com
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.c om...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
|||Dear David, I'm newbie too...and I'm improving in your same problem...
Can you indicate me the DataDirect driver you have downloaded and a little
example of DTS you have developped to import the xml file?
Best regards
Bruno Stefanutti
"David Grant" wrote:

> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
> Greetings,
> David
>
|||See below.
"David Grant" <icebold54@.hotmail.com> wrote in message
news:18503386.0502280504.74c7ddf3@.posting.google.c om...
> Hi to everybody, I am a newbie who is trying to import data from and
> XML file into a table in SQL Server 2000. I've reading all the MS
> information about the SQLXML's 'XML Bulk Load' and it seems that this
> feature can only be accesible through the 'DTS Designer' in the
> Enterprise Manager.
This is incorrect. The SQLXML XML BulkLoad component is accessible as a COM
object.

> I've tried successfully to import the XML using a DataDirect ODBC
> driver. Unfortunately it's not free and its evalutation version
> doesn't long too much...
> So, I'd like to ask the community if somebody knows and ODBC driver
> that could be used to import XML into SQL Server 2000 and that would
> be free/open source.
SQLXML is not an ODBC driver but internally uses an OLEDB provider.

> Also, since it seems that XML Bulk Load can only be accessible through
> the 'DTS Designer' I'd like to know if I'm wrong and where I can find
> the info to make this useful feature work in the import/export wizard.
Check out http://msdn.microsoft.com/sqlxml.

> Greetings,
> David

Free up the transaction log

Hi ,
When full db is backed up (using maintenance plan) , does transaction
log get shrunk (inactive transactions are dropped from log) . Also does this
space get released to OS .
Can you pl. let me know answer for same question , when log is backed up
explicity (using backup log without using truncate_only option ) .
What could be the reasons , why my log is not getting shrunk after DB and
log backup . What are the other options available apart from using
truncate_only option and dbcc shrinkfile .
Thanks,
PrabhuShrinking is NOT part of a backup, log or db. You must use either DBCC
SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
considerations
http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues
http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
2000 with DBCC SHRINKFILE
http://www.support.microsoft.com/?id=873235 How to stop the log file from
growing
http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
http://www.support.microsoft.com/?id=307487 Shrinking TempDB
--
Andrew J. Kelly SQL MVP
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
> Hi ,
> When full db is backed up (using maintenance plan) , does transaction
> log get shrunk (inactive transactions are dropped from log) . Also does
> this
> space get released to OS .
> Can you pl. let me know answer for same question , when log is backed up
> explicity (using backup log without using truncate_only option ) .
> What could be the reasons , why my log is not getting shrunk after DB and
> log backup . What are the other options available apart from using
> truncate_only option and dbcc shrinkfile .
> Thanks,
> Prabhu|||Thanks for your reply Kelly .
I understand shrinking the physical file(s) is not part of backup .
Truncation does not reduce the size of a physical log file, it reduces the
size of the logical log file
But I have 2 weird situations .
1. My tempdb log just grows out of control . Only way we could reuse the
space is after explicitly using backup log with truncate option and dbcc
shrinkfile .
But , Log truncation should occur ,every time a checkpoint is processed,
provided the database is using the simple recovery model (tempdb is in
recovery model).
2. Other user DBs log files also grow , they are in full or Bulk_Logged
recovery model . We have daily fulldb maintenance plan to take only full DB
backup . Does it truncate the log ? But looks like unused space in log files
are not being reused and log files are just extending .
I have also used backup log command (without truncate_only) but still unused
space is not reused but log file grows .( log truncation should occur after
BACKUP LOG statement , right . )
Thanks,
Prabhu
"Andrew J. Kelly" wrote:
> Shrinking is NOT part of a backup, log or db. You must use either DBCC
> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
> considerations
> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File issues
> http://www.support.microsoft.com/?id=317375 Log File Grows too big
> http://www.support.microsoft.com/?id=110139 Log file filling up
> http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
> and AutoShrink
> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
> 2000 with DBCC SHRINKFILE
> http://www.support.microsoft.com/?id=873235 How to stop the log file from
> growing
> http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
> --
> Andrew J. Kelly SQL MVP
>
> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
> > Hi ,
> > When full db is backed up (using maintenance plan) , does transaction
> > log get shrunk (inactive transactions are dropped from log) . Also does
> > this
> > space get released to OS .
> > Can you pl. let me know answer for same question , when log is backed up
> > explicity (using backup log without using truncate_only option ) .
> > What could be the reasons , why my log is not getting shrunk after DB and
> > log backup . What are the other options available apart from using
> > truncate_only option and dbcc shrinkfile .
> >
> > Thanks,
> > Prabhu
>
>|||Do you have the latest service pack? I have heard of other postings in
which the tempdb log grows but I can't find any KB on it. I think it was
fixed with a service pack. This KB might be helpful:
http://support.microsoft.com/Default.aspx?id=110139
As for # 2 if you are in Full or BulkLogged recovery mode you must do
regular log backups otherwise the log will continue to grow. A full backup
does not truncate the log only a proper Log backup will do that as long as
there are no open transactions.
--
Andrew J. Kelly SQL MVP
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:8B5506DD-860D-4851-AAE6-AEB4005D753F@.microsoft.com...
> Thanks for your reply Kelly .
> I understand shrinking the physical file(s) is not part of backup .
> Truncation does not reduce the size of a physical log file, it reduces the
> size of the logical log file
> But I have 2 weird situations .
> 1. My tempdb log just grows out of control . Only way we could reuse the
> space is after explicitly using backup log with truncate option and dbcc
> shrinkfile .
> But , Log truncation should occur ,every time a checkpoint is processed,
> provided the database is using the simple recovery model (tempdb is in
> recovery model).
> 2. Other user DBs log files also grow , they are in full or Bulk_Logged
> recovery model . We have daily fulldb maintenance plan to take only full
> DB
> backup . Does it truncate the log ? But looks like unused space in log
> files
> are not being reused and log files are just extending .
> I have also used backup log command (without truncate_only) but still
> unused
> space is not reused but log file grows .( log truncation should occur
> after
> BACKUP LOG statement , right . )
> Thanks,
> Prabhu
> "Andrew J. Kelly" wrote:
>> Shrinking is NOT part of a backup, log or db. You must use either DBCC
>> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
>> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
>> considerations
>> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File
>> issues
>> http://www.support.microsoft.com/?id=317375 Log File Grows too big
>> http://www.support.microsoft.com/?id=110139 Log file filling up
>> http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
>> and AutoShrink
>> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
>> 2000 with DBCC SHRINKFILE
>> http://www.support.microsoft.com/?id=873235 How to stop the log file
>> from
>> growing
>> http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
>> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
>> > Hi ,
>> > When full db is backed up (using maintenance plan) , does
>> > transaction
>> > log get shrunk (inactive transactions are dropped from log) . Also
>> > does
>> > this
>> > space get released to OS .
>> > Can you pl. let me know answer for same question , when log is backed
>> > up
>> > explicity (using backup log without using truncate_only option ) .
>> > What could be the reasons , why my log is not getting shrunk after DB
>> > and
>> > log backup . What are the other options available apart from using
>> > truncate_only option and dbcc shrinkfile .
>> >
>> > Thanks,
>> > Prabhu
>>|||Hi Andrew ,
1. I have SP4 ( 8.00.2040 ) .
2. If DB is in simple recovery mode , log is getting truncated (but space
not released to OS , as expected) but for other recovery models backup log
command sometimes truncates log and sometimes it won't .
Thanks,
Prabhu
"Andrew J. Kelly" wrote:
> Do you have the latest service pack? I have heard of other postings in
> which the tempdb log grows but I can't find any KB on it. I think it was
> fixed with a service pack. This KB might be helpful:
> http://support.microsoft.com/Default.aspx?id=110139
> As for # 2 if you are in Full or BulkLogged recovery mode you must do
> regular log backups otherwise the log will continue to grow. A full backup
> does not truncate the log only a proper Log backup will do that as long as
> there are no open transactions.
> --
> Andrew J. Kelly SQL MVP
>
> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> news:8B5506DD-860D-4851-AAE6-AEB4005D753F@.microsoft.com...
> > Thanks for your reply Kelly .
> >
> > I understand shrinking the physical file(s) is not part of backup .
> > Truncation does not reduce the size of a physical log file, it reduces the
> > size of the logical log file
> >
> > But I have 2 weird situations .
> >
> > 1. My tempdb log just grows out of control . Only way we could reuse the
> > space is after explicitly using backup log with truncate option and dbcc
> > shrinkfile .
> > But , Log truncation should occur ,every time a checkpoint is processed,
> > provided the database is using the simple recovery model (tempdb is in
> > recovery model).
> > 2. Other user DBs log files also grow , they are in full or Bulk_Logged
> > recovery model . We have daily fulldb maintenance plan to take only full
> > DB
> > backup . Does it truncate the log ? But looks like unused space in log
> > files
> > are not being reused and log files are just extending .
> > I have also used backup log command (without truncate_only) but still
> > unused
> > space is not reused but log file grows .( log truncation should occur
> > after
> > BACKUP LOG statement , right . )
> >
> > Thanks,
> > Prabhu
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Shrinking is NOT part of a backup, log or db. You must use either DBCC
> >> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
> >>
> >> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
> >> considerations
> >> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File
> >> issues
> >> http://www.support.microsoft.com/?id=317375 Log File Grows too big
> >> http://www.support.microsoft.com/?id=110139 Log file filling up
> >> http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
> >> and AutoShrink
> >> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL Server
> >> 2000 with DBCC SHRINKFILE
> >> http://www.support.microsoft.com/?id=873235 How to stop the log file
> >> from
> >> growing
> >> http://www.support.microsoft.com/?id=305635 Timeout while DB expanding
> >> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> >> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
> >> > Hi ,
> >> > When full db is backed up (using maintenance plan) , does
> >> > transaction
> >> > log get shrunk (inactive transactions are dropped from log) . Also
> >> > does
> >> > this
> >> > space get released to OS .
> >> > Can you pl. let me know answer for same question , when log is backed
> >> > up
> >> > explicity (using backup log without using truncate_only option ) .
> >> > What could be the reasons , why my log is not getting shrunk after DB
> >> > and
> >> > log backup . What are the other options available apart from using
> >> > truncate_only option and dbcc shrinkfile .
> >> >
> >> > Thanks,
> >> > Prabhu
> >>
> >>
> >>
>
>|||If there are any long running open transactions it can not truncate that
portion of the log.
--
Andrew J. Kelly SQL MVP
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:14032F27-857D-4F34-9864-00A4D9514E67@.microsoft.com...
> Hi Andrew ,
> 1. I have SP4 ( 8.00.2040 ) .
> 2. If DB is in simple recovery mode , log is getting truncated (but space
> not released to OS , as expected) but for other recovery models backup log
> command sometimes truncates log and sometimes it won't .
> Thanks,
> Prabhu
>
> "Andrew J. Kelly" wrote:
>> Do you have the latest service pack? I have heard of other postings in
>> which the tempdb log grows but I can't find any KB on it. I think it was
>> fixed with a service pack. This KB might be helpful:
>> http://support.microsoft.com/Default.aspx?id=110139
>> As for # 2 if you are in Full or BulkLogged recovery mode you must do
>> regular log backups otherwise the log will continue to grow. A full
>> backup
>> does not truncate the log only a proper Log backup will do that as long
>> as
>> there are no open transactions.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> news:8B5506DD-860D-4851-AAE6-AEB4005D753F@.microsoft.com...
>> > Thanks for your reply Kelly .
>> >
>> > I understand shrinking the physical file(s) is not part of backup .
>> > Truncation does not reduce the size of a physical log file, it reduces
>> > the
>> > size of the logical log file
>> >
>> > But I have 2 weird situations .
>> >
>> > 1. My tempdb log just grows out of control . Only way we could reuse
>> > the
>> > space is after explicitly using backup log with truncate option and
>> > dbcc
>> > shrinkfile .
>> > But , Log truncation should occur ,every time a checkpoint is
>> > processed,
>> > provided the database is using the simple recovery model (tempdb is in
>> > recovery model).
>> > 2. Other user DBs log files also grow , they are in full or
>> > Bulk_Logged
>> > recovery model . We have daily fulldb maintenance plan to take only
>> > full
>> > DB
>> > backup . Does it truncate the log ? But looks like unused space in log
>> > files
>> > are not being reused and log files are just extending .
>> > I have also used backup log command (without truncate_only) but still
>> > unused
>> > space is not reused but log file grows .( log truncation should occur
>> > after
>> > BACKUP LOG statement , right . )
>> >
>> > Thanks,
>> > Prabhu
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Shrinking is NOT part of a backup, log or db. You must use either
>> >> DBCC
>> >> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
>> >>
>> >> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
>> >> considerations
>> >> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File
>> >> issues
>> >> http://www.support.microsoft.com/?id=317375 Log File Grows too big
>> >> http://www.support.microsoft.com/?id=110139 Log file filling up
>> >> http://www.support.microsoft.com/?id=315512 Considerations for
>> >> Autogrow
>> >> and AutoShrink
>> >> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL
>> >> Server
>> >> 2000 with DBCC SHRINKFILE
>> >> http://www.support.microsoft.com/?id=873235 How to stop the log file
>> >> from
>> >> growing
>> >> http://www.support.microsoft.com/?id=305635 Timeout while DB
>> >> expanding
>> >> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> >> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
>> >> > Hi ,
>> >> > When full db is backed up (using maintenance plan) , does
>> >> > transaction
>> >> > log get shrunk (inactive transactions are dropped from log) . Also
>> >> > does
>> >> > this
>> >> > space get released to OS .
>> >> > Can you pl. let me know answer for same question , when log is
>> >> > backed
>> >> > up
>> >> > explicity (using backup log without using truncate_only option ) .
>> >> > What could be the reasons , why my log is not getting shrunk after
>> >> > DB
>> >> > and
>> >> > log backup . What are the other options available apart from using
>> >> > truncate_only option and dbcc shrinkfile .
>> >> >
>> >> > Thanks,
>> >> > Prabhu
>> >>
>> >>
>> >>
>>|||Andrew ,
I have SP4 but still have issues with tempdb log (issue #1) , as I described
below . Can you pl. suggest me any solution . I also read from MS support
site ,using dbcc shrinkdatabase (and/or dbcc shrinkfile) could currept
tempdb . Right .
Pl. let me know .
--Prabhu
"Andrew J. Kelly" wrote:
> If there are any long running open transactions it can not truncate that
> portion of the log.
> --
> Andrew J. Kelly SQL MVP
>
> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> news:14032F27-857D-4F34-9864-00A4D9514E67@.microsoft.com...
> > Hi Andrew ,
> >
> > 1. I have SP4 ( 8.00.2040 ) .
> > 2. If DB is in simple recovery mode , log is getting truncated (but space
> > not released to OS , as expected) but for other recovery models backup log
> > command sometimes truncates log and sometimes it won't .
> >
> > Thanks,
> > Prabhu
> >
> >
> > "Andrew J. Kelly" wrote:
> >
> >> Do you have the latest service pack? I have heard of other postings in
> >> which the tempdb log grows but I can't find any KB on it. I think it was
> >> fixed with a service pack. This KB might be helpful:
> >>
> >> http://support.microsoft.com/Default.aspx?id=110139
> >>
> >> As for # 2 if you are in Full or BulkLogged recovery mode you must do
> >> regular log backups otherwise the log will continue to grow. A full
> >> backup
> >> does not truncate the log only a proper Log backup will do that as long
> >> as
> >> there are no open transactions.
> >>
> >> --
> >> Andrew J. Kelly SQL MVP
> >>
> >>
> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> >> news:8B5506DD-860D-4851-AAE6-AEB4005D753F@.microsoft.com...
> >> > Thanks for your reply Kelly .
> >> >
> >> > I understand shrinking the physical file(s) is not part of backup .
> >> > Truncation does not reduce the size of a physical log file, it reduces
> >> > the
> >> > size of the logical log file
> >> >
> >> > But I have 2 weird situations .
> >> >
> >> > 1. My tempdb log just grows out of control . Only way we could reuse
> >> > the
> >> > space is after explicitly using backup log with truncate option and
> >> > dbcc
> >> > shrinkfile .
> >> > But , Log truncation should occur ,every time a checkpoint is
> >> > processed,
> >> > provided the database is using the simple recovery model (tempdb is in
> >> > recovery model).
> >> > 2. Other user DBs log files also grow , they are in full or
> >> > Bulk_Logged
> >> > recovery model . We have daily fulldb maintenance plan to take only
> >> > full
> >> > DB
> >> > backup . Does it truncate the log ? But looks like unused space in log
> >> > files
> >> > are not being reused and log files are just extending .
> >> > I have also used backup log command (without truncate_only) but still
> >> > unused
> >> > space is not reused but log file grows .( log truncation should occur
> >> > after
> >> > BACKUP LOG statement , right . )
> >> >
> >> > Thanks,
> >> > Prabhu
> >> >
> >> > "Andrew J. Kelly" wrote:
> >> >
> >> >> Shrinking is NOT part of a backup, log or db. You must use either
> >> >> DBCC
> >> >> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
> >> >>
> >> >> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
> >> >> considerations
> >> >> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File
> >> >> issues
> >> >> http://www.support.microsoft.com/?id=317375 Log File Grows too big
> >> >> http://www.support.microsoft.com/?id=110139 Log file filling up
> >> >> http://www.support.microsoft.com/?id=315512 Considerations for
> >> >> Autogrow
> >> >> and AutoShrink
> >> >> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL
> >> >> Server
> >> >> 2000 with DBCC SHRINKFILE
> >> >> http://www.support.microsoft.com/?id=873235 How to stop the log file
> >> >> from
> >> >> growing
> >> >> http://www.support.microsoft.com/?id=305635 Timeout while DB
> >> >> expanding
> >> >> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
> >> >>
> >> >> --
> >> >> Andrew J. Kelly SQL MVP
> >> >>
> >> >>
> >> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
> >> >> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
> >> >> > Hi ,
> >> >> > When full db is backed up (using maintenance plan) , does
> >> >> > transaction
> >> >> > log get shrunk (inactive transactions are dropped from log) . Also
> >> >> > does
> >> >> > this
> >> >> > space get released to OS .
> >> >> > Can you pl. let me know answer for same question , when log is
> >> >> > backed
> >> >> > up
> >> >> > explicity (using backup log without using truncate_only option ) .
> >> >> > What could be the reasons , why my log is not getting shrunk after
> >> >> > DB
> >> >> > and
> >> >> > log backup . What are the other options available apart from using
> >> >> > truncate_only option and dbcc shrinkfile .
> >> >> >
> >> >> > Thanks,
> >> >> > Prabhu
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||As I stated if you have long running open transactions in the db the log
file may not be able to be truncated. Try running DBCC OPENTRAN() in the
affected db's.
--
Andrew J. Kelly SQL MVP
"Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
news:B04001DD-4233-4E2B-B62C-F4E6C960D77A@.microsoft.com...
> Andrew ,
> I have SP4 but still have issues with tempdb log (issue #1) , as I
> described
> below . Can you pl. suggest me any solution . I also read from MS support
> site ,using dbcc shrinkdatabase (and/or dbcc shrinkfile) could currept
> tempdb . Right .
> Pl. let me know .
> --Prabhu
> "Andrew J. Kelly" wrote:
>> If there are any long running open transactions it can not truncate that
>> portion of the log.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> news:14032F27-857D-4F34-9864-00A4D9514E67@.microsoft.com...
>> > Hi Andrew ,
>> >
>> > 1. I have SP4 ( 8.00.2040 ) .
>> > 2. If DB is in simple recovery mode , log is getting truncated (but
>> > space
>> > not released to OS , as expected) but for other recovery models backup
>> > log
>> > command sometimes truncates log and sometimes it won't .
>> >
>> > Thanks,
>> > Prabhu
>> >
>> >
>> > "Andrew J. Kelly" wrote:
>> >
>> >> Do you have the latest service pack? I have heard of other postings
>> >> in
>> >> which the tempdb log grows but I can't find any KB on it. I think it
>> >> was
>> >> fixed with a service pack. This KB might be helpful:
>> >>
>> >> http://support.microsoft.com/Default.aspx?id=110139
>> >>
>> >> As for # 2 if you are in Full or BulkLogged recovery mode you must do
>> >> regular log backups otherwise the log will continue to grow. A full
>> >> backup
>> >> does not truncate the log only a proper Log backup will do that as
>> >> long
>> >> as
>> >> there are no open transactions.
>> >>
>> >> --
>> >> Andrew J. Kelly SQL MVP
>> >>
>> >>
>> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> >> news:8B5506DD-860D-4851-AAE6-AEB4005D753F@.microsoft.com...
>> >> > Thanks for your reply Kelly .
>> >> >
>> >> > I understand shrinking the physical file(s) is not part of backup .
>> >> > Truncation does not reduce the size of a physical log file, it
>> >> > reduces
>> >> > the
>> >> > size of the logical log file
>> >> >
>> >> > But I have 2 weird situations .
>> >> >
>> >> > 1. My tempdb log just grows out of control . Only way we could
>> >> > reuse
>> >> > the
>> >> > space is after explicitly using backup log with truncate option and
>> >> > dbcc
>> >> > shrinkfile .
>> >> > But , Log truncation should occur ,every time a checkpoint is
>> >> > processed,
>> >> > provided the database is using the simple recovery model (tempdb is
>> >> > in
>> >> > recovery model).
>> >> > 2. Other user DBs log files also grow , they are in full or
>> >> > Bulk_Logged
>> >> > recovery model . We have daily fulldb maintenance plan to take only
>> >> > full
>> >> > DB
>> >> > backup . Does it truncate the log ? But looks like unused space in
>> >> > log
>> >> > files
>> >> > are not being reused and log files are just extending .
>> >> > I have also used backup log command (without truncate_only) but
>> >> > still
>> >> > unused
>> >> > space is not reused but log file grows .( log truncation should
>> >> > occur
>> >> > after
>> >> > BACKUP LOG statement , right . )
>> >> >
>> >> > Thanks,
>> >> > Prabhu
>> >> >
>> >> > "Andrew J. Kelly" wrote:
>> >> >
>> >> >> Shrinking is NOT part of a backup, log or db. You must use either
>> >> >> DBCC
>> >> >> SHRINKDATABSE or SHRINKFILE to do that. Have a look at these:
>> >> >>
>> >> >> http://www.karaszi.com/SQLServer/info_dont_shrink.asp Shrinking
>> >> >> considerations
>> >> >> http://www.nigelrivett.net/TransactionLogFileGrows_1.html Log File
>> >> >> issues
>> >> >> http://www.support.microsoft.com/?id=317375 Log File Grows too
>> >> >> big
>> >> >> http://www.support.microsoft.com/?id=110139 Log file filling up
>> >> >> http://www.support.microsoft.com/?id=315512 Considerations for
>> >> >> Autogrow
>> >> >> and AutoShrink
>> >> >> http://www.support.microsoft.com/?id=272318 Shrinking Log in SQL
>> >> >> Server
>> >> >> 2000 with DBCC SHRINKFILE
>> >> >> http://www.support.microsoft.com/?id=873235 How to stop the log
>> >> >> file
>> >> >> from
>> >> >> growing
>> >> >> http://www.support.microsoft.com/?id=305635 Timeout while DB
>> >> >> expanding
>> >> >> http://www.support.microsoft.com/?id=307487 Shrinking TempDB
>> >> >>
>> >> >> --
>> >> >> Andrew J. Kelly SQL MVP
>> >> >>
>> >> >>
>> >> >> "Prabhu" <Prabhu@.discussions.microsoft.com> wrote in message
>> >> >> news:0CC4883D-7A2F-4701-94CC-4521F3B81A61@.microsoft.com...
>> >> >> > Hi ,
>> >> >> > When full db is backed up (using maintenance plan) , does
>> >> >> > transaction
>> >> >> > log get shrunk (inactive transactions are dropped from log) .
>> >> >> > Also
>> >> >> > does
>> >> >> > this
>> >> >> > space get released to OS .
>> >> >> > Can you pl. let me know answer for same question , when log is
>> >> >> > backed
>> >> >> > up
>> >> >> > explicity (using backup log without using truncate_only option )
>> >> >> > .
>> >> >> > What could be the reasons , why my log is not getting shrunk
>> >> >> > after
>> >> >> > DB
>> >> >> > and
>> >> >> > log backup . What are the other options available apart from
>> >> >> > using
>> >> >> > truncate_only option and dbcc shrinkfile .
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Prabhu
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>

Free up the transaction log

Free unused space in database

Hello,
I need to free unused space in one database, but neither
the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
commands shows the desired results.
Inside my database i've two tables:
t1 - is the original table
t2 - was created with a select into...from t1
when i use the sp_spaceused in these tables:
t1 unused space = 1822968 KB
t2 unused space = 39992 KB
for me its obvious that when the table t2 was created the
unused space(physical space) its not allocated in the new
table.
The question is that i want to free unused space but cant
see results w/ dbcc shrink...
Best regards
Did you try
DBCC SHRINKDATABASE(DBName, 'TruncateOnly')
However, be very aware that if your database grew to this size once, it will
likely do so again... so don't expect this to be permanent disk space
relief.
http://www.aspfaq.com/
(Reverse address to reply.)
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>
|||try to update statistics. Look in BOL.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>
|||Perhaps the sp_spaceused results are inaccurate? Try running DBCC
UPDATEUSAGE to get the latest stats.
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>
|||Perhaps some index is occupying space - try reindexing (DBCC DBREINDEX).
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>
|||Or do a showcontig to get more information on any kind of fragmentation.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Free unused space in database

Hello,
I need to free unused space in one database, but neither
the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
commands shows the desired results.
Inside my database i've two tables:
t1 - is the original table
t2 - was created with a select into...from t1
when i use the sp_spaceused in these tables:
t1 unused space = 1822968 KB
t2 unused space = 39992 KB
for me its obvious that when the table t2 was created the
unused space(physical space) its not allocated in the new
table.
The question is that i want to free unused space but cant
see results w/ dbcc shrink...
Best regardsDid you try
DBCC SHRINKDATABASE(DBName, 'TruncateOnly')
However, be very aware that if your database grew to this size once, it will
likely do so again... so don't expect this to be permanent disk space
relief.
http://www.aspfaq.com/
(Reverse address to reply.)
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx
.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||try to update statistics. Look in BOL.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx
.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Perhaps the sp_spaceused results are inaccurate? Try running DBCC
UPDATEUSAGE to get the latest stats.
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx
.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Perhaps some index is occupying space - try reindexing (DBCC DBREINDEX).
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx
.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Or do a showcontig to get more information on any kind of fragmentation.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Free unused space in database

Hello,
I need to free unused space in one database, but neither
the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
commands shows the desired results.
Inside my database i've two tables:
t1 - is the original table
t2 - was created with a select into...from t1
when i use the sp_spaceused in these tables:
t1 unused space = 1822968 KB
t2 unused space = 39992 KB
for me its obvious that when the table t2 was created the
unused space(physical space) its not allocated in the new
table.
The question is that i want to free unused space but cant
see results w/ dbcc shrink...
Best regardsDid you try
DBCC SHRINKDATABASE(DBName, 'TruncateOnly')
However, be very aware that if your database grew to this size once, it will
likely do so again... so don't expect this to be permanent disk space
relief.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||try to update statistics. Look in BOL.
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Perhaps the sp_spaceused results are inaccurate? Try running DBCC
UPDATEUSAGE to get the latest stats.
Peter Yeoh
http://www.yohz.com
Need smaller backups? Try MiniSQLBackup
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Perhaps some index is occupying space - try reindexing (DBCC DBREINDEX).
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5d201c44e43$fd195e10$a101280a@.phx.gbl...
> Hello,
> I need to free unused space in one database, but neither
> the "dbcc shrinkdatabase" nor the "dbcc shrinkfile"
> commands shows the desired results.
> Inside my database i've two tables:
> t1 - is the original table
> t2 - was created with a select into...from t1
> when i use the sp_spaceused in these tables:
> t1 unused space = 1822968 KB
> t2 unused space = 39992 KB
> for me its obvious that when the table t2 was created the
> unused space(physical space) its not allocated in the new
> table.
> The question is that i want to free unused space but cant
> see results w/ dbcc shrink...
> Best regards
>|||Or do a showcontig to get more information on any kind of fragmentation.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Free Tutorial Source with from A to Z examples

I read alot of theoretical explanation of Notification Services.
I need a source for examples that explain Notification Services from A to Z.

Thank you.
Bishoy

Hi Bishoy -

Here's a copy/paste from my reply to your newsgroup posting.

I'd defiinitely suggest going through the walkthrough example included
in BOL as a good starting point. Additionally, examining the other
sample apps included in would be beneficial.

Beyond that, Shyam Pather has a book on the subject that is really
quite comprehensive. I've got one out there as well; mine is designed
to get you up to speed on SQLNS very quickly.

As for other resources, I haven't found anything specifically devoted
to SQLNS, only a few article here and there on the subject - some on
MSND, some on blogs, some on community sites.

I regularly blog on the topic (www.sqlns.com) and occasionally write
articles for SQL Server Central and Red-Gate's Simple-Talk sites.

BTW - here's an article that was adapted from on of the chapters of my
book.

http://sqlns.blogspot.com/2005/11/sqlns-architecture-article-on.html

Hope this helps.

free transaction log reader

There have been deleted several records from a table and i want to know who did it. Is there a free transactionlog reader to find out?
MarcelOriginally posted by swissis
There have been deleted several records from a table and i want to know who did it. Is there a free transactionlog reader to find out?

Marcel

try log explorer by Lumigent:
http://www.lumigent.com/products/le_sql/le_sql.htm|||I did download that one but it isn't free and the trial version only works on the pubs and northwind database.
Is there not another way to read or query the transactionlog?

free tools for creating sql script with records?

is there some freeware tools for that?
thanks!
On Thu, 9 Dec 2004 11:13:35 +0100, green_eye wrote:

>is there some freeware tools for that?
Hi green_eye,
http://vyaskn.tripod.com/code.htm#inserts
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Innovartis do a free data and schema scripter
http://www.innovartis.co.uk/Evaluation.aspx
"green_eye" wrote:

> is there some freeware tools for that?
> thanks!
>
>

free tools for creating sql script with records?

is there some freeware tools for that'
thanks!On Thu, 9 Dec 2004 11:13:35 +0100, green_eye wrote:
>is there some freeware tools for that'
Hi green_eye,
http://vyaskn.tripod.com/code.htm#inserts
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Innovartis do a free data and schema scripter
http://www.innovartis.co.uk/Evaluation.aspx
"green_eye" wrote:
> is there some freeware tools for that'
> thanks!
>
>

Free tool to compare two databases

Hi,
Is there any free tool that compares the schema and the data of two SQL
Server databases ?
Thank youhttp://www.aspfaq.com/2209
But, FWIW, the cost of a refined tool will more than pay for itself in the
long run.
"Mark" <sauvemark@.yahoo.com> wrote in message
news:%23ppS1$KOGHA.3276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any free tool that compares the schema and the data of two SQL
> Server databases ?
> Thank you
>|||Also refer
http://www.downloaddatabase.com/dat...are/sqldiff.htm
http://www.sql-server-performance.c...mparison_sp.asp
Madhivanan|||You should be scripting each object seperately and managing them in a
version control system. Visual Source Safe, has a feature to compare scripts
between two projects (ex: FoodMart_DEV vs. FoodMart_PROD) and will visually
diplay the differences between the scripts. There is also the added benefit
of retaining previous versions of each script. Another free tool called
WinMerge that can visually compare differences between scripts and other
source files.
"Mark" <sauvemark@.yahoo.com> wrote in message
news:%23ppS1$KOGHA.3276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Is there any free tool that compares the schema and the data of two SQL
> Server databases ?
> Thank you
>|||You can use SchemaCrawler, a free open-source tool that can compare
schemas as well as data. SchemaCrawler is a command-line tool to output
your database schema and data in a readable form. The output is
designed to be diff-ed with previous versions of your database schema.
http://schemacrawler.sourceforge.net/
Sualeh Fatehi.

Free Tool for MSSQL Admin

I'm looking for a free tool akin to SQL Server Enterprise Admin that i can use to administrate some of my databases on remote hosting from my home PC... any recommendations?

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Use the free Sql Management Studio you will be able to connect other database. Its free !!!

|||

hi,

check this

http://www.codeplex.com/SqlWebAdmin

Free text search for 2 million records

Hi

I have a new client with an existing system that has just over 2 million business listings in one table. Each business listing is associated with one business category.

* Company Table (around 20 fields):

companyID
companyName
categoryID
state
postCode
etc.

* Category Table (5 fields)

categoryID
categoryName
etc.

We are using MSSQL 2005 Express Edition with Advanced Services

A free text search needs to be performed on the companyName and categoryName limited by region (state and or postcode).

1) What kind of response times should I expect for the free text search (I have not used the free text search before)

2) How should I index the companyName and categoryName so they are both used in a joined query? i.e. Do I just configure the free text search index on each field separately and it should work?

Any suggestions appreciated.

Best Regards

Kevan1) Impossible to tell. It highly depends on the memory, disk solution, allocated memory to SQL Server, processor, operating system configurations and more.

2) Indexing the keys used in a join (that is: used in the on clause of the join) may improve performance.|||Thanks for that.

1)

Yes, that makes sense. I was really after a very general idea of other peoples experience when dealing with free text search on a couple of million records. What sort of average response times have other people achieved with simple free text searches on this number of records. We would most likely be using a low level hardware solution on a hosted server.

2)

Thanks

Free Text Search across multiple tables

Anyone have any recommendations on how to bring together a search across multiple tables? Like I'd love to do a search where i searched for the product name, company name or tag all in one query (though all are in separate tables)... is that possible? Individually, it's easy, but combined it's very hard.You can join the tables and use like, but I should probably first take a look at the Free text search engine (but it depends on how the table looks like, how the search will be formed in the future, how much data the table has etc), take a look at the following site:http://www.databasejournal.com/features/mssql/article.php/3441981|||

actually, that's just it... i'm using the full text search engine, which generates catalogs per table. I'm not sure how to bring the table results together. so, for example:

Declare @.search nvarchar(100)select @.search ='apple'SELECT TOP 5 * FROM brands INNER JOIN (SELECT * from freetexttable (Brands,*,@.Search) ORDER BY [RANK] DESC) AS search ON brands.brandid = search.[KEY]SELECT TOP 5 * FROM products INNER JOIN (SELECT * from freetexttable (products,*,@.Search) ORDER BY [RANK] DESC) AS search ON products.productid = search.[KEY]SELECT TOP 5 * FROM companies INNER JOIN (SELECT * from freetexttable (companies,*,@.Search) ORDER BY [RANK] DESC) AS search ON companies.companyid = search.[KEY]

 How do i bring these tables together and order them according to the closest match across the tables?

|||

Hey,

Did you have any luck with this? I'm using SQL 2005, and I've done a bit of testing, but haven't got the expected results!

Thanks

free text search

does anyone have code that shows how to separate individual words from a sentence.

e.g. i have a list of questions and answers in my database and have the following query for it:

SELECT question, Answer
FROM QuestionsAnswer
WHERE FREETEXT(Question, 'i want to travel around the world and learn about cooking')

so i want to extend the above query so that takes each key word (travel, cooking, learn) to find out how frequently that particular word appears in the question (for ranking purposes).

I know freetexttable does rank results, but they don't seem accurate enough for what i need to do.

HELP!!!i've just been told that freetext does this anyways...

=D|||have u tried search on the web|||You will need:

* A one column list (table) with all unimportant words. For that purpose I used a 20-year-old Commodore 64 text adventure interpreter list.

* A two column list (table) with the important words and the number of total occurences for each word.

You parse your text with space, comma, etc as word seperators and run each word against the first list. If it is not their you search it in the second list. If it is their you increment the occurence counter. If it is not their you add it with an occurence counter=1.

Check your second list from time to time in order to see if you can transfer a word from list 2 to list 1.

Easy, isn't it ?

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
Confused but battling on
"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?

> Can anyone offer any help?
> --
> Confused but battling on
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text search
Confused but battling on
"Greg D. Moore (Strider)" wrote:

> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>
>

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
--
Confused but battling on"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?
> Can anyone offer any help?
> --
> Confused but battling on
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text search
--
Confused but battling on
"Greg D. Moore (Strider)" wrote:
> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> > We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> > database from one to the other. The free text search runs on the original
> > server and produces results but on the new server it runs but produces a
> > nil
> > return.
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> >
> > Can anyone offer any help?
> >
> > --
> > Confused but battling on
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>
>

Free Text Search

We have two SQL Server 2000 servers with SP4 loaded. We have copied a
database from one to the other. The free text search runs on the original
server and produces results but on the new server it runs but produces a nil
return.
Can anyone offer any help?
Confused but battling on"Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> We have two SQL Server 2000 servers with SP4 loaded. We have copied a
> database from one to the other. The free text search runs on the original
> server and produces results but on the new server it runs but produces a
> nil
> return.
Free text?
I assume you mean FULL TEXT?
Did you copy the Full-text indices to the same place?
Did you enable full-text on the new database?
How was the data moved?

> Can anyone offer any help?
> --
> Confused but battling on
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Sorry I did mean full text search. We have tried to re create the indices
and the search but it still returns a nil result. The full text search
service is running.
How do you enable full text search on a database?
The database was moved by backing up to a device, then copying the device to
the new location and restoring it (changing the file locations etc).
Eeverything else in the database works fine; it is just this full text searc
h
--
Confused but battling on
"Greg D. Moore (Strider)" wrote:

> "Madame Artois" <MadameArtois@.discussions.microsoft.com> wrote in message
> news:C3B84E7A-4085-4089-85B8-820174CC303E@.microsoft.com...
> Sorry I did mean Full Text Search.
The full text searches had been copied to the same place and I'm not sure
what you mean about enabling full test searches on the database.
The full text search service is running
> Free text?
> I assume you mean FULL TEXT?
> Did you copy the Full-text indices to the same place?
> Did you enable full-text on the new database?
> How was the data moved?
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com [url]http://www.greenms.com/sqlserver.html[/ur
l]
>
>

Free SQL Reporting Services or license?

I had attended course 2030 creating report using MS SQL Server Reporting
Service and I wonder how do I get this tool? Free or license?
I had license MS SQL Server 2000 and do I need to purchase or request MS SQL
Server 2000 Reporting Service?
Please advise.I have heard a couple ways to get Reporting Services. RS is free to use
with your SQL Server license.
1. From the vendor where you got your SQL server.
2. From MSDN
3. From Microsoft directly, but I do not know how.
There might be other ways, but that is what I have seen so far.
--
| From: "sam" <samuellai@.ajikl.com.my>
| Subject: Free SQL Reporting Services or license?
| Date: Thu, 7 Jul 2005 11:06:43 +0800
| Lines: 9
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
| X-RFC2646: Format=Flowed; Original
| Message-ID: <#sj67DqgFHA.824@.TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: 211.24.171.163
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:47538
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I had attended course 2030 creating report using MS SQL Server Reporting
| Service and I wonder how do I get this tool? Free or license?
|
| I had license MS SQL Server 2000 and do I need to purchase or request MS
SQL
| Server 2000 Reporting Service?
|
| Please advise.
|
|
|

Free SQL Code beautifier for SQL Server

Hello,
maybe you are interested in this.
I wrote a java applet on www.sqlinform.com which is a SQL Code beautifier / formatter. It is for all kind of SQL (DB2, ORACLE; Access, Informix, etc). The only thing you need is a Java Runtime Environment (which should be available in most cases). You can beautify SQL statements out of program code and format them for Java, ASP, VB, PHP.
Regards
GuidoMarcelthat's really cool
now i can feel pretty, oh so pretty!!|||another development project in search of a problem?

I am getting a little tired of self promoters using this message board.|||If its useful and he's genuinely not trying to sell anything, I don't have any issues with it. I think it would be cool to have a spot on the forum where people could post useful and reusable functions/procs/utilities etc...|||its free, it works and promoting hasnt really even begun to get out of hand here.
and i can prove it! all you have to do is buy my new DVD at www.whogivesacrap.com

free sql 2005 cd?

I heard from my boss that there's a free sql 2000 dvd that microsoft are
giving away as part of their hype towards sql 2005 (i.e. much like the free
online training modules they offer). Where can i find further info on this?
many thanks.
cheers peterI wonder if it might be worth taking a look at microsoft.com? What do
you think they have on their home page? :-)
David Portas
SQL Server MVP
--|||Check following:
http://www.microsoft.com/sql/downloads/privacy.mspx
or
https://www.trysqlserver2005.com/profile.aspx?|||Free trial editions are (or soon will be) available via the web site. A
free standard edition is being given away to those who attend launch events.
See http://www.microsoft.com/events/200...ts/default.mspx
Hal Berenson, President
PredictableIT, LLC
www.predictableit.com
"peter walker" <pwalker@.sql.com> wrote in message
news:u5o0EtH5FHA.3980@.TK2MSFTNGP10.phx.gbl...
>I heard from my boss that there's a free sql 2000 dvd that microsoft are
>giving away as part of their hype towards sql 2005 (i.e. much like the free
>online training modules they offer). Where can i find further info on this?
> many thanks.
> cheers peter
>|||Thanks for the help everyone. Although not that simple to fine, I managed to
grab a hold of what I was looking for - finally!
It was the following free DVD packs that microsoft are giving away for free
(free shipping as well):
- SQL Server 2005, June Community Technology Preview Readiness Kit (comes on
2 DVD's) for free.
- Business Intelligence Resource Guide
- Microsoft Solutions for Business Intelligence Technical Training and
Resources
- SQL Server 2000 Reporting Services Developer Edition
They are coming in the mail soon!
Cheers, Peter
"peter walker" <pwalker@.sql.com> wrote in message
news:u5o0EtH5FHA.3980@.TK2MSFTNGP10.phx.gbl...
>I heard from my boss that there's a free sql 2000 dvd that microsoft are
>giving away as part of their hype towards sql 2005 (i.e. much like the free
>online training modules they offer). Where can i find further info on this?
> many thanks.
> cheers peter
>|||Peter,
You do understand that those are beta editions and if I recall
correctly they will expire within a year?
You can always get the developer edition from Amazon for $59.99 with
free shipping if you need the enterprise capabilities that are not
included in the free give away versions
http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2
http://sqlservercode.blogspot.com/

Sunday, February 26, 2012

Free XML ODBC Drivers?

Free XML ODBC Drivers?

Free up the transaction log

Free up the transaction log

Free up the transaction log

Free unused space in database

Free unused space in database

Free unused space in database

Free Tutorial Source with from A to Z examples

free transaction log reader

free tools for creating sql script with records?

free tools for creating sql script with records?

Free tool to compare two databases

Free Tool for MSSQL Admin

Free text search for 2 million records

Free Text Search across multiple tables

free text search

Free Text Search

Free Text Search

Free Text Search

Free SQL Reporting Services or license?

Free SQL Code beautifier for SQL Server

free sql 2005 cd?

Get Next Number

Blog Archive

About Me