Viewing 15 posts - 33,061 through 33,075 (of 49,552 total)
No. They are used sequentially, first one, then the second. There's no striping of log writes (which you give you an improvement if there was more than one log file)
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 6, 2010 at 2:27 am
SQL has the ability to use an indexed view even if the view wasn't explicitly referenced in the query, if by doing so it can produce a cheaper plan and...
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 6, 2010 at 2:26 am
GilaMonster (5/5/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
May 6, 2010 at 2:19 am
It depends. 😀 (Did you really expect any other answer?)
If you do your index rebuild in bulk-logged recovery, the log may not need to be that big as rebuilds are...
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 5, 2010 at 4:01 pm
If the ALTER doesn't work, what error does it give?
Are the files read-write?
OS?
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 5, 2010 at 3:52 pm
Lynn Pettis (5/5/2010)
Didn't know you could run DBCC CHECK DB against a .bak file.
You can't. CheckDB can only be run against an actual database, not a backup. I belive Paul...
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 5, 2010 at 3:48 pm
mckinnj1 (5/5/2010)
I don't believe so.
Who's that in reply to? If it's in reply to my post, please feel free to explain why I'm wrong.
When we restore the 1 month...
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 5, 2010 at 2:22 pm
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
May 5, 2010 at 1:50 pm
adalberto-339588 (5/5/2010)
ALTER DATABASE DBNAMESET MULTI_USER;
That will change a database from single user or restricted user to multi user. If will not change a database from read-only to read-write.
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 5, 2010 at 1:46 pm
Is the mdf readonly? Is the database file in an encrypted or compressed folder? Does the SQL service account have full security permissions on that folder and on the 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 5, 2010 at 1:45 pm
To do that you need either all the log backups since that full backup (not a single one can be missing), or the database mush be in full recovery, must...
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 5, 2010 at 1:44 pm
Do note that R2 is not a patch or service pack. It's a new version of SQL that you will have to purchase licences for if you want to use.
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 5, 2010 at 10:02 am
How can it not be a table? You're referencing it in INSERT, UPDATE and SELECT statements
From the function that you posted:
INSERT INTO v_accounts_info_table( tempIdx , account_sequence ) VALUES (@v_account_id, @v_account_id)
SELECT...
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 5, 2010 at 9:08 am
Next time it happens, please, before you update the statistics, run a DBCC SHOW_STATISTICS and check if the last update was sampled or fullscan (rows compared with rows sampled). 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
May 5, 2010 at 9:07 am
While it doesn't address functions in the join/where, this is a look at how IN and joins compare:
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
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 5, 2010 at 8:55 am
Viewing 15 posts - 33,061 through 33,075 (of 49,552 total)