Viewing 15 posts - 45,151 through 45,165 (of 49,552 total)
julie taylor (8/6/2008)
The other object's name is syskeys, and the type is S.
Are you sure about that? The objectIDs look too high for system objects (which is what type S...
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
August 11, 2008 at 9:32 am
Have a look at this entry on Paul's blog. It may help you
Just be very careful and make sure you have a backup before you start. It's easy to break...
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
August 11, 2008 at 9:28 am
Update the statistics of any database that you upgrade from SQL 2000 to SQL 2005.
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
August 11, 2008 at 9:21 am
Adam Zacks (8/11/2008)
WOW just read that... did they get it sorted? Thank goodness I have never had this sort of issue.
Nope. DB was completely unrecoverable, despite several hours of...
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
August 11, 2008 at 9:21 am
Something like this should work. Haven't tested.
SELECT col1, col2, CAST(NULL AS int) as AddedCol1, CAST(NULL as varchar(100) as AddedCol2, col3, col4 INTO SomeOtherTable
FROM SourceTable
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
August 11, 2008 at 6:42 am
Yup.
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
August 11, 2008 at 6:38 am
Looks like DOMAIN\bkumar doesn't have login rights on SQL Server. Just because its a local administrator doesn't mean that it has login rights to SQL.
Go into the SQL logins 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
August 11, 2008 at 6:38 am
Adam Zacks (8/11/2008)
Is that for the db, log or both? Thought it was the db but now doubting myself :S
I don't quite understand the question. Elaborate more please?
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
August 11, 2008 at 6:32 am
Adam Zacks (8/11/2008)
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
August 11, 2008 at 6:31 am
The login is a server-level principle. All that gets you is access into the server and (possibly) rights to server-level objects and permissions (logins, linked servers, jobs)
The database user links...
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
August 11, 2008 at 6:22 am
Andras Belokosztolszki (8/11/2008)
And a link for further reading: http://msdn.microsoft.com/en-us/library/ms178052.aspx
Regards,
Andras
Or my semi-rant on the matter - http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
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
August 11, 2008 at 6:14 am
Adam Zacks (8/11/2008)
Very business oriented Gail?
Acceptable data loss is one of the main things that determines whether or not log backups are necessary and how frequent they should be....
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
August 11, 2008 at 6:10 am
How much data loss is acceptable if a drive fails or the database becomes corrupt?
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
August 11, 2008 at 5:15 am
Generally the log file should be on a separate physical drive from the data files, TempDB should have its own physical drive and the OS+ swap file should be 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
August 11, 2008 at 1:31 am
Without table structure and indexes, difficult to say much more than has been said.
What are you planning to do with those half a million records?
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
August 11, 2008 at 1:25 am
Viewing 15 posts - 45,151 through 45,165 (of 49,552 total)