Viewing 15 posts - 25,081 through 25,095 (of 49,552 total)
No. Indexed views, like indexes are maintained automatically as part of the transactions that modify the base tables.
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 7:36 am
Fal (7/7/2011)
GilaMonster (7/7/2011)
Fal (7/6/2011)
Well, I did have a hilarious! punch line all worked out. But then Gail went and ruined it all. :angry:
Major apologies. Was not my intention....
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 7:07 am
Sumanta Roy (7/7/2011)
No, I dont find any proper match for the database name.
What column? It is not going to be in the text data column for the reasons I mentioned....
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 6:31 am
No you won't, because the default trace doesn't capture any of the T-SQL events, so there's no T-SQL commands in the textdata column. You're looking for specific events that are...
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 6:11 am
See http://www.sqlservercentral.com/articles/Indexing/68563/ and http://www.sqlservercentral.com/articles/Indexing/68636/
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 6:05 am
Just as a 'by the way'. You don't need the distinct in the subquery 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
July 7, 2011 at 6:04 am
Sumanta Roy (7/7/2011)
The database was deleted today and found the same from schema change history report. But unfortunately I cannot get it from the default...
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 6:02 am
Fal (7/6/2011)
Well, I did have a hilarious! punch line all worked out. But then Gail went and ruined it all. :angry:
Major apologies. Was not my intention. Please, post...
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 5:06 am
Resender (7/5/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 4:25 am
lilywhites (7/7/2011)
i will look into making changes to stop tlog backups during the differentials until we are able to introduce a new backup system.
Why? They're able to work together 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
July 7, 2011 at 4:22 am
S_Kumar_S (7/7/2011)
I even tried it practically,...
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 4:06 am
S_Kumar_S (7/7/2011)
ok, but i am sure, clustered index always gets sorted data on key columns, without adding ORDER BY, Always.
The clustered index itself is always sorted. Queries that use it...
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:48 am
anthony.green (7/7/2011)
Also, would anyone recommend waiting until the Denali exams are released instead of taking the 2008 exams as I guess Denali is only really around the corner?
The exams can...
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:46 am
dso808 (7/6/2011)
The transaction log for database 'Logs' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc...
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:25 am
It'll be in the default trace, but that could have rolled over (it's only 5 files of 20MB). If the activity is such that the drop has been cleared from...
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:25 am
Viewing 15 posts - 25,081 through 25,095 (of 49,552 total)