Viewing 15 posts - 17,431 through 17,445 (of 19,560 total)
Alter your query to the following:
SELECT TOP 120 A.[Page]
,C.[Category] AS 'PostCategory'
,A.[Title]
,A.[Notes]
,A.[Color]
,A.[CreatedOn]
...
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
February 9, 2010 at 7:16 pm
It sounds like it might be an iso problem.
Here is a thread of the same issue, it might help:
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
February 9, 2010 at 7:11 pm
Try a copy and paste to a new browser window. Also, did you receive an error message?
Here is an additional article.
http://decipherinfosys.wordpress.com/2007/08/14/moving-tables-to-a-different-filegroup-in-sql-2005/
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
February 9, 2010 at 6:58 pm
Just trying to get clarification on your question. Your initial post was on how to force a clustered index seek. With that achieved, you then asked how 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
February 9, 2010 at 6:56 pm
Take your query and step it up a few notches. Make it an extremely complex query and then compare the cost on the sort. Also, compare it when...
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
February 9, 2010 at 6:55 pm
Read the article I posted.
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
February 9, 2010 at 6:11 pm
Here is an article that discusses how to move tables to filegroups
http://www.sqlservercentral.com/articles/Files+and+Filegroups/65538/
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
February 9, 2010 at 6:09 pm
Digs (2/9/2010)
thanks..Interesting...
HOW do I a SELECT TOP 120 * FROM <table> records on the BlogUserID auto field
????
And maintain a clustered index seek?
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
February 9, 2010 at 5:58 pm
Gift Peddie (2/9/2010)
It's both. Someone who blogs 5 times a day but just quotes Books Online or is dead wrong is probably not going to get awarded.
I know SQL Server...
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
February 9, 2010 at 5:54 pm
The cost will vary. It truly depends on the size of the table and the scan. Execute the query with the actual execution plan. Highlight your clustered...
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
February 9, 2010 at 5:52 pm
jtfromstl (2/9/2010)
...Most companies don't know they need a solid DBA - until - they need a solid DBA.
...
I would take that a step further. Many companies don't know they...
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
February 9, 2010 at 5:48 pm
Are you able to see any performance info when querying:
select * from sys.dm_os_performance_counters
?
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
February 9, 2010 at 5:40 pm
I have had luck with making sure the variable is read/write on the script object properties. Then in the later task, assign it using an expression.
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
February 9, 2010 at 5:35 pm
Have you tried extracting the ISO out to harddisk and then trying the install?
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
February 9, 2010 at 5:01 pm
WayneS (2/9/2010)
CirquedeSQLeil (2/9/2010)
Roy Ernest (2/9/2010)
If you use is_ms_shipped = 0, does it not exclude those tables?
Those two tables, no. They are tweener tables. They were technically shipped with...
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
February 9, 2010 at 4:40 pm
Viewing 15 posts - 17,431 through 17,445 (of 19,560 total)