Viewing 15 posts - 16 through 30 (of 68 total)
Hi Grant - I should rephrase my statement - the book has been very helpful and elucidating - just could not correlate this scenario with the book so I needed...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2015 at 2:33 pm
Thanks Gail - as you noted with/without where clause was almost no difference in this case. It seems to be just the volume of data per row.
Although...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2015 at 2:31 pm
Here is the result form the query you sent - thank you
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2015 at 2:26 pm
Hi Alan - attached is the actual query plan - looks ok. As noted earlier when I limit the columns required the performance is fine - just select *...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2015 at 2:21 pm
Yes, limited columns gives much better performance
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 20, 2015 at 2:16 pm
Thank you very much all who have responded !
- data is fun, but gotta learn the rules to make it work for you, or you work for it
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 6, 2015 at 5:35 am
Thanks Karen - much appreciated.
I doubt there is just one 'magic bullet' but - this really seems like a market opportunity to build an astute tool that asks...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 5, 2015 at 10:54 am
Thanks Wayne, I am using Brent's tools and some of Ola Hallengren's maintenance solution. The app was not done with much awareness of SQL design methodologies, platform and maintenance...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 5, 2015 at 10:16 am
Thanks Eric
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 30, 2015 at 9:27 am
Steve and Grant - thank you both. I much appreciate your guidance and suggestions, I'm sure that I can learn some important things and help my client - and that's...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 30, 2015 at 6:54 am
Thank you - will check on SQLCop.
The system is very messy, lots of Heaps, few indexes, nchars, nvarchar with ansi padding off - should be able to help them....
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 29, 2015 at 4:08 pm
Hi Grant -
I appreciate your response, and all your knowledge and experience. Maybe I'm short-cutting or lazy here but I was hoping for a shorter solution/crash course(!:w00t:) than reading...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 29, 2015 at 12:38 pm
Thanks Steve,
My first instinct was to get them off of non-sequential GUIDs and use Integer identities - but they are both surrogate keys so maybe not much difference other than...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
April 29, 2015 at 9:48 am
5 years from now...
When I started in this business 35 years ago life was punch-card FORTRAN and Assembler code. I am absolutely amazed at where we are now, and...
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
October 6, 2014 at 8:49 am
The answer should be 20
Tom in Sacramento - For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
September 30, 2014 at 6:36 am
Viewing 15 posts - 16 through 30 (of 68 total)