Viewing 15 posts - 33,196 through 33,210 (of 49,552 total)
Ok, very different from Recovering...
Means that there's either a database restore in process, a restore has been done and the norecovery option specified, or someone has done a log backup...
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
April 2, 2010 at 4:44 am
There are two things that can cause the first run to be slower:
- Fetching of the data from disk rather than memory. Counter with CHECKPOINT and DBCC DROPCLEANBUFFERS
- Generation 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
April 2, 2010 at 3:21 am
The Dixie Flatline (4/1/2010)
Table variables aren't subject to logging.
It's perhaps better to say that they don't participate in transactions.
Table variable changes are still logged, they have to be (all...
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
April 2, 2010 at 3:17 am
Mani-584606 (4/1/2010)
So is that normal to have low PLE while running DBCC CHECKDB?
Absolutely. CheckDB reads every allocated page in the entire database, hence you're going to have a lot...
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
April 2, 2010 at 2:35 am
Recovering or restoring?
I ask, because on this thread you said recovering and on another you said restoring. Which is 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
April 2, 2010 at 2:33 am
CirquedeSQLeil (4/1/2010)
GilaMonster (4/1/2010)
Now I have someone whining about my april fool's blog post. 🙁
I enjoyed the blog post. I felt silly that I hadn't thought of a great 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
April 1, 2010 at 12:13 pm
It's not a bug.
CheckDB requires a consistent view of the database in order to do the check. In SQL 2005/2008 in order to do so, it creates a hidden 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
April 1, 2010 at 11:56 am
Try:
IF NOT EXISTS ( SELECT 1 FROM sys.columns WHERE [object_id] = OBJECT_ID('dbo.Service') AND [name] = 'NewColumn')
BEGIN
CREATE TABLE tmp_ms_xx_Service
(Column1 uniqueidentifier NOT NULL,
Column2 char(10) NULL,
Column3 varchar(100) NOT NULL,
Column4 char(1) NOT NULL,
NewColumn varchar(15)...
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
April 1, 2010 at 11:18 am
They're created when SQL encounters an access violation. If you're not interested in debugging or sending to CSS for debugging, you can delete.
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
April 1, 2010 at 11:15 am
GilaMonster (4/1/2010)
Now I have someone whining about my april fool's blog post. 🙁
Unless, of course, it was someone from twitter complaining 'cause I said I hadn't had a complaint. Email...
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
April 1, 2010 at 11:08 am
JustANumber (4/1/2010)
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
April 1, 2010 at 10:42 am
Now I have someone whining about my april fool's blog 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
April 1, 2010 at 10:40 am
Yes, but it's the switching to simple, not the shrink, that breaks the log chain.
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
April 1, 2010 at 10:25 am
Steve Howard-434180 (4/1/2010)
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
April 1, 2010 at 10:16 am
Stick a GO between the ALTER TABLE and the update. Otherwise, at parse-time, the column doesn't exist and throws an error.
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
April 1, 2010 at 10:15 am
Viewing 15 posts - 33,196 through 33,210 (of 49,552 total)