Viewing 15 posts - 13,996 through 14,010 (of 49,552 total)
PiMané (3/7/2013)
GilaMonster (3/7/2013)
Really? Have you tried that?Not with indexes... just some more "sensible" data (accounts, orders, ...) and "fixed" data (like countries, regions, currencies, ...).
You might want to try that...
March 7, 2013 at 11:09 am
Please note: 11 year old thread.
March 7, 2013 at 10:26 am
PiMané (3/7/2013)
March 7, 2013 at 10:21 am
The one file/ x cores is for TempDB, not for user databases.
Unless you have reason to split a user database for recoverability or IO issues, you probably don't want...
March 7, 2013 at 9:46 am
Grant Fritchey (3/7/2013)
GilaMonster (3/7/2013)
Unless the data's small enough it can manage entirely within the memory grant. Not much chance of that except with trivial data.
Not arguing, just clarifying, won't it...
March 7, 2013 at 9:45 am
SQL Show (3/7/2013)
anthony.green (2/14/2013)
March 7, 2013 at 9:41 am
From Books Online:
Under the simple recovery model, file backups are basically restricted to read-only secondary filegroups.
You can take filegroup backups of a database in simple recovery, but they'll be...
March 7, 2013 at 9:40 am
Read uncommitted, the isolation level that should be called 'Potentially inconsistent data'
See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
March 7, 2013 at 9:37 am
Grant Fritchey (3/7/2013)
The query engine will do what it does. That's in the internals. No way to know without a debugger or insider knowledge. It will use tempdb though.
Unless the...
March 7, 2013 at 9:27 am
Stuart Davies (3/7/2013)
Try it on a test system with the real...
March 7, 2013 at 3:11 am
Dung Dinh (3/7/2013)
GilaMonster (3/7/2013)
Dung Dinh (3/7/2013)
2 - If both are big, you should use second solution and index the columns on ON clauseNot true.
I mean that the second is preferred...
March 7, 2013 at 2:54 am
Well the optimiser won't use any algorithm. The optimiser optimises queries, it doesn't run them.
Why does it matter?
March 7, 2013 at 2:40 am
Dung Dinh (3/7/2013)
2 - If both are big, you should use second solution and index the columns on ON clause
Not true.
March 7, 2013 at 2:04 am
There are two reasons why a database goes into the recovering state. SQL is restarted or the database is being closed and reopened (offline, autoclose, etc).
Check the logs, ensure that...
March 7, 2013 at 2:01 am
Viewing 15 posts - 13,996 through 14,010 (of 49,552 total)