Viewing 15 posts - 20,656 through 20,670 (of 49,552 total)
Yes, of course the log can grow because of mirroring.
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
I'm not a mirroring expert, check the transmission and redo queues and maybe post another thread specifically...
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
February 1, 2012 at 6:20 am
No. All operations are logged always.
In simple and bulk-logged recovery models some operations can be minimally logged, but it's only a small subset of operations.
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
February 1, 2012 at 6:04 am
Why are you regularly shrinking the log?
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
February 1, 2012 at 6:03 am
Depends on the value of the setting in Profiler. Tools -> Options
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
February 1, 2012 at 6:02 am
David Conn (2/1/2012)
It was a good question but you shouldn't have to know these arcane default values
Personally my opinion is that you shouldn't have to know the defaults because you...
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
February 1, 2012 at 6:01 am
sqlzealot-81 (2/1/2012)
1. Why server side trace is better than SQL server?
Better than SQL Server? Don't understand
2. How can I schedule a server side trace from a local PC to Server?
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
February 1, 2012 at 1:02 am
Just bear in mind that the query given only returns data for queries whose plans are still in cache, and unless the queries are frequently run and the server has...
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
January 31, 2012 at 1:12 pm
Geoff A (1/31/2012)
what would be the result of the stored procedures that specifically use the SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED command.
They run in read uncommitted isolation level. The SET...
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
January 31, 2012 at 1:11 pm
SQL Kiwi (1/31/2012)
GilaMonster (1/31/2012)
jcb (1/31/2012)
Can You rely on a trigger to safe truncate the data to the column?No, because types are checked before triggers fire.
Yes, if you use a view...
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
January 31, 2012 at 11:29 am
jcb (1/31/2012)
Can You rely on a trigger to safe truncate the data to the column?
No, because types are checked before triggers fire.
CREATE TABLE tooSmall (
SomeCol VARCHAR(10)
)
GO
INSERT INTO tooSmall VALUES ('1q23u132838907432897289789247832948')
/*
Msg...
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
January 31, 2012 at 10:56 am
You can set ANSI_WARNINGS OFF, but it may have other effects that are not desired (like arithmetic overflow and divide by zero not throwing errors). Best option is to truncate...
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
January 31, 2012 at 10:53 am
With database mirroring (or even clustering) you can do near complete uptime even with patching.
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
January 31, 2012 at 10:48 am
Duran (1/31/2012)
Well not really, I was just using it as a way to join the tables.
The point is it doesn't join the tables. That's like joining employee to department 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
January 31, 2012 at 10:30 am
A locked down server doesn't make the service packs unnecessary. It'll help against security threats, but what about bugs that the service packs fix?
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
January 31, 2012 at 10:28 am
Some will be in the default trace for a while, but it's not retained forever. Probably best for you to set up some DDL triggers to audit exactly what 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
January 31, 2012 at 10:26 am
Viewing 15 posts - 20,656 through 20,670 (of 49,552 total)