Viewing 15 posts - 7,801 through 7,815 (of 49,552 total)
WhiteLotus (9/15/2014)
I need to reduce the log file size to be very small . At the moment , the current size is 14 GB .
Why?
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
September 16, 2014 at 1:06 am
The minimum unit for a read or write to/from disk is the page. The row couldn't possibly be written alone, the page headers change when a row changes.
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
September 16, 2014 at 1:05 am
nam.lenhat (9/15/2014)
Can you help me...
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
September 16, 2014 at 1:00 am
TomThomson (9/15/2014)
replication replicates DML statements, and DDL statements on replicated objects are either forbidden or have special forms and/or restrictions.
It's got better. Alter table replicates now. Drop table isn;t...
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
September 15, 2014 at 6:44 pm
Stewart "Arturius" Campbell (9/12/2014)
Investigate the impact of a truncate table statement and it's interaction with a DDL trigger and post the results as either a QotD or an article.
That's easy....
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
September 15, 2014 at 6:39 pm
bob199214 (9/15/2014)
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
September 15, 2014 at 5:18 pm
It's because + is both the addition operator and concatenation operator.
When you say String + Int, SQL assumes you want addition, so it does CAST(String AS INT) + INT. If...
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
September 15, 2014 at 1:27 pm
Jack Corbett (9/15/2014)
GilaMonster (9/15/2014)
Out of line? (Me, I mean) http://www.sqlservercentral.com/Forums/FindPost1613791.aspx
I can see teh frustration coming out a bit, but I wouldn't say out of line. I'd 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
September 15, 2014 at 1:12 pm
use msdb;
go
select 'exec dbo.sp_updateJob @job_name = N' + (Char(39) + name + char(39) + ',') + '@enabled = ' + CAST(enabled AS CHAR(1)) from sysjobs
Cast the integer data type column...
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
September 15, 2014 at 1:09 pm
Out of line? (Me, I mean) http://www.sqlservercentral.com/Forums/FindPost1613791.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
September 15, 2014 at 12:55 pm
freddyism00 (9/15/2014)
yeah, the third and the fourth page in the data file, what exactly is the data file?
I already answered that
GilaMonster (9/15/2014)
freddyism00 (9/15/2014)
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
September 15, 2014 at 12:52 pm
Plenty of people know what those pages are, exactly where they are, what they do, etc. There's even a book that has a full chapter on the structure of 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
September 15, 2014 at 11:55 am
freddyism00 (9/15/2014)
ok, so can anybody tell me what a database file is ?
Um, the data files of a SQL database. The ones that by convention have a .mdf or...
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
September 15, 2014 at 11:44 am
1) If you mean the default trace, yes, providing the data is still in the trace. It's 5 files of 20MB each, no more.
2) You don't.
3) When SQL restarts or...
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
September 15, 2014 at 11:06 am
Looks like a rather bad design too.
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
September 15, 2014 at 10:22 am
Viewing 15 posts - 7,801 through 7,815 (of 49,552 total)