Showing posts with label old. Show all posts
Showing posts with label old. Show all posts

Wednesday, March 28, 2012

Replacing an old Lotus Notes system...

for a couple hundred users... These folks currently replicate several Notes databases at least once a day.
Do you think I'm crazy for considering a new solution with SQL Server in the middle and MSDE or SQL Personal edition on all the remote machines? Is it feasible or am I trying to fit a sqaure peg in a round hole?
The way to do this with the least amount of work is to migrate to Exchange
and take your public folders offline.
"Curious" <anonymous@.discussions.microsoft.com> wrote in message
news:4D54C201-725B-445E-8581-A1CE9B7C0DF6@.microsoft.com...
> for a couple hundred users... These folks currently replicate several
Notes databases at least once a day.
> Do you think I'm crazy for considering a new solution with SQL Server in
the middle and MSDE or SQL Personal edition on all the remote machines? Is
it feasible or am I trying to fit a sqaure peg in a round hole?
|||Thanks Hillary, but I think we're looking for a more traditional RDBMS environment with constraints, triggers, easy reporting via SQL queries, probably through a Windows UI...
|||Then what you are going to wind up doing is creating an application which
can browse the documents in Notes, extract them, and load them into SQL
Server. You will also have to pay attention to any document linkages. You
are also going to have to build some intelligent application logic to
extract discrete data within forms to load them into tables. It can be
done, but there is no easy or clean way of doing it.
Mike
Principal Mentor
Solid Quality Learning
"More than just Training"
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com

Replacing a Server

Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.
Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.
|||Hi,
Look into the KB article:-
http://support.microsoft.com/default...b;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.

Replacing a Server

Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.|||Hi,
Look into the KB article:-
http://support.microsoft.com/defaul...kb;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.

Replacing a Server

Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.Basically, you can do a backup and restore of most of the databases. You
can create DTS packages to migrate jobs and logins.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
Hi,
I just replaced a Windows 2003 server. The old server had SLQ Server 2000 on
it. Is there an artcile I can read on how to transfer everything over from
one server to the other.
Thanks,
Kevin.|||Hi,
Look into the KB article:-
http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071
Since this help you to move system databases as well; there is no need to
copy Logins; users;jobs; dts packages from old server.
Thanks
Hari
SQL Server MVP
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:AE75FF39-4E1C-4DE2-B92A-082BBCB57D42@.microsoft.com...
> Hi,
> I just replaced a Windows 2003 server. The old server had SLQ Server 2000
> on
> it. Is there an artcile I can read on how to transfer everything over from
> one server to the other.
> Thanks,
> Kevin.

replacement of *= in 2005

Hi,
We are migrating to 2005 and there are some old queries that use *= in the
sql. Is it no more used?
Whats the other way to get the same functionality?
ThanksCheck out LEFT OUTER JOIN in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"mavrick_101" <mavrick101@.discussions.microsoft.com> wrote in message
news:C3A7A6B0-2CCD-4EB3-B807-23A692DCC44F@.microsoft.com...
Hi,
We are migrating to 2005 and there are some old queries that use *= in the
sql. Is it no more used?
Whats the other way to get the same functionality?
Thanks|||Are you familiar with LEFT OUTER JOIN syntax? That's what you should be
using.
"mavrick_101" <mavrick101@.discussions.microsoft.com> wrote in message
news:C3A7A6B0-2CCD-4EB3-B807-23A692DCC44F@.microsoft.com...
> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
Set database compatibility level (sp_dbcmptlevel) other than 90 (70, 80)

> Whats the other way to get the same functionality?
Left outer join (* =)
Right outer join (= *)
Full outer join (* = *)
AMB
"mavrick_101" wrote:

> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||use left outer join
"mavrick_101" wrote:

> Hi,
> We are migrating to 2005 and there are some old queries that use *= in the
> sql. Is it no more used?
> Whats the other way to get the same functionality?
> Thanks|||>> Full outer join (* = *)
' I doubt if it was there.
Anith|||Thanks Anith.
AMB
"Anith Sen" wrote:

> ' I doubt if it was there.
> --
> Anith
>
>

Saturday, February 25, 2012

reorg PK clustered index in VLDB

My data warehouse is now 4 years old and the size is about
600 GB od data.
We had only data insert no update in this duration. PKs
are all clustered indexes and in chronological order.
Some of tables are as large as 100 GB.
I wanted to check if the PKs are in good figure and ran
DBCC showcontig against many of large tables and 80 % had
bad rate for scan density , such as 50 %, 30 %.
I may need to reorganise PK.
I BOL it says comparing the values of Extent Switches and
Extents Scanned is a way to know how much fragmented. But
it says this method does not work if the index spans
multiple files. I presume all VLDB exploit multiple files
for one table in order to gain physical disk I/O.
My question: how can I check fragmentation rate of my
large tables which span multiple files (up to 4 to 6
files)?
What is the best way to reorganise clustered index which
are PK ? I have to drop all FK in order to reorganise PK,
don't I !
I hope to hear your idea!!!When you say you presume your db spans multiple files, does the database use
more than one file other than the MDF? DBCC DBreindex on the clustered key
should reindex your data tables and automatically reindex your other
nonclustered indexes.
Some links:
http://www.microsoft.com/technet/co...ql/sql0326.mspx
http://www.microsoft.com/technet/co...ql/sql1014.mspx
http://www.sqlservercentral.com/scr...butions/721.asp
Ray Higdon MCSE, MCDBA, CCNA
--
"didi" <anonymous@.discussions.microsoft.com> wrote in message
news:140c01c40b37$dd2c95d0$3501280a@.phx.gbl...
> My data warehouse is now 4 years old and the size is about
> 600 GB od data.
> We had only data insert no update in this duration. PKs
> are all clustered indexes and in chronological order.
> Some of tables are as large as 100 GB.
> I wanted to check if the PKs are in good figure and ran
> DBCC showcontig against many of large tables and 80 % had
> bad rate for scan density , such as 50 %, 30 %.
> I may need to reorganise PK.
> I BOL it says comparing the values of Extent Switches and
> Extents Scanned is a way to know how much fragmented. But
> it says this method does not work if the index spans
> multiple files. I presume all VLDB exploit multiple files
> for one table in order to gain physical disk I/O.
> My question: how can I check fragmentation rate of my
> large tables which span multiple files (up to 4 to 6
> files)?
> What is the best way to reorganise clustered index which
> are PK ? I have to drop all FK in order to reorganise PK,
> don't I !
> I hope to hear your idea!!!|||MDF file is used only for system table in all of my
databases. (especially when dealing with VLDB).
The database is over 600GB, and each table could be nearly
100GB,
Would DBreindex a good solution ?
This will copy the whole table into different location
without asking !

