Viewing 15 posts - 7,246 through 7,260 (of 19,560 total)
It seems that the issue is around this
if ((Row.DefaultOrgUnitID == null))
A null comparison will always return false (check here: http://msdn.microsoft.com/en-us/library/edakx9da.aspx )
Try this for a workaround
http://msdn.microsoft.com/en-us/library/ms172138(v=vs.80).aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 4:26 pm
GilaMonster (1/8/2012)
I suspect that part of the problem is that the system can be gamed, companies specifically ticking criteria off in order to meet the requirements of the program rather...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 4:14 pm
george sibbald (1/6/2012)
just to be different, if the data is not changing, I would probably go for weekly. Why waste the resources (including tape) if the data is not changing?
We...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 4:10 pm
As Gail said, the exam is to test your understanding of what to use and not the intricate details. Also, if you have been doing this kind of work...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 3:21 pm
GilaMonster (1/8/2012)
SQLRNNR (1/8/2012)
Revenant (1/8/2012)
MysteryJimbo (1/8/2012)
WirelessBluetooth
Toothless
Dragon!
Night Fury
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 2:29 pm
Peter Maloof (1/7/2012)
Marty:I don't have an answer, but I want to point out that according to http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us:
Audience Profile
This exam has been updated for SQL Server 2008 R2.
...
Thanks for pointing...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 2:28 pm
L' Eomot Inversé (1/8/2012)
SQL Kiwi (1/7/2012)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 2:21 pm
Revenant (1/8/2012)
MysteryJimbo (1/8/2012)
WirelessBluetooth
Toothless
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 2:08 pm
SQL Kiwi (1/8/2012)
GilaMonster (1/8/2012)
Probably a cached stylesheet or something.
It's weird: it does the same thing in IE9 (which I very rarely open). Oh well, small irritation, it'll probably go...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 8, 2012 at 2:04 pm
L' Eomot Inversé (1/7/2012)
Evil Kraig F (1/6/2012)
Brandie Tarvin (1/6/2012)
I reject your reality and substitute my own.Dimensia.
Television?
Radio
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 7, 2012 at 11:23 pm
Yes you can do that. This article shows how to do that as well.
http://technet.microsoft.com/en-us/library/ms140355.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2012 at 4:45 pm
Here's another twist on the same script
USE MASTER
Go
SELECT cr.DatabaseName
,s.session_id, s.host_name, s.program_name, s.client_interface_name, s.login_name
,s.nt_domain, s.nt_user_name, c.client_net_address, c.local_net_address
,cr.ObjName
,cr.Query
FROM sys.dm_exec_sessions as s
INNER JOIN sys.dm_exec_connections as c
ON c.session_id = s.session_id
CROSS APPLY (SELECT db_name(dbid) AS...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2012 at 4:38 pm
Nice script indeed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2012 at 4:15 pm
Temp table method could work. Does your update statement have an adequate where clause?
Is there an index in place that fits the conditions of your queries?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2012 at 4:13 pm
There are several US based companies that provide this kind of service.
The first that comes to mind is http://ntirety.com/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 6, 2012 at 4:10 pm
Viewing 15 posts - 7,246 through 7,260 (of 19,560 total)