Viewing 15 posts - 32,791 through 32,805 (of 49,552 total)
You can change the password without knowing the old one, as long as you are a sysadmin (or a security admin and account you're trying to change is not sysadmin)
SQL...
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
May 20, 2010 at 11:57 am
Yang-703993 (5/20/2010)
That is why I am looking for maintain system tables, but it looks like mission impossible.
Won't help here. As I said, it's not about the size of 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
May 20, 2010 at 11:01 am
Interesting, not quite what I was expecting.
That's a table that stores info on what columns exist in what objects. Latches protect the physical structure of the page, so that two...
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
May 20, 2010 at 10:06 am
Swirl80 (5/20/2010)
GilaMonster (5/20/2010)
Grant Fritchey (5/20/2010)
I may be wrong here, but this:
ISNULL(pe.Col3, pe.Col4)is going to cause scans, either table or index, and you won't get seeks.
Yeah true. That as well.
Funnily...
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
May 20, 2010 at 10:01 am
Could you run this and post the results? It's an undocumented command to look at a database page's raw structure (in this case, just the header)
DBCC TRACEON(3604)
DBCC PAGE (5,1,11099981)
DBCC TRACEOFF(3604)
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
May 20, 2010 at 9:42 am
It's better to do neither.
Have you identified why the log is growing? Full recovery and no log backups?
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
May 20, 2010 at 9:37 am
See - http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx
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
May 20, 2010 at 9:07 am
Why do you want to shrink 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
May 20, 2010 at 9:06 am
That's not what I asked for. Need the wait_type and wait_resources please for processes that are waiting (ie suspended).
How many CPUs on this system? Is there only 1 file in...
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
May 20, 2010 at 8:56 am
Could you do some checks and see what the page latch waits are commonly on? The wait_resource in sys.dm_exec_requests. I have a suspicion that I want to verify.
How many files/filegroups...
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
May 20, 2010 at 7:57 am
Would you mind posting the definition of the table aliased as pe?
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
May 20, 2010 at 7:56 am
Grant Fritchey (5/20/2010)
I may be wrong here, but this:
ISNULL(pe.Col3, pe.Col4)is going to cause scans, either table or index, and you won't get seeks.
Yeah true. That as well.
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
May 20, 2010 at 6:52 am
No priority options exist. Either wait as it is now, or restart. I suspect something external from SQL's holding it up. Might be worth recycling MSDTC, see if that frees...
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
May 20, 2010 at 6:44 am
Swirl80 (5/20/2010)
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
May 20, 2010 at 6:43 am
1204 is not the best traceflag to use on SQL 2005 or higher.
Switch traceflag 1222 on. That will result in a more detailed deadlock graph been written to the error...
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
May 20, 2010 at 4:57 am
Viewing 15 posts - 32,791 through 32,805 (of 49,552 total)