Viewing 15 posts - 2,326 through 2,340 (of 3,738 total)
You may want to consider Rebuilding the Indexes depending upon the level of fragmentation.
It will Update the Statistics when the index is rebuilt.
September 3, 2011 at 9:14 pm
bitbucket-25253 (9/3/2011)
These articles by Gail Shaw may assist.http://www.sqlservercentral.com/articles/64582/
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
And this about what CHECKPOINT can and can not accomplish
I got "Page Not Found" on the first and third link.
September 3, 2011 at 8:21 pm
I found your article "Is a clustered index best for range queries?"
http://sqlinthewild.co.za/index.php/2011/02/01/is-a-clustered-index-best-for-range-queries/
I also found an article written by Kimberly Tripp.
http://www.sqlskills.com/blogs/kimberly/post/The-Clustered-Index-Debate-Continues.aspx
In my Microsoft study materials they suggest that a clustered index...
September 3, 2011 at 7:21 pm
GilaMonster (9/3/2011)
Welsh Corgi (9/3/2011)
The clustered index should be based on a column that you query on a range.
I would tend not to agree with that, nonclustered indexes are better for...
September 3, 2011 at 5:46 pm
You can identify the file by going into Configuration manager, click on SQL Server agent, advanced tab and then you will see it under "Dump Directory".
You may want to do...
September 3, 2011 at 8:13 am
I prefer a cave over a hut. It is cooler and you are protected from Thunder Storms.:hehe:
September 3, 2011 at 7:51 am
falcon00 (9/2/2011)
Grant Fritchey (9/2/2011)
So when do you need the old value again? I don't completely understand.
🙂
NEVER!!!
I know I know, that's what I said.
All they want is just to send...
September 3, 2011 at 7:11 am
manju3606 (9/3/2011)
Hi,I am using local account
You need to use a Domain Account with the proper permissions.
September 3, 2011 at 7:07 am
elham_azizi_62 (9/3/2011)
hi all.I enable databse for cdc and then want to enable tables for cdc but get error:insure that the correct database context is set .why?
Could you please provide the...
September 3, 2011 at 7:05 am
baglobalassociates (9/3/2011)
Source table '%s.%s' does not exist in the current database. Ensure that the correct database context is set. Specify a valid schema and table name for the database.
I do...
September 3, 2011 at 7:04 am
I'm not sure that this will help.
Public Sub copyRetangle(filename As String)
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oWsS...
September 3, 2011 at 6:59 am
You need a Non Clustered Index on FileName.
You should have a Primary Key. What columns make the record unique?
The clustered index should be based on a column that you query...
September 3, 2011 at 6:13 am
Hi Sam,
Could you please post your DDL?
September 3, 2011 at 4:53 am
Just an FYI, Microsoft announced last week that they are aligning themselves with ODBC.
OLE DB is being deprecated and Denali will be the last version in which OLE DB is...
September 3, 2011 at 4:33 am
Viewing 15 posts - 2,326 through 2,340 (of 3,738 total)