Viewing 15 posts - 19,756 through 19,770 (of 49,552 total)
Yeah, the LOB data cannot be moved if it's stored out of row (if you have LOB_DATA allocation units). There is no way to relocate that, the only option 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
March 14, 2012 at 1:55 pm
Stefan Krzywicki (3/14/2012)
GilaMonster (3/14/2012)
Gianluca Sartori (3/14/2012)
Back on topic, yes, they definitely are: http://www.sqlservercentral.com/Forums/FindPost1266924.aspx
Yes, I can think of a large number of ways not to use a linked server, most will...
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
March 14, 2012 at 12:57 pm
Gianluca Sartori (3/14/2012)
Back on topic, yes, they definitely are: http://www.sqlservercentral.com/Forums/FindPost1266924.aspx
Yes, I can think of a large number of ways not to use a linked server, most will probably be of...
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
March 14, 2012 at 12:36 pm
derekr 43208 (3/14/2012)
If the non-leaf pages are aware of the page split at the leaf pages then it knows the new location of the Value it's...
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
March 14, 2012 at 11:31 am
derekr 43208 (3/14/2012)
GilaMonster (3/14/2012)
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
March 14, 2012 at 11:27 am
jcrawf02 (3/14/2012)
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
March 14, 2012 at 11:14 am
jcrawf02 (3/14/2012)
Midichlorians never bothered me so much, I think they show up in some of the books somewhere, so I was ready for that one.
Not in any of the books...
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
March 14, 2012 at 11:05 am
Stefan Krzywicki (3/14/2012)
Stefan Krzywicki (3/14/2012)
GilaMonster (3/14/2012)
In release order. 4, 5, 6, 1, 2, 3
Rats, I don't remember where I saw the article, but I read a good one that 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
March 14, 2012 at 10:24 am
Yeah, that's just the initial encryption of the DB, that thread runs in the background encrypting the database file, once it's complete the thread goes away.
One thing to note with...
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
March 14, 2012 at 9:39 am
In release order. 4, 5, 6, 1, 2, 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
March 14, 2012 at 9:14 am
Pankaj Shere (3/14/2012)
I know there is a background thread which runs constantly once TDE is enabled.
There are a lot of background threads that run when they are needed and sleep...
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
March 14, 2012 at 9:13 am
Fragmentation will never cause SQL to not find a value where it's supposed to be (according to the index tree). If a value is not where it's supposed to be...
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
March 14, 2012 at 9:10 am
This will give you an error:
Update tbl1
set tbl1.Field1 = (SELECT tbl2.field1 from tbl2 where tbl1.id = tbl2.id)
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
March 14, 2012 at 9:08 am
terryshamir (3/14/2012)
from tbl2
where tbl1.id =tbl2.id
Would fail when there are multiples. The Server refuses to pick one value for tbl2.field2 at random.
when tbl1.id =tbl2.id is in...
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
March 14, 2012 at 6:53 am
anthony.green (3/14/2012)
you need to join sys.dm_db_index_physical_stats to sys.sysindexes
sys.sysobjects and sys.sysindexes are deprecated, included only for backward compatibility with SQL 2000 and should not be used in any new development....
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
March 14, 2012 at 6:48 am
Viewing 15 posts - 19,756 through 19,770 (of 49,552 total)