Viewing 15 posts - 15,676 through 15,690 (of 49,552 total)
yuvach_74 (11/14/2012)
order by a required.i need the result should be as i mentioned
With the sample data you gave, the second max row when ordered by a will not give 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
November 14, 2012 at 1:21 am
Second maximum as ordered by what?
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
November 14, 2012 at 12:57 am
yuvipoy (11/14/2012)
you can get the time by running this query alsoSelect name,crdate from sys.sysdatabases where name='tempdb'
That gets you the time the SQL instance was last started, not the time...
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
November 14, 2012 at 12:48 am
The folder and/or files mentioned in those errors don't exist. Rectify that problem and restart 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
November 14, 2012 at 12:02 am
Then you need to restore the 10PM transaction log.
As the error said "The log in this backup set begins at LSN #, which is too recent to apply to 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
November 14, 2012 at 12:01 am
Upgrading from 2000 is a much bigger deal than from 2005, just because of the differences in the versions.
Before you upgrade the 2000 server, run the following:
DBCC CheckDB
DBCC CheckCatalog
If 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
November 13, 2012 at 3:18 pm
What are you migrating from? That's a very important point in planning.
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
November 13, 2012 at 2:43 pm
Grow the files, not increase the autogrow increment.
Autogrow is for when the DBA has messed up and not noticed that the DB files are nearly full and need to 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
November 13, 2012 at 2:20 pm
Not really enough info there.
To decide on a HA/DR setup you need to start with the data loss and downtime SLAs and go from there, also budget and some idea...
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
November 13, 2012 at 2:16 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1384282-5-1.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
November 13, 2012 at 2:11 pm
Why is the DB in emergency mode? How did it get there?
What errors are there for that DB in the error log?
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
November 13, 2012 at 2:09 pm
IgorMi (11/13/2012)
Hi,You may have space issues for your tempdb, or generally space issues, and then it is slow.
Lack of space will result in either the files growing or the rebuild...
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
November 13, 2012 at 2:06 pm
Is the rebuild/reorg blocked by something else? If so, it will be sitting doing nothing until whatever is blocking it has finished.
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
November 13, 2012 at 2:05 pm
Justify it on the basis that no maintenance is just plain bad practice.
If the DB is nearly full, you need to grow the files.
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
November 13, 2012 at 2:04 pm
Yup, because companies often won't hire DBAs with 0 experience (and those that do may well be companies you don't want to work for). They'll hire devs with 0 experience...
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
November 13, 2012 at 2:03 pm
Viewing 15 posts - 15,676 through 15,690 (of 49,552 total)