Viewing 15 posts - 32,776 through 32,790 (of 49,552 total)
Please run the following and post the full, complete and exact output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
If you need urgent help, I suggest that you call Micrsoft's customer support...
May 23, 2010 at 4:23 am
Well I'm strongly in the 'clustered index to organise the table' camp, and do have reasons.
Firstly, note that these reasons are for OLTP-type systems. Lots of changes, lots of fast,...
May 23, 2010 at 2:38 am
If you want immediate help, consider hiring someone.
Your question is very wide, there could be any number of things wrong. Have you checked for blocking? Is there anything unusual...
May 22, 2010 at 6:25 am
May 22, 2010 at 1:55 am
Chris Mathews (5/17/2010)
May 21, 2010 at 11:36 am
Please post the query, table definitions and index definitions as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 21, 2010 at 4:25 am
Take a look through this article - http://www.sqlservercentral.com/articles/64582/
May 21, 2010 at 4:25 am
May 20, 2010 at 11:21 pm
nguyennd (5/20/2010)
What is order execute?1. Step1: TABLEA JOIN TABLEB
2. Step2: After JOIN, SQL execute WHERE
OR
1. Step1: SQL execute WHERETABLEA JOIN TABLEB
2. Step2: After WHERE, SQL execute TABLEA JOIN TABLEB
Depends on...
May 20, 2010 at 11:19 pm
kwiggans (5/20/2010)
May 20, 2010 at 11:18 pm
Probably. Can't say much more without more info. Do you have the query? If so, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 20, 2010 at 11:12 pm
Jack Corbett (5/20/2010)
I think it's borderline because they never asked me if they could grab my stuff and other sites like SSC and SQLServerPedia ask first.
Disagree. Republished without permission, without...
May 20, 2010 at 3:56 pm
CirquedeSQLeil (5/20/2010)
I was searching for the SQLSat Utah information and came across this blog. I am uncertain if it is RSS'd or if...
May 20, 2010 at 3:48 pm
Jeffrey Irish (5/20/2010)
In any case, rebuilding Indexes daily still sounds excessive to me.
Rebuilding all indexes, regardless of fragmentation is usually a waste. There are many good index rebuild scripts that...
May 20, 2010 at 1:23 pm
PaulB-TheOneAndOnly (5/20/2010)
That's not true. There is a Microsoft published way... research "sp_help_revlogin" - under your own responsibility.
That extracts the hashed password, it doesn't reverse the one-way hash and give...
May 20, 2010 at 12:53 pm
Viewing 15 posts - 32,776 through 32,790 (of 49,552 total)