network profile
| bio | website | hoyt.us |
|---|---|---|
| location | St Louis, MO | |
| age | ||
| visits | member for | 10 months |
| seen | May 22 at 18:51 | |
| stats | profile views | 8 |
I've been an generic Microsoft applications developer for 17 years. I started out doing simple Access 1.x programs (many years ago). For the last 10 years, I've primarily worked with various versions of .NET and SQL Server.
|
May 22 |
comment |
Dropping Hypothetical Indexes Thanks Mike. All of these are hypothetical so are not going to fall into any of these categories. Aside from this these are all non-clustered hypothetical indexes which are treated as a statistics for dropping. Ultimately they are not "real indexes". |
|
May 22 |
awarded | Commentator |
|
May 22 |
comment |
Dropping Hypothetical Indexes Hi Jason. Run SELECT * FROM sys.indexes WHERE is_hypothetical = 1 |
|
May 20 |
asked | Dropping Hypothetical Indexes |
|
Jan 25 |
comment |
Last Known Successful DBCC CHECKDB Martin, nobody else has chimed in and I'm satisfied with your answer. Can you post this as an answer so I can give you credit? |
|
Jan 18 |
comment |
Last Known Successful DBCC CHECKDB Martin, please put your response as an answer so I can give you credit. |
|
Jan 18 |
comment |
Last Known Successful DBCC CHECKDB Thanks Martin. You are right. It must depend on the level of corruption. I needed to run UPDATEUSAGE on the database. Once I did that it was all good. |
|
Jan 18 |
comment |
Last Known Successful DBCC CHECKDB Hi Martin...I added a sample above. The errors are all the same but in different tables. |
|
Jan 18 |
comment |
Last Known Successful DBCC CHECKDB Thanks Martin...my misunderstanding. |
|
Jan 18 |
comment |
Last Known Successful DBCC CHECKDB Hi Martin. I saw that but then a paragraph below that says ... "You need to look for the dbi_dbccLastKnownGood field. That was the last time that DBCC CHECKDB ran without finding any corruptions." |
|
Jan 18 |
asked | Last Known Successful DBCC CHECKDB |
|
Dec 4 |
awarded | Supporter |
|
Sep 19 |
comment |
Initializing Transactional Replication From Backup We are using straight 1 way transactional replication and I have verified the flag is set to false. I'm going to set it to true going forward but would like to understand its purpose. |
|
Sep 18 |
asked | Initializing Transactional Replication From Backup |
|
Aug 13 |
comment |
SQL Server Job History Disappears After 5 Days I love you Aaron (in a manly kind of way!) You are right...the numbers were set low and we have tons of jobs....problem solved! |
|
Aug 13 |
accepted | SQL Server Job History Disappears After 5 Days |
|
Aug 13 |
asked | SQL Server Job History Disappears After 5 Days |
|
Aug 7 |
awarded | Student |
|
Aug 7 |
awarded | Scholar |
|
Aug 7 |
comment |
Shrinking Reluctant Log Files Thanks Aaron...I had been doing this through the GUI. The script worked perfect. |
