Viewing 15 posts - 24,676 through 24,690 (of 49,552 total)
Do note that the information there is since the last time the database was started....
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
July 26, 2011 at 10:56 am
Pity. If it appeared as an error on SQL 2000 it would be fixable...
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
July 26, 2011 at 10:54 am
That is NOT from SQL 2000. That's a SQL 2005 CheckCatalog output. Saw that already, don't need it.
Back on the SQL 2000 server, run this
DBCC CheckCatalog
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
July 26, 2011 at 9:58 am
They're not bad. They used to be bad back in SQL 7 (or maybe 6.5), that's where the story that they are bad originates. It's not true any longer, hasn't...
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
July 26, 2011 at 9:07 am
DBCC runs clean on SQL 2000 because it does not run CheckCatalog. CheckDB on SQL 2005 does.
Back on the SQL 2000 server, run this
DBCC CheckCatalog
Post the results.
There is no...
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
July 26, 2011 at 9:03 am
george sibbald (7/26/2011)
To my mind the documentation leads you to think the restore of model would be possible.`
Exactly why I thought it would work...
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
July 26, 2011 at 8:59 am
Ok, I thought you were saying the server wouldn't even start.
george sibbald (7/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
July 26, 2011 at 8:25 am
GSquared (7/26/2011)
GilaMonster (7/26/2011)
SQLkiwi (7/26/2011)
GilaMonster (7/26/2011)
I'd comment, but it might be a little abrasive...* groan *
Pun not intended.... 😀
Why do I not believe you on that point? 😀
Seriously, I didn't. For...
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
July 26, 2011 at 6:59 am
Where do you store the backups?
What happens if the server room becomes unavailable (power outage, fire, etc)?
Can you restore the backup and keep to your downtime SLA?
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
July 26, 2011 at 6:46 am
Which DMVs?
DMVs aren't populated from system views, they're views into internal data structures.
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
July 26, 2011 at 6:45 am
Only while I load up Management Studio, write and test it.
INSERT INTO #TempB (SOFTWRARE_ID, LOGIN_ID)
SELECT SOFTWRARE_ID, LOGIN_ID
FROM
(SELECT SOFTWRARE_ID,LOGIN_ID, COUNT(*) OVER (PARTITION BY SOFTWRARE_ID) AS LoginCount FROM #TempA)sub
WHERE LoginCount>1
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
July 26, 2011 at 6:43 am
Query sys.databases. It's a database, it'll appear in there.
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
July 26, 2011 at 6:26 am
Ninja's_RGR'us (7/26/2011)
ramineni.suresh661 (7/26/2011)
With above reply it Giving following Error Message
Column '#TempA.LOGIN_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP...
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
July 26, 2011 at 6:26 am
SELECT <column list>
FROM <Table Name>
ORDER BY <Ordering Column>
where the placeholders get replaced by whatever the columns and table 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
July 26, 2011 at 6:17 am
SQLkiwi (7/26/2011)
GilaMonster (7/26/2011)
I'd comment, but it might be a little abrasive...* groan *
Pun not intended.... 😀
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
July 26, 2011 at 6:09 am
Viewing 15 posts - 24,676 through 24,690 (of 49,552 total)