Viewing 15 posts - 27,271 through 27,285 (of 49,552 total)
p.s. When (if) you recover the DB, you maybe should take a read through this - Managing Transaction Logs[/url]
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
March 19, 2011 at 2:38 pm
Yup, that's about right.
Though you haven't seen one of the joke sessions going so....
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
March 19, 2011 at 2:37 pm
A critically important database with no backups that's suspect. Usually I'd say URLT, but not applicable in this case unfortunately.
What you did could not cause the suspect status. Recovery...
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
March 19, 2011 at 2:36 pm
nagireddy0024 (3/19/2011)
plz any one rply correct answer.
42?
What's the question?
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
March 19, 2011 at 11:25 am
As the error says, page level locking on that index has been disabled (not the default setting). See if you can find out why.
If it has to be disabled, then...
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
March 19, 2011 at 11:25 am
What distinguishes the first 3 rows from the latter 3 rows?
There are ways, but they are odd. What's the reasoning behind this?
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
March 19, 2011 at 7:20 am
jswong05 (3/19/2011)
%DiskTime is 7358% does not make sense if the tool measurment is correct. I am saying over 100% does not make sense.
http://support.microsoft.com/kb/310067
Hence the reason why the disk 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
March 19, 2011 at 6:58 am
GSquared (3/18/2011)
Tech greenie (3/17/2011)
...The text is variable and I cannot tell what the lines look like when they are typed....
I have to admit, this part of your post kind 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
March 19, 2011 at 4:27 am
Craig Farrell (3/19/2011)
GilaMonster (3/19/2011)
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.And your twitter handle is????
Was a bit nervous about throwing it out there, 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
March 19, 2011 at 4:18 am
There's no IO benefit, but you can still use the sliding window technique to quickly load the table with new data and quickly drop older stuff.
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
March 19, 2011 at 2:14 am
ALZDBA (3/18/2011)
I have no experience with the combination, but it is strange that the log replication also freezes when the mirror is down.
Question is, is it freezing or is 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
March 19, 2011 at 2:12 am
If you don't give us the messages you got, the chances of someone helping you are slim.
The command line to start SQL in restricted mode without bringing any DB other...
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
March 19, 2011 at 2:09 am
Each of those is a separate mdf or ndf file. Query sys.database_files, it'll show you the logical name (WSS_Content_01_5) and what the physical file name is.
What are you planning 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
March 19, 2011 at 2:05 am
Craig Farrell (3/18/2011)
Somewhere, the gods are laughing at me... I've started a twitter account.
And your twitter handle is????
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
March 19, 2011 at 2:02 am
SQL Native Access Client.
Google works, but the search terms aren't maybe the most intuitive
http://www.google.com/search?q=SNAC+SQL+Server
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
March 18, 2011 at 2:03 pm
Viewing 15 posts - 27,271 through 27,285 (of 49,552 total)