Viewing 15 posts - 826 through 840 (of 3,738 total)
Thanks for the feedback from everyone.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 26, 2014 at 5:59 am
Eirikur Eiriksson (6/25/2014)
My 2 cents on this, GUI generated code is not always forward compatible, I.e. the semicolon termination is missing.😎
I do not like GUI generated code.
I do not use...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 5:55 pm
Grant Fritchey (6/25/2014)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 4:07 pm
Jack Corbett (6/25/2014)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 2:58 pm
Sean Lange (6/25/2014)
Welsh Corgi (6/25/2014)
They tell me know that they do not...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 2:10 pm
How much easier would it be for someone that uses the GUI to generate code using 2012 over 2008R2?
They tell me know that they do not use the query designer...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 2:03 pm
Sean Lange (6/25/2014)
Welsh Corgi (6/25/2014)
What enhancements have been to the 2012 GUI (Client only) that facilitates faster coding, etc.?I appreciate you feedback.:-)
Faster coding would be achieved by not using the...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 1:48 pm
I ended up renaming the table and recreating it with the proper Indexes and loading the table.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 25, 2014 at 8:16 am
Sean Lange (6/24/2014)
Welsh Corgi (6/24/2014)
Now I'm having problems creating a Non CLUSTERED Index.We can help but we need to know what the problem is.
Sorry for not providing better details.
After dropping...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2014 at 1:25 pm
ok, thanks.
I should have made a post earlier but I had a production issue.
I was able to Delete all Indexes and the Primary Key.
Now I'm having problems creating a Non...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2014 at 12:28 pm
How about when you create the Indexes, what order do you use?
I'm changing the primary key from CLUSTERED to Non-Clustered.
I'm going to create a Clustered Index on columns that are...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2014 at 12:05 pm
I dropped the Non Clustered Index and it is in a suspended State and a PAGEIOLATCH_EX Wait Type.
Percent Complete steady at zero percent.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2014 at 11:42 am
Ed Wagner (6/24/2014)
Did you drop your nonclustered indexes first?For details on CXPACKET, Paul's blog on wait stats is at http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/.
No, I've been bad.:-)
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 24, 2014 at 11:29 am
I got myself in a bind.
I performed a rebuild of Indexes on all tables in a Database.
The Database grew in size from 406 GB to .9 TB.
I shank it as...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 19, 2014 at 7:26 am
I made a Decision to rebuild indexes to reduce fragmentation.
I caused the Database to grow big time.
So I set all of the indexes gill factor to 100 percent.
The Database is...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
June 18, 2014 at 3:07 am
Viewing 15 posts - 826 through 840 (of 3,738 total)