Viewing 15 posts - 21,901 through 21,915 (of 49,552 total)
If you're doing partial restores the important thing to note is that the files must be brought up to date with the DB. You can't restore a file and leave...
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
December 5, 2011 at 3:23 pm
ALZDBA (12/5/2011)
- did you update all statistics
- did you perform dbcc updateusage
- did you perform full db maintenance
- did you run...
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
December 5, 2011 at 2:09 pm
Deja-vu... I've been working on these all day
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
December 5, 2011 at 2:08 pm
ddl triggers are in sys.triggers as they are database-scoped triggers. Server triggers however are not. Which database's sys.triggers would they go into?
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
December 5, 2011 at 2:02 pm
jcrawf02 (12/5/2011)
Did you guys see this? http://arstechnica.com/business/news/2011/12/bill-would-end-overtime-pay-requirement-for-many-more-it-workers.ars
One more reason I'm glad I'm not American...
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
December 5, 2011 at 11:33 am
krushkoder (12/5/2011)
So basically, what you are telling me is that there is nothing, to your knowledge, that will automate this process, correct?
There are automated test suites around, they're 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
December 5, 2011 at 11:32 am
If you have no clean backups... (and if not, there's something seriously wrong with your maintenance routine)
Script all objects, export all data, recreate the database
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
December 5, 2011 at 11:20 am
Comments going to the source blog is great. I often forget to check here and eventually find week-old comments on posts.
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
December 5, 2011 at 10:04 am
3604 and 3605 are used to direct certain output (like DBCC Page) to the client or the error log respectively. Some people/apps assume incorrectly that they are needed to get...
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
December 5, 2011 at 10:03 am
What traceflags are being turned on and off?
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
December 5, 2011 at 9:57 am
zorge (12/5/2011)
Yet, for some reason the LOGON trigger on ALL SERVER is not listed in sys.triggers.
No mysterious reason. Sys.triggers is for database-scoped triggers. You'll find server-scoped triggers in sys.server_triggers
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
December 5, 2011 at 9:50 am
% of CPU over what? The course of the stored proc execution? An hour? A day?
% of memory consumed - query workspace or query workspace + plan cache or query...
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
December 5, 2011 at 6:10 am
Btw, if you want tested and working code in the future, post the table definitions so that we can test the code.
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
December 5, 2011 at 6:01 am
It's already updating fine, but if you de-dupe the table you'll see the counts that you're wanting.
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
December 5, 2011 at 4:38 am
No, he's saying that the update statement is updating what you want, but since SQL won't update rows 2 or 3 or more times, if there are duplicate rows 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
December 5, 2011 at 4:32 am
Viewing 15 posts - 21,901 through 21,915 (of 49,552 total)