Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
Ansari
Use link in my signature, check Technical Resources.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>
|||Thanks a lot..
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> various
>

Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
AnsariUse link in my signature, check Technical Resources.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>|||Thanks a lot.. :)
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> > hi Gurus,
> >
> > I need the resource where I can find the Power point presentation on
> various
> > topics of SQL server.
> >
> > Thanks in advance
> >
> > Ansari
> >
> >
> >
> >
>

possible undetected deadlock

I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
I'm no expert on the log entry, but the word 'Victim' suggests to me that
this is not a deadlock, since SQL Server has chosen one of the transactions
as victim?
"ET" <et@.et.com> wrote in message
news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag
2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098)
Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||ET,
What made you work with hotfix build 840? With hotfix builds you can never be sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||What do you think you are getting with traceflag 2004? The flag for trapping deadlocks is 1204.
What exactly are you trying to address?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTTIKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping deadlocks is 1204.
What exactly are you trying to address?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||It was given to me by Microsoft some time ago to resolve an issue we were having at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never be sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||You must be using replication.
Chris
"ET" <et@.et.com> wrote in message news:%23ZgYHcIKEHA.3592@.TK2MSFTNGP09.phx.gbl...
It was given to me by Microsoft some time ago to resolve an issue we were having at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never be sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||No
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:u4yS86IKEHA.1388@.TK2MSFTNGP09.phx.gbl...
You must be using replication.
Chris
"ET" <et@.et.com> wrote in message news:%23ZgYHcIKEHA.3592@.TK2MSFTNGP09.phx.gbl...
It was given to me by Microsoft some time ago to resolve an issue we were having at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never be sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||Ok, so what are you trying to address?
Do you know you have a deadlock? How?
How are you checking the errorlog?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:#KRAzaIKEHA.3628@.TK2MSFTNGP12.phx.gbl...
Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTTIKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping deadlocks is 1204.
What exactly are you trying to address?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?
|||I was reading the errorlog using xp_readerrorlog when I noticed thse entries.
I am trying to determine if this is some type of undetected deadlock that may be degrading performance in some way.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:esu8SbJKEHA.3920@.TK2MSFTNGP10.phx.gbl...
Ok, so what are you trying to address?
Do you know you have a deadlock? How?
How are you checking the errorlog?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:#KRAzaIKEHA.3628@.TK2MSFTNGP12.phx.gbl...
Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTTIKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping deadlocks is 1204.
What exactly are you trying to address?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag 2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?

possible undetected deadlock

I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?I'm no expert on the log entry, but the word 'Victim' suggests to me that
this is not a deadlock, since SQL Server has chosen one of the transactions
as victim?
"ET" <et@.et.com> wrote in message
news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl...
I'm receiving this in my SQL server event log. Although I have trace flag
2004 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098)
Value:0x2d5a8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||ET,
What made you work with hotfix build 840? With hotfix builds you can never b
e sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||What do you think you are getting with traceflag 2004? The flag for trapping
deadlocks is 1204.
What exactly are you trying to address?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTT
IKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping
deadlocks is 1204.
What exactly are you trying to address?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||It was given to me by Microsoft some time ago to resolve an issue we were ha
ving at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk
$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never b
e sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||You must be using replication.
Chris
"ET" <et@.et.com> wrote in message news:%23ZgYHcIKEHA.3592@.TK2MSFTNGP09.phx.g
bl...
It was given to me by Microsoft some time ago to resolve an issue we were ha
ving at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk
$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never b
e sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||No
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:u4y
S86IKEHA.1388@.TK2MSFTNGP09.phx.gbl...
You must be using replication.
Chris
"ET" <et@.et.com> wrote in message news:%23ZgYHcIKEHA.3592@.TK2MSFTNGP09.phx.g
bl...
It was given to me by Microsoft some time ago to resolve an issue we were ha
ving at the time.
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message news:ORk
$LHIKEHA.2888@.TK2MSFTNGP09.phx.gbl...
ET,
What made you work with hotfix build 840? With hotfix builds you can never b
e sure what you are getting.
Chris Wood
Alberta Department of Energy
CANADA
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||Ok, so what are you trying to address?
Do you know you have a deadlock? How?
How are you checking the errorlog?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:#KRAzaIKEHA.3628@.TK2MSFTNGP12.phx.gbl
..
Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTT
IKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping
deadlocks is 1204.
What exactly are you trying to address?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?|||I was reading the errorlog using xp_readerrorlog when I noticed thse entries
.
I am trying to determine if this is some type of undetected deadlock that ma
y be degrading performance in some way.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:esu8Sb
JKEHA.3920@.TK2MSFTNGP10.phx.gbl...
Ok, so what are you trying to address?
Do you know you have a deadlock? How?
How are you checking the errorlog?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:#KRAzaIKEHA.3628@.TK2MSFTNGP12.phx.gbl
..
Sorry. That was a typo on my part. I meant 1204.
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message news:#h#bTT
IKEHA.2716@.tk2msftngp13.phx.gbl...
What do you think you are getting with traceflag 2004? The flag for trapping
deadlocks is 1204.
What exactly are you trying to address?
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"ET" <et@.et.com> wrote in message news:e2wuOHHKEHA.3944@.tk2msftngp13.phx.gbl
..
I'm receiving this in my SQL server event log. Although I have trace flag 20
04 enabled, this is all that I see in the SQL log.
Victim Resource Owner:
ResType:ExchangeId Stype:'AND' SPID:80 ECID:175 Ec0x2DD8A098) Value:0x2d5a
8c98 Cost0/270F)
I am running SQL 2000, build 840, on Windows server 2003. Also, I have SQL
configured to use 14GB from a total of 16GB on the server.
Does anyone have any suggestions for how to address this?

Possible to override browser language setting?

this snippet:
The browser language setting is the primary factor in determining which
language resource is used by the report server for that client connection.
For example, a user who accesses a Japanese report server using a French
version of Internet Explorer will work with French versions of Report
Manager, HTML Viewer, and the report server folder namespace. In addition,
all errors, warnings, and informational messages will be returned in French.
is from this article:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0vaa.asp
Is it possible to override this for reporting services? I have a user
locale setting in a DB that I would like to use instead of the browser or OS
settings. I can deliver the reports in the proper locale by passing a
parameter, but the settings for the web service still behave according to the
browser settings, as the snippet above describes. In fact, I have a date
format clash that I am not sure quite how to resolve.
Thanks in advance, any help will be very much appreciated.I can solve the date clash by formatting the datetime parameters according
to the browser's setting, but this does not really solve my problem because I
don't want things like selection of report export formats to be in the
browser's language, I want to set the culture information (from a user
profile in a DB).
Thank you again, I am looking forward to your feedback|||regarding my post on whether the locale used for things like the export
options can be set manually rather than pulled from the browser...
I think this will be an easy question to answer for someone on the
development team or simply someone more familiar with microsoft
internationalization than myself.
Thank you very much, in advance.
skillet