Viewing 15 posts - 2,731 through 2,745 (of 19,560 total)
cbrammer1219 (6/27/2014)
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
June 27, 2014 at 8:57 am
David Burrows (6/27/2014)
SQLRNNR (6/27/2014)
Is this good enough to save the OP from getting fired?
:ermm: Hope the job does not ride on this solution alone :pinch:
Just something I pieced together...
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
June 27, 2014 at 8:53 am
Sana4u (6/27/2014)
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
June 27, 2014 at 8:41 am
What does your execution plan look like?
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
June 27, 2014 at 8:39 am
Are you running any CLR?
Are you running SSIS on this box?
Are you running SSRS on this box?
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
June 27, 2014 at 8:36 am
David Burrows (6/27/2014)
WITH cte (itemID,ItemProgramPricingID,Price,Quantity,Points,ProgramCodeName,RowID)
AS (
SELECTipp.itemID,
ippv.ItemProgramPricingID,
ippv.Price,
ippv.Quantity,
ippv.Points,
p.Code,
ROW_NUMBER() OVER (
PARTITION BY ipp.itemID,ippv.ItemProgramPricingID,ippv.Price,ippv.Quantity,ippv.Points
ORDER BY CASE WHEN p.Code = 'STORE2' THEN 1 ELSE 2 END ASC)
FROMItemProgramPricing ipp
JOIN ItemProgramPricingValues as ippv 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
June 27, 2014 at 8:34 am
Are you confined to using server side trace to do that?
Or can you use extended events as an option?
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
June 27, 2014 at 8:32 am
Sean Lange (6/27/2014)
SQLRNNR (6/27/2014)
Sean Lange (6/27/2014)
Loner (6/27/2014)
I struggled it and could not come 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
June 27, 2014 at 8:27 am
Performance tuning is good for everybody. Though there are other things to consider when looking to tune reports besides just the tsql.
I would also recommend my book 😉
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
June 27, 2014 at 8:18 am
Sean Lange (6/27/2014)
Loner (6/27/2014)
I struggled it and could not come up with the answer....
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
June 27, 2014 at 8:15 am
Grant Fritchey (6/27/2014)
Anyone think they can help this person? I think they really need it, and what's more, deserve it. 6.5? Please, no.
We'll see.
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
June 27, 2014 at 8:12 am
Are you able to open the packages and try to run them manually?
If so, have you tried that to see where the package is getting hung?
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
June 27, 2014 at 8:11 am
Another thought on the matter.
The default collation on SQL Server will be different depending on the Windows Locale setting. This of course is before performing the setup for SQL...
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
June 27, 2014 at 7:56 am
Thanks Barry.
Here is another fine article on the OVER clause
http://www.sqlservercentral.com/articles/T-SQL/75466/
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
June 27, 2014 at 7:49 am
Much simpler than some of the questions from Andy of late. Really straight forward and is something that should be useful to all DBAs.
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
June 27, 2014 at 7:45 am
Viewing 15 posts - 2,731 through 2,745 (of 19,560 total)