Viewing 15 posts - 28,231 through 28,245 (of 49,552 total)
KMPSSS (1/24/2011)
I have small doubt in this,here i can only view one month data in that report. Is there any constraints in this one.Can you please give info about this
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
January 24, 2011 at 5:56 am
They get populated by SQLAgent (If I'm understanding your question correctly)
It's not generally recommended that you mess with the tables in the system databases. Why is this query a problem?
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
January 24, 2011 at 5:55 am
Fragmentation will not cause index scans where otherwise there could be an index seek. It would be a poor switch if it could, scans are far more affected by fragmentation...
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
January 24, 2011 at 4:25 am
The msdb job tables are not system 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
January 24, 2011 at 4:19 am
KMPSSS (1/24/2011)
Hi,Actaully i have tried below one, but i got only last one day results only. but i need to past 25 days records.
That just shows you queries...
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
January 24, 2011 at 4:12 am
It just has to do with the security identifier they use. They do not log in at all (system processes run internal in the engine) and hence won't be affected....
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
January 24, 2011 at 4:08 am
Unless you've had a server-side trace running for the last month, you cannot get this information. SQL does not keep a log of all queries unless you set one up.
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
January 24, 2011 at 3:40 am
System processes don't need to log in, so they are unaffected by any login changes. You can disable the sa account, it will have no effect on them. 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
January 24, 2011 at 3:39 am
Unless you had a trace or trigger present when the changes were made, you cannot go back and get details of what happened.
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
January 24, 2011 at 2:36 am
Nothing unusual about this at all.
When you have a subquery it's completely valid to reference columns from the outer table inside the subquery. If it wasn't it would be impossible...
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
January 24, 2011 at 2:29 am
paul s-306273 (1/24/2011)
I'd certainly go for Page Checksums, but do MS actually recommend that?
Yes.
Is it inferred that they are better because they also include torn page detection?
They don't include...
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
January 24, 2011 at 2:25 am
You can't create temporary databases in SQL.
What problem are you trying to solve?
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
January 24, 2011 at 1:10 am
Shawn Melton (1/23/2011)
This guy is borderline spamming or is really proud of the courses he took at this place. He is also posting to post that are 2 or more...
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
January 24, 2011 at 1:07 am
Please note: 5 year old thread
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
January 23, 2011 at 10:50 pm
Please note, 3 year old thread
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
January 23, 2011 at 10:50 pm
Viewing 15 posts - 28,231 through 28,245 (of 49,552 total)