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...
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...
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...
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/
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...
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.
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...
May 30, 2013 at 2:06 pm
And for those wondering about the 137, google - Fine Structure Constant and enjoy a lesson in quantum field theory.
May 30, 2013 at 2:01 pm
Apologies, didn't realise it was a quote
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...
May 30, 2013 at 1:54 pm
Are those file-based backups of the log or actual SQL log backups?
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...
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]
May 30, 2013 at 1:48 pm
The Dixie Flatline (5/30/2013)
GilaMonster (5/30/2013)
May 30, 2013 at 1:26 pm
Viewing 15 posts - 12,946 through 12,960 (of 49,552 total)