Viewing 15 posts - 25,096 through 25,110 (of 49,552 total)
S_Kumar_S (7/7/2011)
Select B,C from table_A, then is it always guarenteed that that my resultset will be sorted by B,C?
No
i am actually asking , does non clustered index sorts the data...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2011 at 3:23 am
No.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2011 at 3:19 am
rfrancisco (7/6/2011)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2011 at 3:00 am
It will stay a table lock. SQL escalates to reduce the resources required. It's not going to go and undo that and go back to the high resources used that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2011 at 2:57 am
What repair command did you run?
As I said, to fix those you will need to run CheckDB with repair_allow_data_loss. It will lose data but by this point that can't be...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2011 at 2:54 am
Commenting on an earlier post...
Execution plans are generated for the entire procedure first time it runs based on the parameter values on that execution.
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 2:48 pm
Yup.
Tested it. Open transaction with a couple million rows changed. Controlled shutdown (from within SQL ran the SHUTDOWN command). SQL shut down fairly fast, the transaction was rolled back...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 1:39 pm
I've already said it at least twice in this thread.
Long running uncommitted transactions.
Depending how long they've been running such a transaction could take hours or longer to roll back....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 1:14 pm
kingrudedog (7/6/2011)
The level of awesomeness is rediculous...
Apologies. We'll try to tone the awesome level down to crazy or below for you. :hehe: 😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 1:13 pm
The usage stats can't be explicitly cleared (it's the wait stats and one other only that can)
But yes, the usage stats show indexes used since that database last started up....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 1:12 pm
It's not hard.
1) Decide what the temp table must look like and write a CREATE TABLE.
2) Write a query that, for one database, gets the database_id, object_id, index_id, index name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 12:49 pm
One way is to define a temp table, then use sp_MSforeachDB to run a query in each database on the instance to insert DB_ID, Object-ID, Index_ID and Index_name into the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 12:27 pm
Shouldn't be a security issue. Those cause visible errors.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 12:02 pm
toddasd (7/6/2011)
GilaMonster (7/6/2011)
There are no other triggers on either table? Absolutely sure of that?
Exactly. There has to be an INSTEAD OF INSERT trigger on the archive table. Lowell and I...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 12:00 pm
Bliss (as in working from home mostly again)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 6, 2011 at 11:55 am
Viewing 15 posts - 25,096 through 25,110 (of 49,552 total)