Viewing 15 posts - 18,706 through 18,720 (of 19,560 total)
Now that you know the symptoms, you would probably be amazed at how frequently this pops up.
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
December 16, 2009 at 3:55 pm
Did you update that same line every time it appeared in the code that Lynn provided?
Somewhere in your process it is trying to convert the $ back to an int.
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
December 16, 2009 at 3:52 pm
I was rooting for the Packers too. 2 Reasons Elway and Broncos - don't like either of them much.
It was a weird sort of feeling too, being a Bears...
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
December 16, 2009 at 3:45 pm
That has got to be a load of fun. At least she isn't a Mets fan 😉
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
December 16, 2009 at 2:13 pm
john.arnott (12/16/2009)
CirquedeSQLeil (12/14/2009)
Alvin Ramard (12/14/2009)
GSquared (12/14/2009)
CirquedeSQLeil (12/11/2009)
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
December 16, 2009 at 2:12 pm
Now we need a database like that for basketball.
Ohh the fun we could have with Fantasy Baseball with this database.: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
December 16, 2009 at 1:51 pm
Heh... Yankees fan?? Born Yankees hater myself. Respect the players (some of them) hate the franchise.;-)
As far as teams go, I was not raised in a Baseball home...
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
December 16, 2009 at 1:49 pm
Use some app outside of SQL to password protect the file.
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
December 16, 2009 at 1:40 pm
sp_send_dbmail [ [ @profile_name = ] 'profile_name' ]
[ , [ @recipients = ] 'recipients [ ; ...n ]' ]
[ , [ @copy_recipients = ] 'copy_recipient [ ; ...n ]' ]
[...
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
December 16, 2009 at 1:39 pm
I've seen 2%, 5% and as much as 10% as the recommended low for this counter.
So if 4GB is well beyond 10% free, then you have adequate memory for your...
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
December 16, 2009 at 1:31 pm
based on the available criteria:
Here's another method
SELECT ID,Serial,Narration,Reference
FROM statementmaster
Where isnull(Narration,1) = 1
And Serial like (case when serial = '700' then '700' else '%' end)
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
December 16, 2009 at 1:20 pm
stewsterl (12/15/2009)
then '$' + CONVERT(money, total_amount)
But the $ does not show up for some reason.
current results 10495.00
Need $10,495.00
Any ideas on...
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
December 16, 2009 at 12:57 pm
In addition to what Grant said, was there anything else that was running at execution time?
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
December 16, 2009 at 12:48 pm
A suggestion:
Try writing it out in pseudo-code first. Once you have the pseudo-code, you can start learning the commands that fit the logic you need.
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
December 16, 2009 at 11:36 am
The following doc would also be a good read:
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
December 16, 2009 at 11:27 am
Viewing 15 posts - 18,706 through 18,720 (of 19,560 total)