Viewing 15 posts - 9,451 through 9,465 (of 49,552 total)
Jeff Moden (4/1/2014)
I'm curious. Why wouldn't it run as fast as a normal table that's been cached?
No idea (and no 2014 to play with). Could have to do 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
April 2, 2014 at 12:05 am
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
PythonThanks, Gail.
That's rather an old language, not a new one - I guess you meant new to you, rather than new in itself.
Indeed.
Besides, more languages =...
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
April 1, 2014 at 4:48 pm
Steve Jones - SSC Editor (4/1/2014)
GilaMonster (4/1/2014)
Hey Steve (if you're listening), can I indirectly toss some flames into that WIT editorial comments?Skiing today, but enjoy.
Hehe, permission to throw flames 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
April 1, 2014 at 4:32 pm
TomThomson (4/1/2014)
But I'll probably get my wrist slapped if I let myself say clearly what I feel.
I restrained myself from being rather insulting. I'd say as long as you don't...
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
April 1, 2014 at 4:24 pm
In-memory OLTP (hekaton) is for heavy concurrent load (tens of thousands of concurrent connections with thousands of inserts/sec). The advantage is the lock-less, latch-less optimistic concurrency. It's not a silver...
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
April 1, 2014 at 4:19 pm
Oh wow....
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
April 1, 2014 at 3:06 pm
No.
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
April 1, 2014 at 2:34 pm
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
Ok..."The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"
and the string data type is 'str'
So what is 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
April 1, 2014 at 1:06 pm
jcrawf02 (4/1/2014)
TomThomson (4/1/2014)
GilaMonster (4/1/2014)
Ok..."The language is expressive, easily readable and values explicitness. Abbreviations and corrupted spelling should be avoided in variable names"
and the string data type is 'str'
So what 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
April 1, 2014 at 1:02 pm
SQLRNNR (4/1/2014)
GilaMonster (4/1/2014)
Hey Steve (if you're listening), can I indirectly toss some flames into that WIT editorial comments?More flames than already brewing?
I was thinking of posting an OH: on twitter...
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
April 1, 2014 at 11:44 am
Hey Steve (if you're listening), can I indirectly toss some flames into that WIT editorial comments?
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
April 1, 2014 at 11:29 am
As long as the drive letter and path are absolutely identical, and SQL has full access to the folder, that will work fine.
Take a backup first, for paranoia sake.
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
April 1, 2014 at 10:29 am
The mentioned article: http://www.sqlservercentral.com/articles/Administration/64582/
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
April 1, 2014 at 10:27 am
skeleton567 (4/1/2014)
Let me relate my real own experience with yardsticks. The largest salary increase I ever achieved without changing jobs was by using MY OWN yardstick.
Good for...
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
April 1, 2014 at 10:25 am
yuvipoy (4/1/2014)
Can we change Simple recovery model to bulk logged recovery model in runtime, and again bring back to simple mode after the deletion process is over?
You can, but 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
April 1, 2014 at 10:14 am
Viewing 15 posts - 9,451 through 9,465 (of 49,552 total)