Viewing 15 posts - 36,841 through 36,855 (of 49,552 total)
Paul Randal (8/25/2009)
@Gail Yup - especially in Enterprise Edition. And yes, anything with write-access to SQL memory can cause this.
Interesting... What, other than in-process drivers and extended stored procs could...
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 25, 2009 at 6:19 am
When a query runs, needs to use statistics and those statistics are out of date. For what makes stats out of date, see Adi's post.
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 25, 2009 at 4:58 am
Dave Ballantyne (8/25/2009)
Go on then , im curious, how does it help security ?
Security by obscurity.
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 25, 2009 at 4:57 am
Please 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
August 25, 2009 at 3:11 am
Please read through this - Managing Transaction Logs[/url]
and don't even consider deleting the log. It's asking for lots of trouble.
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 25, 2009 at 3:05 am
That's the standard database startup messages. SQL will always print those in the log when it brings a DB online and opens it.
The things that will cause that are:
autoclose
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
August 25, 2009 at 3:02 am
t-jonat (8/25/2009)
WITH REPLACE, NORECOVERY and MOVE didn't work either, although I don't remember the exact error message and im not on that machine right now.
To offer any useful help, I'll...
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 25, 2009 at 2:59 am
Paul Randal (8/24/2009)
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 25, 2009 at 2:53 am
Can you post the actual messages from the error log? (cut and paste). That's not a standard CheckDB message, so I'm going to assume you're paraphrasing.
If it says something like
CHECKDB...
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 24, 2009 at 3:33 pm
jan.tilburgh (8/24/2009)
insert into test
(
testTIMESTAMP,
testVALUE
)
select
@newTimeStamp,
testValue + newValue
from test
order by
testtimestamp desc
If there are 4 rows in test at the point where that insert runs, how many rows should it insert? Currently it...
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 24, 2009 at 2:58 pm
Is the distinct really necessary? If there's no where clause, nothing limiting rows, you're probably going to get hash joins (that use TempDB) and the sort for the distinct will...
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 24, 2009 at 2:55 pm
Krasavita (8/24/2009)
1.The only way in 2000 to run optimization job:is offline?
I can't recall what settings the 2000 maint plan uses (if it uses) to decide index reorg vs index 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
August 24, 2009 at 9:53 am
In management studio, press F7. Select all the tables that you want to delete, press the delete key.
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 24, 2009 at 9:02 am
Some advice not directly related. Tell your colleague that it's better to own up to a mistake than for it to be discovered and for the boss to have to...
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 24, 2009 at 8:45 am
Did you do what the error message said? If not, please run the following and post the full output
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Do you have...
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 24, 2009 at 8:13 am
Viewing 15 posts - 36,841 through 36,855 (of 49,552 total)