Viewing 15 posts - 45,586 through 45,600 (of 49,552 total)
Some of those sound familiar.
The table in question also had 34 NC indexes, all with the same leading column, 80% with the same second column. The leading column of all...
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 18, 2008 at 6:37 am
All of them please. Zipped and attached it they're that big.
I'm less interested in the indexes it did use than the index it might not be using that could 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 18, 2008 at 5:47 am
Please post the table and index definitions.
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 18, 2008 at 5:41 am
I'll move my comment from the other thread, to keep everything together.
What you have there is a cross join. With no join conditions between the tables, each row in 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 18, 2008 at 5:38 am
As far as I know, the info about After/Instead of is just in the script of the trigger in SQL 2000.
SQL doesn't have a before trigger
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 18, 2008 at 5:23 am
sbalaven (7/18/2008)
I tried in SQL 2000 version. But it is not working.
You posted in the 2005 forums, hence I assumed you are using SQL 2005.
Please use the appropriate forum...
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 18, 2008 at 5:14 am
thiras (7/18/2008)
Why it is not possible to do so? Is because of any SS2k5 internal issue (security, administration, etc.)?Vlad.
Reliability. Modifying system objects cause assorted problems in SQL 2000 due...
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 18, 2008 at 5:09 am
free_mascot (7/18/2008)
You can't recover deleted rows unless and untill you are using checkpoint.
Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows 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 18, 2008 at 5:05 am
shiwani2002sg (7/18/2008)
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 18, 2008 at 4:49 am
SELECT OBJECT_NAME(object_id), name FROM sys.columns WHERE is_identity = 1
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 18, 2008 at 4:47 am
thiras (7/18/2008)
Hi all!Is there a way to alter system stored procedures in SQL Server 2K5?
No. Neither the system tables nor the system procedures can be modified in any way
Manipulating system...
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 18, 2008 at 4:43 am
Identity insert has to be set per table, and may only be on for one table at a time.
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 18, 2008 at 4:42 am
My favorite was a java-based messaging app that passed all string literals as N'... despite defining the table with varchar columns.
Net result, index scan of around a million rows to...
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 18, 2008 at 4:37 am
ALZDBA (7/18/2008)
We have recently had an issue where the same query on an equal table
one using nvarchar, the other using varchar. (indexes same indexes on both objects)
Implicit conversion issues?...
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 18, 2008 at 1:44 am
Thanks for mentioning that you were running on SQL 2000.
That particular query would be helped by an index on datep, however I thnk you have bigger problems than one query.
Is...
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 18, 2008 at 1:05 am
Viewing 15 posts - 45,586 through 45,600 (of 49,552 total)