Viewing 15 posts - 12,946 through 12,960 (of 49,552 total)
rajeev.training (5/31/2013)
1) Will snap shots work if the source database is truncated after the snapshot is taken.
If you mean TRUNCATE TABLE, yes. If you mean something else, maybe explain what...
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
May 31, 2013 at 7:28 am
Try this slight modification (IndexID is null for alter database events)
declare @TraceIDToReview int
declare @path varchar(255)
DECLARE @DatabaseName = 'Test' -- make this the database you're interested in.
SET @TraceIDToReview = 1 --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
May 31, 2013 at 7:22 am
PearlJammer1 (5/31/2013)
If i disable the sa account this will not effect these logins will it ?
No.
Therefore what is the difference between the actual sa account and logins that...
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
May 31, 2013 at 4:55 am
Error 32 is "File in use by another process." Find out what other process that is and stop it from using your TempDB files.
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
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
May 31, 2013 at 3:02 am
Shouldn't be any noticeable effects from different sizes of VLFs, if there are even any effects at all. It's large numbers of VLFs that cause a problem, and that 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
May 30, 2013 at 11:46 pm
Why?
In both cases you run the installer, click through and set all the options then let it install.
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
May 30, 2013 at 11:44 pm
I'd suggest a backup to disk first, should be faster, then that file can be backed up to tape later. Worth testing to see if it gets you your 3...
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
May 30, 2013 at 2:06 pm
I cheated. 😎
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
May 30, 2013 at 2:04 pm
And for those wondering about the 137, google - Fine Structure Constant and enjoy a lesson in quantum field theory.
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
May 30, 2013 at 2:01 pm
Apologies, didn't realise it was a quote
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
May 30, 2013 at 2:01 pm
Andre Ranieri (5/30/2013)
You've got me thinking that this is perhaps not so much an issue with SARGability as it is with parameter sniffing.
Correct, it's not. It's a mix of parameter...
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
May 30, 2013 at 1:54 pm
Are those file-based backups of the log or actual SQL log backups?
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
May 30, 2013 at 1:53 pm
A restore doesn't actually put anything into the log file, it's mostly empty after the restore completes.
Whether there's any parallel depends on how many database data files, how many files...
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
May 30, 2013 at 1:52 pm
Lowell (5/30/2013)
The products of 21 is 7 and 3.
[nitpick]
The factors of 21 are 7 and 3. The product of 7 and 3 is 21
[/nitpick]
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
May 30, 2013 at 1:48 pm
The Dixie Flatline (5/30/2013)
GilaMonster (5/30/2013)
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
May 30, 2013 at 1:26 pm
Viewing 15 posts - 12,946 through 12,960 (of 49,552 total)