Viewing 15 posts - 10,306 through 10,320 (of 19,560 total)
krypto69 (4/26/2011)
declare @cnt smallint
Select @cnt = count(*)
, glaccount, 'ACCOUNT NOT FOUND' ErrorReason
from dynamicsgp_utilities.dbo.V_sfvouchers
where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in
(
select pordnmbr from lpb..pm30200 where doctype...
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
April 26, 2011 at 2:24 pm
ChrisM@home (4/26/2011)
Is it me, or are the posted questions from developers working on medical systems a little worrying?
Have you ever noticed all of the problems with data in that industry?
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
April 26, 2011 at 2:23 pm
The error message is not due to the IP though. It is a kerberos issue which is an authentication protocol in active directory. You have already done everything...
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
April 26, 2011 at 2:19 pm
dant12 (4/26/2011)
My...
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
April 26, 2011 at 2:17 pm
GilaMonster (4/26/2011)
There's no need to count all the rows just to see if any rows exist. It's inefficient.
Good point
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
April 26, 2011 at 2:11 pm
Is that the entirety of the trigger?
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
April 26, 2011 at 2:10 pm
Try this article and see if it helps.
http://support.microsoft.com/kb/811889
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
April 26, 2011 at 2:06 pm
krypto69 (4/26/2011)
SQLRNNR -I made your changes and got the error
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near 'EM'.
Post the entire query you just ran to get that...
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
April 26, 2011 at 2:03 pm
When trying to set a variable, you have to be careful in whether you use set or select. You cannot call multiple columns in the Set, where in the...
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
April 26, 2011 at 2:02 pm
Try this little change:
Instead of:
declare @cnt smallint
set @cnt =
select *, glaccount, 'ACCOUNT NOT FOUND' ErrorReason
from dynamicsgp_utilities.dbo.V_sfvouchers
where (sfid like 'EM-%' or sfid like 'EXP-REP%') and sfid not in
Do
declare @cnt...
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
April 26, 2011 at 1:57 pm
Nice article and thanks for posting and sharing your methods.
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
April 26, 2011 at 1:52 pm
GilaMonster (4/26/2011)
SQLRNNR (4/26/2011)
Stefan Krzywicki (4/26/2011)
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
That is something that would strongly...
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
April 26, 2011 at 1:44 pm
Stefan Krzywicki (4/26/2011)
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
That is something that would strongly tempt me...
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
April 26, 2011 at 1:34 pm
GilaMonster (4/26/2011)
Working on PASS abstracts tonight. Am strongly tempted to write one of them at least in verse. Just for fun...
Please do - it would be well worth it:cool:
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
April 26, 2011 at 12:49 pm
you're welcome
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
April 26, 2011 at 12:22 pm
Viewing 15 posts - 10,306 through 10,320 (of 19,560 total)