Differential backup

This may be obvious but i can't find any official word about this so...
Background:
We are using a weekly backup and a couple of differential backup daily on
sqlserver 2000 using BackupExec. According to BOL the backup works as
follows:
"Database â' differential
Perform a differential database backup. A differential backup records only
the changes made to the data in the database after the last full database
backup."
Beside these normal backups, we would like to make additional full database
backups to harddrive daily.
Question:
Will the extra backups interfere with the normal backups to tape by
resetting "the last full database backup" iaw will the next differential
backup start from that full backup to the harddrrive then? We would like to
see the normal (tape) backup being undisturbed by the extra full backups.
Can anyone clear this up for me please? :)When you restore a diff backup, you must first have restored the most recent database backup prior
to that diff backup. IT doesn't matter whether that database backup was to disk and the diff backup
is to tape (or vice versa).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Hans" <Hans@.discussions.microsoft.com> wrote in message
news:BA274B88-5E90-4799-8B9A-8F3979418051@.microsoft.com...
> This may be obvious but i can't find any official word about this so...
> Background:
> We are using a weekly backup and a couple of differential backup daily on
> sqlserver 2000 using BackupExec. According to BOL the backup works as
> follows:
> "Database - differential
> Perform a differential database backup. A differential backup records only
> the changes made to the data in the database after the last full database
> backup."
> Beside these normal backups, we would like to make additional full database
> backups to harddrive daily.
> Question:
> Will the extra backups interfere with the normal backups to tape by
> resetting "the last full database backup" iaw will the next differential
> backup start from that full backup to the harddrrive then? We would like to
> see the normal (tape) backup being undisturbed by the extra full backups.
>
> Can anyone clear this up for me please? :)|||Hi Hans,
Full database backup will make differential backups to be daily, which is
not what you want to achieve. Consider daily full database backup and
backups of transaction log hourly.
Regards,
Daniel
"Hans" <Hans@.discussions.microsoft.com> wrote in message
news:BA274B88-5E90-4799-8B9A-8F3979418051@.microsoft.com...
> This may be obvious but i can't find any official word about this so...
> Background:
> We are using a weekly backup and a couple of differential backup daily on
> sqlserver 2000 using BackupExec. According to BOL the backup works as
> follows:
> "Database - differential
> Perform a differential database backup. A differential backup records only
> the changes made to the data in the database after the last full database
> backup."
> Beside these normal backups, we would like to make additional full
database
> backups to harddrive daily.
> Question:
> Will the extra backups interfere with the normal backups to tape by
> resetting "the last full database backup" iaw will the next differential
> backup start from that full backup to the harddrrive then? We would like
to
> see the normal (tape) backup being undisturbed by the extra full backups.
>
> Can anyone clear this up for me please? :)

Different row colors (AlternatingItemStyle in asp.net)

Hi everyone!
Is it possible to changes the background color for each row? People coding
asp.net would know this as "AlternatingItemStyle" in a datagrid.
Can this be done using the VS IDE or do I have to go behind the code in the
rdl file?
Best Regards
Jesper.Hello Jesper,
you can put the following into the Background-property in VS IDE:
Backgroundcolor
=IIF(RowNumber("<table1>") Mod 2, "<color1>", "<color2>")
That's all.
Stefan
"Jesper Jensen" <jbj@.union.dk> schrieb im Newsbeitrag
news:egG1HdNrHHA.1204@.TK2MSFTNGP04.phx.gbl...
> Hi everyone!
> Is it possible to changes the background color for each row? People coding
> asp.net would know this as "AlternatingItemStyle" in a datagrid.
> Can this be done using the VS IDE or do I have to go behind the code in
> the rdl file?
> Best Regards
> Jesper.
>|||Hello Stefan
So simple and so powerfull.
Thank you very much!!!!!
Best Regards
Jesper
"Stefan" <stefan@.nospam.nospam> wrote in message
news:eqki9NOrHHA.1168@.TK2MSFTNGP03.phx.gbl...
> Hello Jesper,
> you can put the following into the Background-property in VS IDE:
> Backgroundcolor
>
> =IIF(RowNumber("<table1>") Mod 2, "<color1>", "<color2>")
>
> That's all.
>
> Stefan
>
> "Jesper Jensen" <jbj@.union.dk> schrieb im Newsbeitrag
> news:egG1HdNrHHA.1204@.TK2MSFTNGP04.phx.gbl...
>> Hi everyone!
>> Is it possible to changes the background color for each row? People
>> coding asp.net would know this as "AlternatingItemStyle" in a datagrid.
>> Can this be done using the VS IDE or do I have to go behind the code in
>> the rdl file?
>> Best Regards
>> Jesper.
>

Different Execution Plans -> Same Query, Same Database, Different SQL Server Install

Background: Same database, restored from development to production.

Indexes up to date. Service Pack 3 on Production. Originally RTM on Development, upgraded to Sp4, Execution Plan remained the same.

The query itself is not my concern, but that there is such a wide difference in performance between 2 boxes. Is there a setting on the Production that might be slowing it down? My system seems to have selected a worktable, is there a way I can turn that off to mimic the server?

I want to optimize the queries to perform best on the Production server, which is hard to do if my server's chosing different execution plans.

