Viewing 15 posts - 1,591 through 1,605 (of 3,221 total)
Before you perform as ALZDBA Posted Today @ 2:52 PM. You might want to delete the dependent tables before the Independent tables ... to list the dependent tables execute...
December 4, 2010 at 1:33 pm
The people here are all volunteers and are more than willing to provide a tested answer to your question, but to do so they need you to help them.
Your question...
December 4, 2010 at 11:19 am
With Jeff Moden Posted Today @ 10:58 PM
Jeff are you pulling another 40+ hour week?
Relax man, do you rXmas shoping.
December 3, 2010 at 9:06 pm
anolan
In addition to prior forum replies, may I also refer you to the following Blog post:
http://adventuresinsql.com/2010/09/how-is-fill-factor-impacting-my-indexes/
It contains sample code that returns a large amount of index data, and ...
December 3, 2010 at 9:01 pm
To deternine the extent of index fragmentation you may want to execute some code like: (this found in a SSC posting so long ago that I can not remember the...
December 3, 2010 at 2:47 pm
Try this
Select * From Information_Schema.Columns
or get what you appear to desire using:
Select Table_Schema,Table_Name,Column_Name,Data_type,Character_Maximum_Length
From Information_Schema.Columns
December 2, 2010 at 11:42 am
Have you considered running the 50,000/5,000 or so rows within a BEGIN TRANSACTION and COMMIT TRANSACTION?
What is your backup mode/schedule for this database?
November 30, 2010 at 7:53 pm
For those who may have missed it.
Jeff Moden waxes poetic
In days of old,
When Knights were bold,
And Windowing was not invented,
He wrapped his code
In a familiar mode
And RBAR was prevented....
November 25, 2010 at 7:17 am
It would assist those who would like to assist you if you would post the table definition, some sampe data and desired results from that sample data. Refer to...
November 24, 2010 at 2:34 pm
CirquedeSQLeil (11/24/2010)
Straight forward - thanks for the Question Ron.
See my other post, it is you who gave me the idea for the question, and I thank you for that, and...
November 24, 2010 at 10:54 am
By including this in my justification of the correct answer:
I owe the idea for this question from a blog post by:SQL RNNR - Cirquede SQLeil
I had hoped to...
November 24, 2010 at 10:50 am
stan-617410
Have to attend a meeting and must leave in a few minutes... will attempt to get back to assisting you .. but it might be tomorrow ...
Give serious thoughts to...
November 23, 2010 at 2:56 pm
1. Altered your table LoadTbls to include a unique value, in this case an identity column, so that I could pass in the specific load I required,
2. Inserted...
November 23, 2010 at 2:27 pm
Posting here on a forum .. has been going s l o w very s l o w ,
but eventually it...
November 23, 2010 at 1:09 pm
Viewing 15 posts - 1,591 through 1,605 (of 3,221 total)