>--Original Message--
>When you say you presume your db spans multiple files,
does the database use
>more than one file other than the MDF? DBCC DBreindex on
the clustered key
>should reindex your data tables and automatically reindex
your other
>nonclustered indexes.
>Some links:
>http://www.microsoft.com/technet/co...chats/trans/sql
/sql0326.mspx
>http://www.microsoft.com/technet/co...chats/trans/sql
/sql1014.mspx
>http://www.sqlservercentral.com/scr...tributions/721.
asp
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"didi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:140c01c40b37$dd2c95d0$3501280a@.phx.gbl...
about
had
and
But
files
PK,
>
>.
>|||Did those links help?
Ray Higdon MCSE, MCDBA, CCNA
--
"didi" <anonymous@.discussions.microsoft.com> wrote in message
news:148601c40b4b$a0c711b0$3a01280a@.phx.gbl...
> MDF file is used only for system table in all of my
> databases. (especially when dealing with VLDB).
> The database is over 600GB, and each table could be nearly
> 100GB,
> Would DBreindex a good solution ?
> This will copy the whole table into different location
> without asking !
>
> does the database use
> the clustered key
> your other
> /sql0326.mspx
> /sql1014.mspx
> asp
> message
> about
> had
> and
> But
> files
> PK,|||Links were very good! Thank you very much!
Especially Index Defrag Best Practices.
So, according to the article I should use fragmentation
level by logical scan fragmentation.
Still I am not very sure about using DBCC INDEXDEFRAG.
Because when a table is 100GB, and do this operation, how
large the log should be allocated ? 200 GB, 300 GB ?
Usually for copying data it takes about 2.5 times of data
size consumed in log before the data is inserted into.
Would DBCC INDEXDEFRAG be a best way in VLDB environment ?

>--Original Message--
>Did those links help?
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"didi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:148601c40b4b$a0c711b0$3a01280a@.phx.gbl...
nearly
on
reindex
>http://www.microsoft.com/technet/co...chats/trans/sql
>http://www.microsoft.com/technet/co...chats/trans/sql
>http://www.sqlservercentral.com/scr...tributions/721.
PKs
ran
which
>
>.
>|||Depends on the needed uptime of your DB, you can write scripts to defrag in
chunks. Here is an example of using dbreindex (you can alter to use index
defrag) and backing up the log when needed, think I got this from MVP Andrew
Kelly but not 100% sure:
-- Reindexing the tables --
SET NOCOUNT ON
DECLARE @.TableName VARCHAR(100), @.Counter INT
SET @.Counter = 1
DECLARE curTables CURSOR STATIC LOCAL
FOR
SELECT Table_Name
FROM Information_Schema.Tables
WHERE Table_Type = 'BASE TABLE'
OPEN curTables
FETCH NEXT FROM curTables INTO @.TableName
SET @.TableName = RTRIM(@.TableName)
WHILE @.@.FETCH_STATUS = 0
BEGIN
SELECT 'Reindexing ' + @.TableName
DBCC DBREINDEX (@.TableName)
SET @.Counter = @.Counter + 1
-- Backup the Log every so often so as not to fill the log
IF @.Counter % 10 = 0
BEGIN
BACKUP LOG [Presents] TO [DD_Presents_Log] WITH NOINIT , NOUNLOAD
,
NAME = N'Presents Log Backup', NOSKIP , STATS = 10,
NOFORMAT
END
FETCH NEXT FROM curTables INTO @.TableName
END
CLOSE curTables
DEALLOCATE curTables
Ray Higdon MCSE, MCDBA, CCNA
--
"didi" <anonymous@.discussions.microsoft.com> wrote in message
news:159401c40c21$2fc43b60$3a01280a@.phx.gbl...
> Links were very good! Thank you very much!
> Especially Index Defrag Best Practices.
> So, according to the article I should use fragmentation
> level by logical scan fragmentation.
> Still I am not very sure about using DBCC INDEXDEFRAG.
> Because when a table is 100GB, and do this operation, how
> large the log should be allocated ? 200 GB, 300 GB ?
> Usually for copying data it takes about 2.5 times of data
> size consumed in log before the data is inserted into.
> Would DBCC INDEXDEFRAG be a best way in VLDB environment ?
>
> message
> nearly
> on
> reindex
> PKs
> ran
> which