Viewing 15 posts - 3,391 through 3,405 (of 19,560 total)
Take a look at the pivot command and see if that helps.
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
March 10, 2014 at 12:47 pm
With the improvements in the QO, the implicit conversions are likely just being revealed to you now while they 2000 didn't care so much about it. I'd find a...
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
March 10, 2014 at 12:41 pm
nandu.chowdary412 (3/10/2014)
ohh..thanks for quick reply.
You are 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
March 10, 2014 at 11:24 am
Try this
WITH thisCTEisJustToProduceSampleData AS (
SELECT 'x' AS ex_prdname, 10 AS price
UNION
SELECT 'y', 20
UNION
SELECT 'z',30
)
SELECT TOP 2 *
FROM thisCTEisJustToProduceSampleData
ORDER BY price DESC;
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
March 10, 2014 at 11:16 am
hb21l6 (3/10/2014)
To create a heap, create a table without a clustered index. If a table already has a clustered index, drop the clustered index to return the table to...
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
March 10, 2014 at 10:49 am
Those are your heaps. You may want to investigate the creation of a clustered index on those tables.
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
March 10, 2014 at 10:29 am
what is the index id of these nameless indexes? I am betting it is an id of 0. But let's confirm for certain before jumping down any assumptions.
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
March 10, 2014 at 10:16 am
Try the script here.
http://jasonbrimhall.info/2011/11/17/table-space-revised-again/
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
March 10, 2014 at 10:13 am
trick
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
March 10, 2014 at 10:11 am
GilaMonster (3/10/2014)
Especially when some of our roads look like this: https://twitter.com/Deirdre91388179/status/442926357560184832/photo/1. I drove down that road a week ago.
I'd call that one of those infinite nested loops operations.
At...
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
March 10, 2014 at 10:09 am
Ed Wagner (3/10/2014)
SQLRNNR (3/10/2014)
GilaMonster (3/10/2014)
Jack Corbett (3/10/2014)
No just 90 minutes total, and that's probably actually longer than it'll actual take most days.
That's about what my commute is now,...
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
March 10, 2014 at 10:07 am
Sean Lange (3/10/2014)
koti.raavi (3/10/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
March 10, 2014 at 10:05 am
See my response on this other thread.
http://www.sqlservercentral.com/Forums/FindPost1549320.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
March 10, 2014 at 9:56 am
errrmmm
http://www.sqlservercentral.com/Forums/FindPost1549320.aspx :Whistling: :unsure:
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
March 10, 2014 at 9:55 am
koti.raavi (3/10/2014)
The objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance...
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
March 10, 2014 at 9:54 am
Viewing 15 posts - 3,391 through 3,405 (of 19,560 total)