Is there anyway to determine why the Production machine would choose one plan vs. the development machine?
Development:
|--Nested Loops(Inner Join, OUTER REFERENCES:([CLIENT].[CONSUMER_UUID]))
|--Index Spool(SEEK:([CLIENT].[FIRST_NAME]=.[FIRST_NAME] AND [CLIENT].[LAST_NAME]=.[LAST_NAME]))
| |--Clustered Index Scan(OBJECT:([SAMS2K_ND_STATE].[dbo].[CLIENT].[PK_CLIENT]))
|--Clustered Index Seek(OBJECT:([SAMS2K_ND_STATE].[dbo].[CONSUMER].[PK_CONSUMER]), SEEK:([CONSUMER].[CONSUMER_UUID]=[CLIENT].[CONSUMER_UUID]), WHERE:([CONSUMER].[DOB]=[C2].[DOB] AND [CONSUMER].[RES_TOWN_NAME]=[C2].[RES_TOWN_NAME]) ORDERED FORWARD)

Production:
|--Nested Loops(Inner Join, OUTER REFERENCES:([CLIENT].[CONSUMER_UUID]))
|--Clustered Index Scan(OBJECT:([SAMS2K_ND_STATE].[dbo].[CLIENT].[PK_CLIENT]), WHERE:([CLIENT].[FIRST_NAME]=.[FIRST_NAME] AND [CLIENT].[LAST_NAME]=.[LAST_NAME]))
|--Clustered Index Seek(OBJECT:([SAMS2K_ND_STATE].[dbo].[CONSUMER].[PK_CONSUMER]), SEEK:([CONSUMER].[CONSUMER_UUID]=[CLIENT].[CONSUMER_UUID]), WHERE:([CONSUMER].[DOB]=[C2].[DOB] AND [CONSUMER].[RES_TOWN_NAME]=[C2].[RES_TOWN_NAME]) ORDERED FORWARD)

The following is the output of the statistics on my Local Development
Server:
Table 'CONSUMER'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0.
Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0.
Table 'CLIENT'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0.
SQL Server Execution Times:
CPU time = 3187 ms, elapsed time = 1877 ms.
This is the output of the statistics on the Production environment:
Table 'CONSUMER'. Scan count 88857, logical reads 274907, physical reads 0, read-ahead reads 0.
Table 'CLIENT'. Scan count 41708, logical reads 48294390, physical reads 0, read-ahead reads 0.
SQL Server Execution Times:
CPU time = 690218 ms, elapsed time = 225583 ms.

Have you checked that the statistics are equal for the indexes on both servers?

Look for DBCC SHOW_STATISTICS in the BOL.
|||

Try and rebuild the Indexes on Production Database

DBCC DBREINDEX

|||

The databases were identical, both restored from the same backup resources on the same day.

Thank you for your responses, and I will attempt both, but I don't believe that the statistics or indexes would be different if drawn from the same resource?

|||This is not due to statistics or indexes. It should be identical when you restore from a backup of a database. There are other factors that can affect the query plan - number of processors, memory, maxdop settings etc. Additionally you should try to keep the service pack level the same between the machines. The main reason is that you could get different plans due to changes in service pack and some could be bugs also. So it is best to compare servers that are on the same service pack too. If you are seeing worse performance than SP3 for the same query/machine configuration then it is most probably a bug. I would encourage you to create a bug using the MSDN Product Feedback Center with the repro steps. Also, please use SET STATISTICS PROFILE to check the actual query plan/execution times.|||

It should indeed be identical when you restore but a colleague here has experienced some strange behavior after a restore several times. He claims that after an update of the statistics everything functioned as expected. Now I can't say I fully support this statement as I have no personal experience with this.

We tend to keep our service packs identical to production, I think this should be a rule for every development environment.

You should update your weblog Uma, you still have to answer my NOLOCK question :-)

|||

Thanks for your reply,

The production is running SP3a. I tested the query on development environment at both RTM and SP4 (not realizing the production was still only at SP3) and I did get the same plans between RTM and SP4.

The production machine is Windows 2003 server dual processor,Intel Xeon 3.6ghz, with 3.5 GB Memory, it is part of a cluster server.
The development machine is Windows XP dual processor, Intel Pentium 4 2.6ghz, with 1 GB Memory.

I will compare the profiles in the am.

different colour background in matrix table results

Hi,

I have a matrix table with a subtotal column

I would like to make the background colour off this different to the rest of the matrix, how would i do this.

Also I would like to make some portions off the matrix results a different colour as well, how I can i acheive this

thanks

I have not used matrix recently. But dont you have the option of "Background Color" in properties. If you find one you should be able to wrte an expression with which you can control the color based on the value|||

it doesnt work !

I used under background colour in the results area with shift being a group

=IIF(Fields!shift = "Night",TRANSPARENT, BLACK)

It doesnt like the syntax

can someone else help

thanks

Different background color for top customers

Hi,
This is probably a very 101 question :-)
I have a query that returns customer records. These records are sorted by
region and name. Now I have a requirement to highlight the top 10 customers
(the 10 highest $$$ amounts), without changing the order of the customers.
Is there a way to do this like
iif(max(10), "red", "white")
or something similar'
Any help very much appreciated.
Cheers,
DomYou can solve it in your source query. Just do a LEFT OUTER JOIN to a
SELECT TOP 10. You don't display the results of the left join on the
report, but can use the values returned to color the rows.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"dbuschi" <dbuschi@.discussions.microsoft.com> wrote in message
news:2EA400D4-9630-40FD-9330-15A235DC749C@.microsoft.com...
> Hi,
> This is probably a very 101 question :-)
> I have a query that returns customer records. These records are sorted by
> region and name. Now I have a requirement to highlight the top 10
> customers
> (the 10 highest $$$ amounts), without changing the order of the customers.
> Is there a way to do this like
> iif(max(10), "red", "white")
> or something similar'
> Any help very much appreciated.
> Cheers,
> Dom