Viewing 15 posts - 28,126 through 28,140 (of 49,552 total)
As long as you have a single sysadmin login (windows authentication one is probably good) you can change the passwords. If you don't, then restart SQL in single user mode...
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 27, 2011 at 2:50 am
tina_tysinger (1/26/2011)
What is this demon???? :crazy:
It's the query that activity monitor runs to get the current server activity.
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 26, 2011 at 2:43 pm
LutzM (1/26/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
January 26, 2011 at 2:27 pm
Since you seem intent on pulling the whole story out bit by bit, line by line...
I'm just not seeing a future here at the moment. The IT industry is 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 26, 2011 at 2:25 pm
JacekO (1/26/2011)
Wow,Now instead of giving me a fish you are trying to send me out to sea with a net... 😉
And instructions. 😀
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 26, 2011 at 1:51 pm
CirquedeSQLeil (1/26/2011)
Gail, you trying to get on at RedGate too?
No, but...
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 26, 2011 at 1:32 pm
It's been like that since at least the storage engine rewrite before last. That's SQL 7. Maybe before, I have no familiarity with SQL 6.5
As for the slot array on...
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 26, 2011 at 1:26 pm
Stefan Krzywicki (1/26/2011)
Where the hell did January go? I think it might have been buried in snow and I missed it.
Wasn't the snow. I missed most of it too, 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
January 26, 2011 at 1:13 pm
The cost is an estimate. There are many things that can make it wrong, incorrect row count estimates being the most common
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 26, 2011 at 1:04 pm
JacekO (1/26/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
January 26, 2011 at 12:56 pm
Your query is wrong. Add the predicate index_id IN (0,1) or you'll get multiples of the row count if there are any nonclustered indexes.
One row per table, per index, per...
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 26, 2011 at 10:20 am
Accepted.
Just know that your reply was extremely discomforting.
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 26, 2011 at 9:07 am
dp75 (1/26/2011)
- Is there definitely no way of recovering the master database in this situation? If not...
No way. Restore or rebuild
- Before rebuilding must the faulty master mdf and ldf...
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 26, 2011 at 8:58 am
Looks like some pages were deallocated without cleaning up the surrounding structures. On SQL 2000 that could happen when running a checkDB with repair, not sure how it could happen...
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 26, 2011 at 7:47 am
There's a type of allocation page called the DCM - the differential change map. It maps which extents have changed since the last full backup. Those extents are the only...
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 26, 2011 at 7:45 am
Viewing 15 posts - 28,126 through 28,140 (of 49,552 total)