Viewing 15 posts - 43,786 through 43,800 (of 49,552 total)
Well, that depends on whether you want your indexes to be selective or do you want them to be useful and used.
The clustered index benefits from unique values and an...
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
October 14, 2008 at 10:37 am
If your dev's getting an error, post the full error message here and we can help diagnose the cause.
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
October 14, 2008 at 10:32 am
A rebuild won't hurt. Whether or not it's necessary depends on where the rows you're deleting are in that index. If scattered all over the place, then a rebuild's not...
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
October 14, 2008 at 10:32 am
The question is do you want the theoretical result (where NULL, 1 and 1, NULL are both right) or the actual result that the current versions of SQL give for...
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
October 14, 2008 at 10:29 am
You don't need a where clause anywhere. If only 1 row is affected by the update, then inserted and deleted will have only 1 row in.
If there's a chance 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
October 14, 2008 at 6:43 am
Ok, that is odd.
What does this return?
DBCC SQLPERF(logspace)
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
October 14, 2008 at 6:41 am
As I said before, I've said what I think you should do. If you disagree, then I'm out of suggestions as I don't know what else you could do.
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
October 14, 2008 at 6:39 am
tochaturvedi (10/14/2008)
Hi Gail,Thanks for the reply.
I know that the above trigger will fire after insert action to the sometable and insert the records to someothertable.
Just the one column.
You used 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
October 14, 2008 at 6:10 am
virgo (10/14/2008)
can any one please let me know if there is any system table where i can find sql server error log details
other than general text error log file and...
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
October 14, 2008 at 5:40 am
tochaturvedi (10/14/2008)
The trigger should insert records into tables.I need only general examples.
CREATE TRIGGER trg_SomeInsert ON SOMETABLE
AFTER INSERT
AS
Insert into someothertable
Select somecolumn from inserted
GO
Does that help at 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
October 14, 2008 at 5:35 am
A snapshot doesn't just move the updated rows, it will copy the entire database to the subscriber every day.
Still, since it's not transactional it shouldn't have a big (if any)...
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
October 14, 2008 at 5:34 am
Index property works just fine there too.
select object_name(id), name from sysindexes where INDEXPROPERTY ( id , name , 'IsClustered') = 1
Use that within an openquery and it'll work. Or you...
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
October 14, 2008 at 5:30 am
amit (10/14/2008)
There is no transaction logs backup running.
Then why is the DB in full recovery? If you're in full recovery and have no log backups running, the transaction log...
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
October 14, 2008 at 5:28 am
Then the log file size isn't related to replication. Snapshot doesn't use the tran log. It just copies the entire DB to the subscriber. Since the DB's in simple...
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
October 14, 2008 at 3:56 am
What recovery model? Do you have log backups?
What type of replication? If transactional, is the log reader agent running properly?
What does the following return for the DB in question?
SELECT 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
October 14, 2008 at 3:33 am
Viewing 15 posts - 43,786 through 43,800 (of 49,552 total)